Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | calc 'save as' excel .xls does not change sheet references correctly | ||
---|---|---|---|
Product: | Calc | Reporter: | lohner <internationils> |
Component: | save-export | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | elish, issues |
Version: | OOo 3.0 | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | 4.1.0-dev |
Developer Difficulty: | --- |
Description
lohner
2008-11-05 10:40:58 UTC
From Help: "If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT("filename!sheetname"&B1) is not converted into the Calc address in INDIRECT("filename.sheetname"&B1)." Automatic translation is appropriate. |