Issue 116473 - XLS export compatibility bug
Summary: XLS export compatibility bug
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.2.1
Hardware: All Windows 7
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: DanielAlvaro
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2011-01-15 17:49 UTC by pygmalion
Modified: 2017-05-20 09:57 UTC (History)
2 users (show)

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

Attachments
A sample file with the descriped error (20.50 KB, application/vnd.ms-excel)
2011-01-16 19:18 UTC, pygmalion 		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 pygmalion 2011-01-15 17:49:25 UTC 
XLS compatibility for Conditional Formatting is not working.  It seems that XLS
does not support references to other sheets.  More importantly condition <Cell
Value is> <equal to> <$FD1.I$13> is translated by Excel to <'FD1'!A$13> (NOTE
CHANGE "I" to "A").
Comment 1 Marcus 2011-01-16 16:05:16 UTC 
please add a sample doc to reproduce the issue
Comment 2 pygmalion 2011-01-16 19:18:08 UTC 
Created attachment 75574 [details]
A sample file with the descriped error
Comment 3 Richard Price 2011-12-02 15:56:20 UTC 
I too have experienced this bug.  I will be happy to send any requested documentation.
Comment 4 DanielAlvaro 2013-02-12 01:08:43 UTC 
Hello, I need more information.
what is the problem with "calc Apache OpenOffice"?
because the extension in calc is .ods
Regards
Comment 5 Richard Price 2013-02-12 01:23:29 UTC 
Calc can open .xls files. The example above should be sufficient. But I will try to find another.  After 2 years that may take a while.

I also wonder why the bug is still unconfirmed as 2 people have independently reported it.
Comment 6 Rob Weir 2013-02-12 16:26:13 UTC 
(In reply to comment #5)
> Calc can open .xls files. The example above should be sufficient. But I will
> try to find another.  After 2 years that may take a while.
> 
> I also wonder why the bug is still unconfirmed as 2 people have
> independently reported it.

Thanks for your patience, Richard. The goal here is to see if the issue is still an issue in the current OpenOffice version.  Because 2 years have passed, the older tests against older versions of OpenOffice are not sufficient.  We want to see if the issue is still a problem.
Comment 7 Richard Price 2013-02-12 16:52:46 UTC 
Well Rob. I cannot reproduce the error and I cannot find the original spread sheet which had the error. Reproducing the error requires saving a sheet as a .xls file and opening it in the other spread sheet application. I don't remember if it was from calc to excel or from excel to calc. I don't have access to excel any more so I can be of no further use to you in this area. Sorry, Rich
Comment 8 Edwin Sharp 2013-07-10 11:44:27 UTC 
Can not detect cells in attachment sheet "print" with conditional formatting.

Please advise.
Comment 9 Edwin Sharp 2013-08-23 11:47:25 UTC 
No info from author.