Issue 40578 - warn the user when choosing "logarithmic regression" with data series containing zero (0)
Summary: warn the user when choosing "logarithmic regression" with data series contain...
Status: CONFIRMED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa, rfe_eval_ok, usability
Depends on:
Blocks:
 
Reported: 2005-01-13 12:58 UTC by phil82
Modified: 2013-09-25 20:41 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
A logarithmic regression is enabled but nothing to see (7.71 KB, application/vnd.sun.xml.calc)
2005-01-13 13:00 UTC, phil82 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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