Issue 87900 - cannot set major interval to minutes if axis is formatted as date/time
Summary: cannot set major interval to minutes if axis is formatted as date/time
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
: 63455 90074 94838 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-04-04 23:25 UTC by Regina Henschel
Modified: 2013-02-24 21:19 UTC (History)
2 users (show)

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

Attachments
example document (22.06 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-11-20 11:37 UTC, IngridvdM 		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 Regina Henschel 2008-04-04 23:25:54 UTC 
I use OOo with German local on a German WinXP.

Create an x-y-chart with x-axis in date/time format, for example showing
23.01.2008 12:00 to 24.1.2008 15:00.
Insert all grids.
Now try to enter a value in the major interval, so that you get a major grid of
4 hours.

Enter 04:00
You get the error message "The major interval requires a positive number. Check
your input."
After clicking OK on the error message you see, that the input field has changed
to 0.16666666666667
Trying to use this as entry fails the same way. Using the German syntax
0,166666666666667 fails too.

Workaround:
Go to the Numbers tab and change format to number > standard.
Go to the Scale tab and enter the decimal number 0.166666666666667 or
0,166666666666667 respectively, depending on your local.
Go back to Numbers tab and change format back to date.

Expected behaviour:
If the axis is formatted as date/time, it should be possible to enter hours in
time syntax or at least as decimal fraction day.
Comment 1 kla 2008-04-07 09:58:30 UTC 
Hi Iha:
pls have a look.
Comment 2 kla 2008-06-02 12:22:29 UTC 
*** Issue 90074 has been marked as a duplicate of this issue. ***
Comment 3 amy2008 2008-08-29 02:59:49 UTC 
Checked in OOo300_m3_EN on WinXP.

Regina, 
I have checked it as what you described.
>Enter 04:00
>You get the error message "The major interval requires a positive number. 
>Check your input."
But there is no error message when I entered 04:00, then  switch to any other 
tab except Scale tab, return to Scale tab, you can find that the value has 
became 0.16666666666667.
So, I don't know it is relative to OOo build or Language settings.
Please check it in the latest build to reproduce this bug, ^_^

Li Meiying
Comment 4 Regina Henschel 2008-08-29 16:06:52 UTC 
The error is still there in OOo3.0 beta 3 on WinXp. It depends on the setting in
tools > options > Language Settings > Languages > Local setting. I've made some
test. For example

Finish
Danish
Greek
French (Belgium)
French (France)
Dutch (Netherland)

show the error and

German (Switzerland)
Italian (Italy)

are OK.
Comment 5 IngridvdM 2008-09-19 13:34:25 UTC 
Fixed in CWS calcchartrtl01. When time or date time formats are used at the axis
the intervals now can be entered with time format.
Comment 6 Regina Henschel 2008-10-22 20:29:51 UTC 
*** Issue 94838 has been marked as a duplicate of this issue. ***
Comment 7 IngridvdM 2008-11-12 15:52:18 UTC 
Moved fix to CWS rtlchart02.
Comment 8 IngridvdM 2008-11-20 11:36:03 UTC 
@Thomas, please verify in CWS rtlchart02.
Comment 9 IngridvdM 2008-11-20 11:37:00 UTC 
Created attachment 58143 [details]
example document
Comment 10 kla 2008-12-05 10:01:31 UTC 
Seen ok in cws rtlchart02 -> verified
Comment 11 kla 2009-03-18 18:18:25 UTC 
seen ok in current master -> closed
Comment 12 IngridvdM 2010-04-20 15:29:09 UTC 
*** Issue 63455 has been marked as a duplicate of this issue. ***