https://bugs.documentfoundation.org/show_bug.cgi?id=102945
Alex Thurgood <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEEDINFO
Ever confirmed|0 |1
--- Comment #5 from Alex Thurgood <[email protected]> ---
@stroy : when I open your file and then the table in Edit mode, I see that the
date field StartDate has been formatted as 01/01/00 and if I click on the
ellipsis button next to that formatting window, I get the usual LO number
formatter dialog. This dialog indicates that the field is configured as a
number and not a date (Category > Number, Format > Standard).
I left the default and then closed table edit mode and opened the Table
view/data entry mode where I can see the data already in the table. The first
and only line of data gives a displayed date value of 06/10/16.
What date value did you actually enter ?
I entered 07/01/20 as the date in a new entry, and some random text string. The
date displayed as 07/01/20, even after closing and re-opening the table.
If I click on the field header of the open table, and choose Column Format, I
get a dialog that indicates that the field is configured as a Date, and in the
DD/MM/YY format. If I change the language to English(USA), I get the default
date format of MM/DD/YY. This setting works for me and survives a shutdown and
reload of the ODB file.
Tested against
Version: 5.3.0.0.alpha0+
Build ID: 44170554cc9c0411c2ed6720fd09bedee2a9a162
Threads CPU : 2; Version de l'OS :Mac OS X 10.12; UI Render : par défaut;
Locale : fr-FR (fr_FR.UTF-8); Calc: group
I don't see a two day difference in date values.
What setting have you put in Calc for the default date under LibreOffice >
Preferences > Calc > Calculations > Date ?
Which time zone are you operating in ? The Java date function, which is what is
used in hsqldb (the default embedded database engine in ) to manage dates, is
known to be dependent on timezone corrections, which can lead to date display
offsets in LO Base (and thus incorrect display).
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
