Issue 25653 - OpenOffice conditional formatting does not work in Excel
Summary: OpenOffice conditional formatting does not work in Excel
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All Linux, all
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-02-18 19:21 UTC by mancide
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
Testdocument for cond formatting (16.50 KB, application/octet-stream)
2004-02-20 10:57 UTC, frank 		no flags Details
Modified document showing a workaround (19.50 KB, application/vnd.ms-excel)
2004-05-19 16:38 UTC, daniel.rentz 		no flags Details
Another test case. Exporting this file to XLS. (16.38 KB, application/vnd.sun.xml.calc)
2004-09-30 19:50 UTC, bnordgren 		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 mancide 2004-02-18 19:21:20 UTC 
I use Microsoft Excel 2000 on windows and OpenOffice1.1 on Linux.
I have a document with conditional formatting.
When I save this document in Microsoft Excel and I open it in OpenOffice
everything works fine.

When I save this document in OpenOffice and I open it in Microsoft excel, the
conditional formatting is not executed... The formatting is still there, but I
have to access the conditional formatting menu for every cell press OK to
reactivate it again...
Comment 1 frank 2004-02-20 10:54:37 UTC 
Hi Daniel,

OC reproduced it on Calc18.

Frank
Comment 2 frank 2004-02-20 10:57:26 UTC 
Created attachment 13312 [details]
Testdocument for cond formatting
Comment 3 daniel.rentz 2004-05-19 16:18:13 UTC 
Accepted. Another example of wrong formula export. Cells in C20:C27 contain 
conditional formats with single references to other cells. These single references 
confuse the formula exporter... See also issue 3724.
Comment 4 daniel.rentz 2004-05-19 16:38:24 UTC 
Created attachment 15355 [details]
Modified document showing a workaround
Comment 5 oc 2004-05-28 12:29:02 UTC 
OC: Due to high workload this issue is retargeted to office.later
Comment 6 daniel.rentz 2004-09-27 16:26:18 UTC 
See also bugdoc of issue 34474.
Comment 7 bnordgren 2004-09-30 19:50:47 UTC 
Created attachment 18023 [details]
Another test case.  Exporting this file to XLS.
Comment 8 bnordgren 2004-09-30 20:01:23 UTC 
Ancillary data concerning my test case attachment:
1] Document created in OOo 1.1.2 on Windows
2] Document exported to xls by above platform and read by MS Excel 2000 on same 
platform.

Excel's complaint: "Conditional formatting cannot refer to cells on other 
sheets/workbooks".  Removing the "Sheet1!" part of the cell reference fixed 
this complaint.  (Note: "Sheet1!" was not a different sheet.)

OOo bug: The cell references are all messed up.  "A2" became "A65535"  "D2" 
became "A65535", etc.
Comment 9 daniel.rentz 2004-10-22 12:39:20 UTC 
fixed in cws SRC680/dr27 (OOo 2.0), tested all attached bugdocs
Comment 10 daniel.rentz 2004-10-22 12:40:14 UTC 
set target to OOo 2.0
Comment 11 daniel.rentz 2004-11-05 09:37:16 UTC 
reopened
Comment 12 daniel.rentz 2004-11-05 09:38:05 UTC 
back to QA
Comment 13 daniel.rentz 2004-11-05 09:38:17 UTC 
fixed
Comment 14 oc 2004-11-08 14:05:19 UTC 
verified in internal build cws_dr27
Comment 15 oc 2004-11-24 11:09:43 UTC 
closed because fix available on OOo1.9m62