https://bugs.documentfoundation.org/show_bug.cgi?id=161756
Bug ID: 161756
Summary: Data table: dates are unmanageable in some locale
combinations
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Chart
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
Configure your LibreOffice to use ru-RU locale, and en-US UI.
Open attachment 194920. In it, double-click the second chart to enter its edit
mode, right-click its area and select Data Table.
In the table's bottom, see item 27, which shows "30.04.2024", so the date order
is DMY.
Add a new line in the bottom, and type 29.04.2024 into Categories column, and
2,345 into the Y-Values column. Press arrow up.
Look at the chart. It updates, and the X axis changes its view: it starts to
show points' labels for each point, in the form of "07/24/..." (the previous
last point), and "29.04...." (for the new last point). Note how the new last
point (for April) is at the end, after the July , while it is expected to show
in the April, before June. See also, how the date format of the previous points
is different from what is shown in the data table.
In the data table, edit the "29.04.2024" date, and re-type it as "04/29/2024"
(so differently compared to the other points), and press arrow up. See how the
chart updates, the X axis normalizes, and the new point's data is shown at the
expected place. See also, how the data table's new point's category changes
into "29.04.2024".
Generally, this behavior makes it simply unmanageable. The date entry expects
en-US locale, but shows in ru-RU locale. The number entry expects ru-RU locale
(the comma is considered the decimal separator; otherwise, if it would expect
en-US locale, where the comma is thousand separator, the "2,345" would be
treated two thousand three hundred fourty-five, and the value would be not in
the 1-10 Y log range, but much higher - compare with simple "2345" entry).
--
You are receiving this mail because:
You are the assignee for the bug.
