Bug 148131 - the standard date format of NNNND MMMM YYYY add a spurious 0
Summary: the standard date format of NNNND MMMM YYYY add a spurious 0
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
7.1.4.2 release
Hardware: Alpha macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-03-22 07:33 UTC by Brian Quarterman
Modified: 2022-04-05 06:09 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Demonstrates the standard date formatting bug (19.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-03-22 07:33 UTC, Brian Quarterman 		Details
Screen shot of the format window which reflects the issue. (69.15 KB, image/png)
2022-03-22 07:54 UTC, Brian Quarterman 		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 Brian Quarterman 2022-03-22 07:33:47 UTC 
Created attachment 179023 [details]
Demonstrates the standard date formatting bug

Using the standard date format, in spreadsheet, NNNND MMMM YYYY produces an incorrect formatted date.  i.e.Thursday 1 June 20220
This has a spurious trailing zero.
Comment 1 Brian Quarterman 2022-03-22 07:54:31 UTC 
Created attachment 179025 [details]
Screen shot of the format window which reflects the issue.
Comment 2 Mike Kaganski 2022-03-22 09:57:10 UTC 
But your B1 contains literal "20220-04-01"?
Comment 3 Brian Quarterman 2022-04-05 05:57:15 UTC 
User error - cell contained a valid date with the addition character.