Summary: | LibreOffice Calc: Dates Through Current Date Show As Percentage | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Dragon <afbali> |
Component: | LibreOffice | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED NOTABUG | ||
Severity: | normal | CC: | oliver.brinzing |
Priority: | medium | ||
Version: | 6.3.5.2 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=131524 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 87351 | ||
Attachments: |
Date as Percentage; Cleansed File
Date As Percentage Snapshot conditional_style |
Description
Dragon
2020-03-30 16:26:22 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. 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. |