For Clarity: LibreOffice, Calc, Version 6.3.5.2; 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.
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.
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.
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.
Added attachments and updated to UNCONFIRMED: 2020/04/01.
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.
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.
Created attachment 159334 [details] conditional_style Please have a look at the attachment and check via Menu Format/Conditional/Manage
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.