Bug 83666 - Opening this XLSX in Calc displays not all conditional formats:
Summary: Opening this XLSX in Calc displays not all conditional formats:
Status: RESOLVED DUPLICATE of bug 34412
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.1.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-09 12:50 UTC by squeezechart
Modified: 2015-09-10 15:18 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
XLSX spreadsheet (770.19 KB, application/vnd.ms-excel)
2014-09-09 12:50 UTC, squeezechart 		Details
spreadsheet opened in Excel 2010: (357.65 KB, image/png)
2014-09-09 12:52 UTC, squeezechart 		Details
spreadsheet opened in Calc 4.3.1.2: (269.13 KB, image/png)
2014-09-09 12:53 UTC, squeezechart 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description squeezechart 2014-09-09 12:50:59 UTC 
Created attachment 105978 [details]
XLSX spreadsheet

Opening this XLSX in Calc does not display all conditional formats:

1. wrong font in conditional formatted cells (all bold values seem to use Arial or Calibri instead of Futura);
font is not changeable and document contains hundreds of condional style templates (one for every cell?) - changing those also does not change font;
creating new template with other font also has no effect

conditional rule here is: cell value smaller or equal to =MIN(H$13:H$432)*1,1
     then use bold font

2. some conditional format rules are not displayed (see attached pictures) - all cells with yellow background (H19, i25, J24..)

conditional rule here is: cell value is =MIN(H$13:H$417) then use bold font and yellow background

spreadsheet opened in Excel 2010: http:\\www.squeezechart.com\xlsx.png
spreadsheet opened in Calc 4.3.1.2 http:\\www.squeezechart.com\ods.png
Comment 1 squeezechart 2014-09-09 12:52:38 UTC 
Created attachment 105979 [details]
spreadsheet opened in Excel 2010:
Comment 2 squeezechart 2014-09-09 12:53:15 UTC 
Created attachment 105980 [details]
spreadsheet opened in Calc 4.3.1.2:
Comment 3 GerardF 2014-09-23 20:16:15 UTC 
(In reply to comment #0)
About point 1, I fon't have Futura font on my OS...
and I think this bug (false font in CF opening Excel file) is already reported.
I don't have time to check now.. (sorry)

> 2. some conditional format rules are not displayed (see attached pictures) -
> all cells with yellow background (H19, i25, J24..)
> 
> conditional rule here is: cell value is =MIN(H$13:H$417) then use bold font
> and yellow background

You have 2 rules for the same range:
1st condition
------------- 
cell value smaller or equal to =MIN(H$13:H$432)*1,1
     then use bold font

2nd condition
-------------
cell value is =MIN(H$13:H$417) then use bold font and yellow background

In LibreOffice, conditions are tested (and applied if true) *one* by *one*.
If cell value is equal to =MIN(H$13:H$417), this same cell value is inevitably smaller then MIN(H$13:H$432)*1,1
So condition 1 is true → style for condition 1 is applied...

Conditions should be in reverse order.
Comment 4 Timur 2014-10-03 08:42:11 UTC 
AS Uncormfirmed, this cannot be in MAB, so I delete from mab4.3.
Comment 5 Buovjaga 2014-11-14 18:36:13 UTC 
(In reply to GerardF from comment #3)
> (In reply to comment #0)
> and I think this bug (false font in CF opening Excel file) is already
> reported.
> I don't have time to check now.. (sorry)

Did you mean bug 34412?
Comment 6 raal 2015-01-20 22:09:47 UTC 
Looks like duplicate of bug 34412

*** This bug has been marked as a duplicate of bug 34412 ***