[Libreoffice-bugs] [Bug 125801] Date month and day being reversed

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Jun 8 16:44:12 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=125801

V Stuart Foote <vstuart.foote at utsa.edu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
          Component|Calc                        |Chart
                 CC|                            |erack at redhat.com
             Status|UNCONFIRMED                 |NEW

--- Comment #3 from V Stuart Foote <vstuart.foote at utsa.edu> ---
On Windows 10 Home 64-bit en-US with 
Version: 6.2.4.2 (x64)
Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

Verified user profile set with default Tools -> Options -> Languages Settings
-> Language: Date acceptance patterns of 'M/D/Y;M/D'

Enabling Chart OLE

Selecting and opening the x-axis dialog: on the Scale tab starting date and
ending date show 'MM/DD/YYYY', but on the dialog's Numbers tab the Date ->
Format Code is set to 'DDMMMYY' --which is the format the Chart shows.

With these settings:

using the spin buttons to adjust starting date, the actual date assigned is
erratic--flipping between MMDDYY and DDMMYY format--and looks like subsequent
button spin reparses the date while toggling back. Gets wrong dates as it
passes month threshold.

But, changing the X-Axis Numbers tab Date -> Format Code to 'YY-MM-DD' using
the spin button for the Scale cleanly increments and chart dates are correct
passing month boundaries.

So some weird juxtaposition of Date acceptance patterns and the Date format
used on chart axis?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190608/dd4bc8f4/attachment-0001.html>


More information about the Libreoffice-bugs mailing list