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...
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:
Keywords: oooqa, rfe_eval_ok, usability
Depends on:
Reported: 2005-01-13 12:58 UTC by phil82
Modified: 2013-09-25 20:41 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

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

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

*** 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!
Comment 5 kla 2005-01-14 08:39:25 UTC
according to
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
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