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: ---
Attachments:
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.

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

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

result:
cell(D5) eqs value cell(E1)

I have a sample file.

Rene
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
See:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=30558&p=140181#p140181

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 OpenOffice.org Calc saved xls file in MS Excel shows the cell ranges
in the conditional formatting statement corrupted. OpenOffice.org 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. ***