Bug 122106 - FILEOPEN XLS, When you open a xls with a conditional formatting its missing.
Summary: FILEOPEN XLS, When you open a xls with a conditional formatting its missing.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: XLS-Conditional-Formatting
  Show dependency treegraph
 
Reported: 2018-12-14 12:54 UTC by NISZ LibreOffice Team
Modified: 2024-03-11 05:31 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
The original spreadsheet. (35.00 KB, application/vnd.ms-excel)
2018-12-14 12:54 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc. (315.50 KB, image/png)
2018-12-14 12:55 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2018-12-14 12:54:10 UTC
Description:
An xls with a conditional formatting goes missing when opened in LO. Note that this only a problem in xls it works fine in xlsx.

Steps to Reproduce:
    1. Create a new xls in Excel.
    2. Create a new conditional formatting rule.
    3. Save it and open it in LO.

Actual Results:
The conditional formatting is missing

Expected Results:
It should stay the way it was in Excel


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2018-12-14 12:54:37 UTC
Created attachment 147548 [details]
The original spreadsheet.
Comment 2 NISZ LibreOffice Team 2018-12-14 12:55:19 UTC
Created attachment 147549 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 raal 2018-12-16 16:34:32 UTC
Confirm with Version: 6.3.0.0.alpha0+ (x64)
Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 1; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-12-12_03:38:09
and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 4 QA Administrators 2022-08-28 03:34:07 UTC Comment hidden (obsolete)
Comment 5 Gabor Kelemen (allotropia) 2022-08-29 07:26:35 UTC
Still a problem in

Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 3cc6b870c48b23418f65d2c3cd6eab72ef0680de
CPU threads: 14; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: threaded