Issue 49145 - values lower than 0.01 are not displayed correctly in scale tabpage for axis
Summary: values lower than 0.01 are not displayed correctly in scale tabpage for axis
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-05-12 14:05 UTC by ehamon
Modified: 2013-02-24 21:19 UTC (History)
3 users (show)

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

Attachments
samples and screenshots (108.81 KB, application/x-compressed)
2005-05-12 14:09 UTC, ehamon 		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 ehamon 2005-05-12 14:05:01 UTC 
Hi,
I join with this issue 4 files:
two screenshoots (OOo 1.9.100 and Excel counterpart screenshot)
2 files of sample. 
My english isn't fluent. See screenshots, it's very easy to do again the current
issue.
In the spreadsheet, i have data with hour format. I want to alter the X-Axis
'scale' from the chart. I want to begin with the first value of X-values. It's a
hour format. In the dialog-box, i enter '08:00:00' in the entryfield 'minimum'.
(12:00:00 for the 'maximum'). But when i try to enter an intervall value in the
format 'hour', it's rejected.
As Excel do, Ooo.spreadsheet converts entries (in hour format) in a decimal
float. (I think). 00:00:00 --> 0.0, 24:00:00 --> 1. Internal value for 1 hour is
1/24.
Great. the value corresponding to 1/24 is pasted to the field, then the chart is
correctly redrawn. But the dialog-box 'Axis settings' show a null value '0.0'.
It seems difficult to enter a very low value.

It's hard to enter an intervall with a very low converted value (less than 0.1).
A strange behavior that doesn't exist in Excel2000.
A bug in the format control of this entryfield? (rounding perhaps)

Best regards.
Comment 1 ehamon 2005-05-12 14:09:57 UTC 
Created attachment 26057 [details]
samples and screenshots
Comment 2 kla 2005-05-13 14:05:31 UTC 
Works in the current version. 
-> ehamon: Pls try to reproduce it in the current version. Remark: The 
screenshot shows the edit mode for the Axis Label, pls take care that the Axis 
are selected.
Comment 3 ehamon 2005-05-16 08:45:32 UTC 
Ooo 1.9.m100 (680_m100) Last public version available tested.
Strange behaviour remains.
First i installed OOo on Windows 2000 Pro. From here, I described the issue.
Next, i installed last day OOo at home on Windows XP Pro SP2 fr. In the
dialog-box  from X-Axis settings, i could enter the intervall value with hour
format. But when i close and open again this dialog box. The entryfield show
'0.0' as value. Not a decimal or a hour value (00:01:00 for a hour). The graph
is drawn correctly.
It isn't serious bug. Cosmetic, i think.
Enter '00:01:00' as value and quit the entryfield (by a tabulation). Then you
lose your value.
Regards.
Comment 4 kla 2005-05-17 08:45:55 UTC 
formatting issue
Comment 5 IngridvdM 2006-03-08 19:35:29 UTC 
I take this issue.
Comment 6 IngridvdM 2006-03-08 19:36:02 UTC 
accepted
Comment 7 IngridvdM 2007-07-30 17:50:04 UTC 
changed target
Comment 8 IngridvdM 2007-12-04 13:45:34 UTC 
This seems to be fixed already in the current master. I tested src680.m238. I
assume that it was fixed along with issue 56524 and issue 81259 in CWS chart11
integrated into SRC680.m226.
Comment 9 IngridvdM 2007-12-04 13:46:41 UTC 
->Thomas, please verify in current master.
Comment 10 kla 2007-12-10 14:25:42 UTC 
Seen ok in current master
Comment 11 kla 2007-12-10 14:26:06 UTC 
closed