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

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 ***