Issue 110128 - conditional formating bug excel 2003 <--> calc
Summary: conditional formating bug excel 2003 <--> calc
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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.

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