Issue 40578

Summary: warn the user when choosing "logarithmic regression" with data series containing zero (0)
Product: General Reporter: phil82 <gillian.tiefenlicht>
Component: chartAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, robert.pollak, tony.galmiche.ooo
Version: 3.3.0 or older (OOo)Keywords: oooqa, rfe_eval_ok, usability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
A logarithmic regression is enabled but nothing to see none

Description phil82 2005-01-13 12:58:09 UTC 
Hi! I'm a biology student and have lots of diagrams that need a logarithmic
scale and regression to be evaluable. So I often get to the problem in
OpenOffice that the logarithmic parts of Chart are not working as they should.
When I need a logarithmic regression and click the button for it, nothing
happens. Linear expression works, but that doesn't help me. If you do a linear
regression when you have one logarithmic scale (let's say x-scale) you get a
curve (which is actually correct, though a logarithmic regression with a
logarithmic scale should be a line too). But when I try "logarithmic regression"
I don't get anything. Without that function Chart is not usable for natural
science analysis at all. I can send you an example-file if this bug is
unreproduceable, though I think it isn't.
Comment 1 phil82 2005-01-13 13:00:59 UTC 
Created attachment 21455 [details]
A logarithmic regression is enabled but nothing to see
Comment 2 kla 2005-01-13 14:56:12 UTC 
duplicate

*** This issue has been marked as a duplicate of 366 ***
Comment 3 kla 2005-01-13 14:56:42 UTC 
closed as duplicate
Comment 4 phil82 2005-01-13 16:51:27 UTC 
With due respect but this issue is NOT AT ALL a duplicate of 366. There may be a
certain connection between error bars and a regression line and actually both
functions are to enable at the same register card _but_ it is neverless a
complete different function. I do not deny that I was once annoyed about the
issue 366 as well but I found this bug more important. In Excel it is even
possible to show the calculated function of the regression curve!
Greetings
Phil
Comment 5 kla 2005-01-14 08:39:25 UTC 
according to http://www.openoffice.org/servlets/ReadMsg?list=releases&msgNo=7690
this issue will be set to OOoLater
Comment 6 lohmaier 2005-01-14 22:53:28 UTC 
Your data must not start with "0", then this will work.
You can show the data of the curve using the LINEST and LOGEST functions
Comment 7 phil82 2005-01-17 17:55:17 UTC 
cloph, you are right. That's it. Zero is not defined for a logarithmic scale.
There should be either an ignorance or an error message in this part of the
program, shouldn't there?
Comment 8 lohmaier 2005-01-22 10:31:53 UTC 
changed summary - original summary: "logarithmic regression doesn't work"
confirming, setting keywords, defaulting prio, defaulting TM
Comment 9 IngridvdM 2006-03-08 18:30:05 UTC 
I take this.
Comment 10 IngridvdM 2006-03-08 18:30:29 UTC 
accepted
Comment 11 bjoern.milcke 2006-06-23 14:04:52 UTC 
Changed Target to 2.x
Comment 12 bjoern.milcke 2006-06-23 14:50:20 UTC 
back to later
Comment 13 IngridvdM 2008-07-22 14:20:43 UTC 
reset to new