Issue 19897 - Excel spreadsheet import bug... easy fix.
Summary: Excel spreadsheet import bug... easy fix.
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC4
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: daniel.rentz
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-22 15:18 UTC by jesperkrogh
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
Excel spreadsheet showing the bug. (13.50 KB, text/plain)
2003-09-22 15:19 UTC, jesperkrogh 		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 jesperkrogh 2003-09-22 15:18:33 UTC 
When importing an Excel spreadsheet with cross sheet references, this:
=INDIRECT("Sheet2!A1")
is valid in Excel and produces an error (ERR: 502 )in oocalc the ! should be
replaced with an . then it is valid OOo format.
Comment 1 jesperkrogh 2003-09-22 15:19:26 UTC 
Created attachment 9568 [details]
Excel spreadsheet showing the bug.
Comment 2 oc 2003-09-22 15:32:04 UTC 
Hi Daniel, one4you
Comment 3 Unknown 2003-09-22 16:57:39 UTC 
It should be noted that the argument string for this function is
usually not just a static text. The INDIRECT function is used for
creating dynamic cell references on the fly, and the argument string
is consequently created by other spreadsheet functions. 

I don't know much about import filters but I could imagine that this
may add some difficulty in parsing the function and finding the
correct instance of '!' to replace. 

As an example, I discovered the bug when this part of a formula
created an error:
INDIRECT(""&H$219&"!"&H$221&":"&H$221)

...which "resolves" into INDIRECT("Detail!E:E").

I could imagine even worse cases where the '!' is found in the
contents of a cell, just like the sheet name and column number was in
the example above.
Comment 4 daniel.rentz 2003-09-23 11:02:59 UTC 
Hi allanolesen,
thanks for your comments. That is exactly the reason, why the 
import/export filters will *never* change the contents of a document, 
especially strings in formulas.
Comment 5 daniel.rentz 2003-10-27 16:06:05 UTC 
wontfix->closed