Issue 52528 - Import of XLS-Files with numerous linked files incomplete
Summary: Import of XLS-Files with numerous linked files incomplete
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
Original Excel-File which is not imported complete (79.50 KB, application/vnd.ms-excel)
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
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 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
file.
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.