Bug 149640 - wrong converting conditional formats while opening a XLSX-file
Summary: wrong converting conditional formats while opening a XLSX-file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.8.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Conditional-Formatting
  Show dependency treegraph
 
Reported: 2022-06-20 13:48 UTC by Peter Schulze
Modified: 2023-01-19 05:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
this calendar is built with Excel 2019 and conditional formats (177.48 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-06-20 13:48 UTC, Peter Schulze
Details
Screenshot of conditional formatting dialog preview vs. actual (198.28 KB, image/png)
2022-06-23 18:28 UTC, Scott Clewell
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Schulze 2022-06-20 13:48:35 UTC
Created attachment 180848 [details]
this calendar is built with Excel 2019 and conditional formats

Some conditional formatting is lost when opening an XLSX file. The number formatting is set to standard.
See attached file. Please have a look at holidays there are not converted as date.
Comment 1 Scott Clewell 2022-06-23 17:03:33 UTC
Thanks for reporting Peter.

I see what you mean using

Version: 7.1.8.1 (x86) / LibreOffice Community
Build ID: e1f30c802c3269a1d052614453f260e49458c82c
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

Could you please attach another copy of the file with the password protection turned off so it can be investigated farther?
Set the "status" of the bug report back to "unconfirmed" when you do.
Comment 2 Peter Schulze 2022-06-23 17:45:13 UTC
Hi Scott!

Sorry, I forgot that the sheets are protected. You can use "Kalender" for unlocking the protection in all sheets.

Peter
Comment 3 Scott Clewell 2022-06-23 18:27:12 UTC
Thanks Peter,
I can reproduce this and do feel it is a bug because the conditional formatting dialog shows a preview of the intended numbered date. I attached my screenshot to show this.
Comment 4 Scott Clewell 2022-06-23 18:28:31 UTC
Created attachment 180939 [details]
Screenshot of conditional formatting dialog preview vs. actual
Comment 5 Peter Schulze 2022-06-23 19:46:09 UTC
Comment on attachment 180939 [details]
Screenshot of conditional formatting dialog preview vs. actual

Hello Scott!
As an additional information for you: I've just tested the Collabora App on my Android tablet - the same issue.

Thanks for support.

Peter