Apache OpenOffice (AOO) Bugzilla – Issue 4385
Support external named ranges in Excel import
Last modified: 2013-08-07 15:13:10 UTC
If I try to refer to a spreadsheet file's named range from another file, the named range disappears from the reference and is replaced by the explicit range xx:yy. This is not right, because, for example, if I modify the content of the named range, everything goes bust. Beyond this, if I import a spreadsheet from Excel which includes lookups to another file, the reference to the other file disappears after the conversion. (My problem is the combinations of these two...)
*** Issue 8848 has been marked as a duplicate of this issue. ***
Hi Daniel, please have a look at this.
Are there test documents available? Please attach them.
target->OOoLater
@dr: Does Calc already support external defined names? My impression is that it does not, but I'd like to know for sure.
No, external names are not supported yet.
I'm currently looking into supporting external defined names in Calc.
I'm taking over this issue. This is not just an Excel import issue, but also an issue with the Calc core; we need to add support for external named ranges in the core before we can import them from Excel properly.
Changing the type to enhancement.
It seems Issue 3740 is a dup of this one.
Make this just an Excel import issue.
setting keyword
@kohei: I added this issue to cws mooxlsc, since that is where the related changes went in. Please check what else is needed.
You can also add Issue 3740 since that's the main issue for supporting external defined names.
BTW I'm happy to finally announce that this is now fixed in mooxlsc. :-)
reassigning to oc for qa.
umm.. usually we wait until the final cws build is ready and the fix is verified there by the developer before reassigning an issue to QA ... Added issue 3740 to the cws as well.
ah ok. Then I'll take it back for now.
*** Issue 78030 has been marked as a duplicate of this issue. ***
Reopening. @kohei: In MOOXML import an external global name is now correctly parsed under ScCompiler::IsExternalNamedRange(), including ExternalLinks index, but ScExternalRefManager::getRangeNameTokens() doesn't find it. Please fetch current cws mooxlsc from SVN. You may use http://sc.openoffice.org/testdocs/external/externallink_import_oox7.xlsx for tests, cell Sheet1.H32 should have a valid result.
For reference: the BIFF12 document http://sc.openoffice.org/testdocs/external/externallink_import_oox7.xlsb also has an error there. The BIFF8 document http://sc.openoffice.org/testdocs/external/externallink_import_biff8.xls crashes in ScTokenArray::Clone (this=0x0) ScExternalRefManager::storeRangeNameTokens() XclImpExtName::CreateExtNameData() with XclImpExtName.mxArray passed being a null reference.
This is confusing. For MOOXML and BIFF12 the import of external names is not implemented yet and thus can't work. We still have the BIFF8 crash though.
I just fixed the crash bug on loading BIFF8 documents in mooxlsc. The reason for crash was the document contained per-sheet external names which are not supported yet. We can punt that to future implementation.
Reopening and retargeting to OOo3.2 to align with issue 3740 that got reopened, where external name references depend on.
OOo 3.2 is in show-stopper stage. This issue is re-targeted to OOo 3.x. If this issue is critical for the current release please target it back.
Reset assignee on issues not touched by assignee in more than 1000 days.