Bug 155098 - [FILEOPEN] [CALC] Date is shown as 23 instead of 24
Summary: [FILEOPEN] [CALC] Date is shown as 23 instead of 24
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.2.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL: https://learn.microsoft.com/en-US/off...
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-05-01 08:08 UTC by thebudget72
Modified: 2023-05-01 09:38 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Spreadsheet file (8.88 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-05-01 08:09 UTC, thebudget72 		Details
LibreOffice screenshot (19.74 KB, image/png)
2023-05-01 08:09 UTC, thebudget72 		Details
Microsoft Excel screenshot (32.06 KB, image/png)
2023-05-01 08:33 UTC, thebudget72 		Details
Google Sheets screenshot (37.44 KB, image/png)
2023-05-01 08:33 UTC, thebudget72 		Details
View All 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 thebudget72 2023-05-01 08:08:51 UTC 
Description:
Microsoft 365 shows the date as 24.

LibreOffice Calc shows it as 23.

Interestingly also Google Sheets shows it as 23.

This led to a misunderstanding with a colleague.

Steps to Reproduce:
1. Open attached file in LibreOffice Calc
2. Open it in Microsoft Excel

Actual Results:
LibreOffice Calc renders the date as 23

Expected Results:
It should render the date as 24


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 20; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
7.5.2-1
Calc: threaded
Comment 1 thebudget72 2023-05-01 08:09:12 UTC 
Created attachment 187023 [details]
Spreadsheet file
Comment 2 thebudget72 2023-05-01 08:09:24 UTC 
Created attachment 187024 [details]
LibreOffice screenshot
Comment 3 thebudget72 2023-05-01 08:33:32 UTC 
Created attachment 187025 [details]
Microsoft Excel screenshot
Comment 4 thebudget72 2023-05-01 08:33:57 UTC 
Created attachment 187026 [details]
Google Sheets screenshot
Comment 5 Mike Kaganski 2023-05-01 08:38:48 UTC 
This is **not** a bug.

Excel has inherited an **own** bug from Lotus 123: it didn't acknowledge that year 1900 wasn't a leap year. Excel shows "1900-02-29" as a day, which in reality didn't exist.

Calc knows that after 1900-02-28 came 1900-03-01. But every date **before** that are offset **in Excel**.