[Libreoffice-bugs] [Bug 141472] UK format dates reduced by 4 years and 1 day when copied/moved to different spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from laurent combe <laurent.combe at free.fr> ---
in the original spreadsheet there is a specific option for date
go to the option menu (click on incon in the upper right corner)

in the menu, choose 'options ...', 'LibreOffice Calc' and 'calculate'
in this popup you have a section Date with 3 choices
in the Original Spreadsheet the '01/01/1904' option is selected

when you copy your data to another spreadsheet with the default option
(12/30/1899) your date appeared to be different with 4 years less

-- 
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/20210405/3d111a19/attachment.htm>