Issue 52528 - Import of XLS-Files with numerous linked files incomplete
Summary: Import of XLS-Files with numerous linked files incomplete
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 680m119
Hardware: All Windows, all
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-07-27 08:40 UTC by merschmann
Modified: 2013-02-07 21:48 UTC (History)
3 users (show)

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

Original Excel-File which is not imported complete (79.50 KB, application/
2005-07-27 08:42 UTC, merschmann
no flags Details
Rebuilded functionality in native-Ooo (762.75 KB, application/vnd.sun.xml.calc)
2005-07-27 08:44 UTC, merschmann
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description merschmann 2005-07-27 08:40:47 UTC
If you have an XLS-File with numerous links to other xls-files, the formulas are
not all imported correct to Ooo.
From a certain cell the formulas contain #REF instead of the name of the linked
The functionality can be rebuilt in a native-Ooo spreadsheet and is working well.
I have tried some time about this and think it is not depending on the number of
links, but on the length of the pathes to import at all.

To reproduce: Import the attached XLS_result.xls and answer the
updating-question wiht "No". The result is obviously.

For comparison I will also attach the Ooo_result.ods, which is the native-Ooo.
Comment 1 merschmann 2005-07-27 08:42:25 UTC
Created attachment 28252 [details]
Original Excel-File which is not imported complete
Comment 2 merschmann 2005-07-27 08:44:22 UTC
Created attachment 28253 [details]
Rebuilded functionality in native-Ooo
Comment 3 daniel.rentz 2005-07-27 12:30:19 UTC
The number of sheets reaches the limit of 256. All links to sheets in external
documents are implemented in Calc as hidden linked sheet.

*** This issue has been marked as a duplicate of 19440 ***
Comment 4 daniel.rentz 2005-07-27 12:30:34 UTC
double -> closed
Comment 5 merschmann 2010-07-14 14:11:03 UTC
After a long time I checked again:
My Excel-File crashes DEV300m84 when the memory consumption reaches 2GB (WinXP)
although according to issue 19440 the reason must have been gone.
Comment 6 Shan Zhu 2012-09-07 09:58:45 UTC
Can be reproduced on AOO350m1build9610.