Bug 40530 - FILEOPEN MS Excel docmuent: 2nd condition for Conditional formatting missing
Summary: FILEOPEN MS Excel docmuent: 2nd condition for Conditional formatting missing
Status: RESOLVED DUPLICATE of bug 50463
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.3 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Markus Mohrhard
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-08-31 14:34 UTC by Marcin Opinc
Modified: 2012-08-06 18:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Spreadsheet created in MS Excel, one cell with two conditional formatting rules (29.50 KB, application/vnd.ms-excel)
2011-08-31 14:34 UTC, Marcin Opinc 		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 Marcin Opinc 2011-08-31 14:34:18 UTC 
Created attachment 50779 [details]
Spreadsheet created in MS Excel, one cell with two conditional formatting rules

Spreadsheet was created in MS Excel. There is one cell with two conditional formatting rules (D6). After opening in LO Calc second condition is missing completly.
Comment 1 Rainer Bielefeld Retired 2011-08-31 23:36:59 UTC 
[Reproducible] with "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]" and reporter's sample document.


'D6' should have 2 conditions:
 1) If value bigger than 'C6' then show format "Excel_CondFormat_1_2_1"
 2) If value smaller than 'C6' then show format "Excel_CondFormat_1_1_1"(?)

In sample document only condition 1 is visible 
If you change value in D6 to 2000 you see that Condition 1 works

D6 is red opening sample document with MS EXCEL Viewer and EXCEL 2010, so those programs recognize second condition and it seems not to be a damaged document problem.

Still reproducible with server installation of Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI [(Build ID: a6adae1-4eb4f62-09af278)]"

None of the .xls file type selections heals the problem

Also a problem with LibO 3.3.3 Portable and OOo 3.1.1, so problem seems to be inherited from OOo.

No problem when I save an own document with 2 conditions as .xls

@Kohei:
Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
Comment 2 Björn Michaelsen 2011-12-23 13:26:14 UTC 
Since all new unconfirmed bugs start in state UNCONFIRMED now and old unconfirmed bugs were moved to NEEDINFO with a explanatory comment, all bugs promoted above those bug states to NEW and later are automatically confirmed making the CONFIRMED whiteboard status redundant. Thus it will be removed.
Comment 3 Kohei Yoshida 2012-06-01 11:51:10 UTC 
I'll give this to Markus, since it's related to conditional formatting.
Comment 4 Markus Mohrhard 2012-08-06 18:32:18 UTC 

*** This bug has been marked as a duplicate of bug 50463 ***
Comment 5 Markus Mohrhard 2012-08-06 18:36:20 UTC 
So it a totally non obvious way this is a duplicate of Bug 50463.

Your test file uses two conditional formats with one entry each to express the two conditional formats. These would be two ScConditionalFormats mapped to the same cell which we can only support with overlaying conditional formats.

I'm sorry but this fix has to wait at least till 3.7