Download it now!
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: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2018-12-14 12:54 UTC by NISZ LibreOffice Team
Modified: 2018-12-16 16:34 UTC (History)
3 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)