Bug 131717 - LibreOffice Calc: Dates Through Current Date Show As Percentage
Summary: LibreOffice Calc: Dates Through Current Date Show As Percentage
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
Reported: 2020-03-30 16:26 UTC by Dragon
Modified: 2020-04-05 00:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Date as Percentage; Cleansed File (43.28 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-04-01 22:26 UTC, Dragon
Date As Percentage Snapshot (361.16 KB, image/png)
2020-04-01 22:29 UTC, Dragon
conditional_style (66.13 KB, image/png)
2020-04-04 19:36 UTC, Oliver Brinzing

Note You need to log in before you can comment on or make changes to this bug.
Description Dragon 2020-03-30 16:26:22 UTC
For Clarity: LibreOffice, Calc, Version; Win 10 Platform.

After recent update to the indicated version, Dates through the Current Date show as #######% regardless of formatting.  For instance, today is 03/30/2020; the date shows as 4392000%; tomorrow's date (03/31/2020) shows as 03/31/20 as formatted.  

Other notes:

This was observed on an existing spreadsheet, not a newly created one, but it holds for new ones as well.

Dates appear to calculate correctly, they just do not display correctly.

If a date is changed and this change adjusts a set of calculated dates, all dates equal to or before the current date change to the wrong display format.

Please feel free to contact me if you would like a screen shot or would like me to test a newer or older version.
Comment 1 Oliver Brinzing 2020-03-30 18:13:39 UTC
Thank you for reporting the bug. 

Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 2 Dragon 2020-04-01 22:26:43 UTC
Created attachment 159248 [details]
Date as Percentage; Cleansed File

This is a cleansed file showing the bug.  If there is something in this file I missed that might be problematic, I'd appreciate a note so I can correct it before it is too widely distributed.  Note: I will also post a screenshot of the error in action in case it does NOT duplicate when someone else opens the file.  Also note that the original creation date of this file is 2015 and it is updated to the new year, every year.  I have checked the old files (opened them) and they are now showing the same date-as-percentage issue.
Comment 3 Dragon 2020-04-01 22:29:03 UTC
Created attachment 159249 [details]
Date As Percentage Snapshot

This is a snapshot of the error.  I have posted a cleansed .ods file as well; be sure to read the description for additional information.  This snapshot is being posted in case the file does not show in this manner on some systems/versions/etc.
Comment 4 Dragon 2020-04-01 22:30:23 UTC
Added attachments and updated to UNCONFIRMED: 2020/04/01.
Comment 5 Oliver Brinzing 2020-04-04 08:52:12 UTC
This issue is a duplicate of:

Bug 131524 - Date format in a cell with conditional formatting turns to money

and no bug, cause conditional cell format handling changed with LO 6.3.

You need to adjust cell styles "ConditionalStyle_2" and "ConditionalStyle_3" cell format from percentage to date.
Comment 6 Dragon 2020-04-04 18:48:35 UTC
I apologize if the following is ignorance but 1) I didn't set up conditional formatting styles for the cells in this file and 2) it looks like one can just delete "ConditionalStyle_2" and "ConditionalStyle_3" instead of changing them.  Responding comments are very welcome.
Comment 7 Oliver Brinzing 2020-04-04 19:36:17 UTC
Created attachment 159334 [details]

Please have a look at the attachment and check via Menu Format/Conditional/Manage
Comment 8 Dragon 2020-04-05 00:27:55 UTC
Thank you, Mr. Brinzing, for all your help. I appear to have confused you.  I didn't mean that the two conditionals didn't exist, I meant that I didn't create them; I have no idea where they came from.  It appears that the easiest thing to do, however, is to go to Styles/Manage Styles (or F11) and simply delete the two conditional styles from the sheet.  If there is a reason to NOT do this please let me know.  And, again, thank you very much for your time, it is greatly appreciated.