Issue 110128

Summary: conditional formating bug excel 2003 <--> calc
Product: Calc Reporter: bug_rene <rene>
Component: save-exportAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOO320m12   
Target Milestone: ---   
Hardware: Other   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
sample file Excel 2003 <--> calc conditional formating none

Description bug_rene 2010-03-15 11:39:45 UTC
Apply conditional formating rule on a cell, has an onther behaviour if opened in
Excel 2003.

color font green and italic/bold if value eqs target.

cell(D5) eqs value cell(E5) 
I change manual cell($E$5) in cell(E5), so I can copy the condition to the other
save the file in xls. Open the file in Excel 2003.

cell(D5) eqs value cell(E1)

I have a sample file.

Comment 1 bug_rene 2010-03-15 11:41:28 UTC
Created attachment 68343 [details]
sample file Excel 2003 <--> calc conditional formating
Comment 2 keskival 2010-05-20 13:48:30 UTC

This issue concerns OpenOffice 3.2.0 and 3.2.1 RC.
The conditional formatting works fine with XLS files in OpenOffice 3.1.1.
Comment 3 keskival 2010-05-20 13:50:01 UTC
Opening the Calc saved xls file in MS Excel shows the cell ranges
in the conditional formatting statement corrupted. Calc show the
ranges correctly.

This seems to be a regression bug in xls file writing.
Comment 4 kvaky 2010-07-20 14:06:05 UTC
*** Issue 110128 has been confirmed by votes. ***