Bug 148827 - [FILEOPEN] "Symbolic Link" SLK / SYLK incorrect date
Summary: [FILEOPEN] "Symbolic Link" SLK / SYLK incorrect date
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency tree / graph
 
Reported: 2022-04-27 19:11 UTC by SheetJS
Modified: 2023-06-05 15:34 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description SheetJS 2022-04-27 19:11:52 UTC 
Description:
The `O` record is for workbook options.  The `V` field stores the 1904 date setting.  Valid record values are 0 (1900) or 1,2,3,4 (1904)

Steps to Reproduce:
Save the following to test.slk and open:

ID;PWXL
P;Pd\/m\/yy
P;Pd\/m\/yyyy
O;D;V4
F;P0;FG0G;X1;Y1
C;K1
E


Actual Results:
Cell A1 is "31/12/99"

Expected Results:
Cell A1 is "2/1/04"


Reproducible: Always


User Profile Reset: Yes



Additional Info:
LO is also ignoring the 1900 leap year, but that is a separate issue
Comment 1 raal 2022-07-15 06:16:39 UTC 
Confirm the bug. In excel it’s "2/1/04"

Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: a93d7e7df6804cd6f1f2fa1ef0e6e95ce6c3752a
CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded