|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Excel spreadsheet import bug... easy fix. | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | jesperkrogh <jesper> | ||||
| Component: | code | Assignee: | daniel.rentz | ||||
| Status: | CLOSED WONT_FIX | QA Contact: | issues@sc <issues> | ||||
| Severity: | Trivial | ||||||
| Priority: | P3 | CC: | issues | ||||
| Version: | OOo 1.1 RC4 | ||||||
| Target Milestone: | --- | ||||||
| Hardware: | PC | ||||||
| OS: | Linux, all | ||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
| Developer Difficulty: | --- | ||||||
| Attachments: |
|
||||||
Created attachment 9568 [details]
Excel spreadsheet showing the bug.
Hi Daniel, one4you 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.
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. wontfix->closed |
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.