Issue 110128 - conditional formating bug excel 2003 <--> calc
Summary: conditional formating bug excel 2003 <--> calc
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOO320m12
Hardware: Other Windows XP
: P3 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-03-15 11:39 UTC by bug_rene
Modified: 2013-01-29 21:40 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

sample file Excel 2003 <--> calc conditional formating (11.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-03-15 11:41 UTC, bug_rene
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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. ***