Issue 49335 - Importing .xls file with autoscaled log y-axis with values <1.0
Summary: Importing .xls file with autoscaled log y-axis with values <1.0
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL: http://www.physics.muni.cz/~mikulik/t...
Keywords:
Depends on:
Blocks:
 
Reported: 2005-05-16 10:15 UTC by mikulik
Modified: 2013-02-24 21:20 UTC (History)
3 users (show)

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

Attachments
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 mikulik 2005-05-16 10:15:01 UTC 
How to reproduce this bug:

1. In Excel:
   - make one column with values 1..100
   - make second column with exp(-first_column)
   - add graph of the second column with log scale on y-axis
2. Open the above file in OOo
   - there is no curve drawn -- the autoscaled range goes from
     1 to 10 instead of 1e-something to 1.0
   - further, there are strange tic labels on x-axis

The log scale is drawn OK for y-values larger than 1.0.

Enclosed:
- an Excel file with two columns and linear and log scale graphs
- screenshots of MS Excel 2000 and OOo 1.9.94.

Thanks for fixing this. Log graphs of values<1.0 are quite important
for scientific graphs of normalized intensities, for example.
Comment 1 oc 2005-05-19 12:09:28 UTC 
Hi Daniel, please have a look
Comment 2 daniel.rentz 2005-05-20 09:37:19 UTC 
DR->Mikulik: The labels on the X axis are there because you have created a simple 
line chart without setting a range for the labels. Excel and Calc use automatic 
labels then: Excel simply uses 1, 2, 3, ..., while Calc uses "Row 1", "Row 2", "Row 
3", ... (in Czech).
To workaround this, change the chart type to an XY chart (Excel: Scatter chart). 
Then you will get numeric labels on the X axis in Calc and Excel with the correct 
values (value range from 1 to 5, instead text labels from 1 to 50). Do not forget to 
include the first column into the source range.

To workaround the Y axis problem in the current OOo version, you can remove the 
Automatic flags for minimum and maximum in Excel.

DR->BM: The problem is the auto-scaling functionality in our chart module, not the 
Excel import filter. But I don't think this is important enough for 2.0.1 target. With 
my new auto-scaling it should work in Chart2 anyway ;-)
Comment 3 bjoern.milcke 2005-05-25 10:48:38 UTC 
The real problem for the weird y-axis scaling comes from the chart being
"stacked". If you choose the unstacked line (or better xy/scatter) chart the
scaling should be ok.
We will fix this in the new chart implementation, therefore I change the target.
Comment 4 IngridvdM 2007-07-30 18:00:12 UTC 
This bug was fixed with the complete re-implementation of the chart module
starting with version SRC680m213.
Comment 5 IngridvdM 2007-07-30 18:01:20 UTC 
Seen fixed in SRC680m213.
Comment 6 IngridvdM 2007-08-01 13:55:40 UTC 
Thomas, please verify on master and close.
Comment 7 kla 2007-09-20 08:57:50 UTC 
This bug was fixed with the complete re-implementation of the chart module.