https://issues.apache.org/ooo/show_bug.cgi?id=121595
Bug ID: 121595
Issue Type: DEFECT
Summary: scalc hangs when using lots of file links and all
files exist
Classification: Application
Product: spreadsheet
Version: AOO 3.4.1
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: ui
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
I have a 5 sheet spreadsheet, about 280 rows in 3 of the sheets, columns a to
cb wide, 630Kb if I look at the disk storage required.
One sheet has 15*3*280 links to other spreadsheets that have about 100 lines
each
in them with about 16 columns of data in each of the linked sheet.
The links only reference 3 rows in each of the 280 linked files.
When I try to refresh all these links scalc hangs at its memory usage
gets around 1000k. Clearly the amount of linked data is only 280*15 cells * 3
cells. About 13k cells time how every many bytes to read and store this data
Clearly seems like it should be less than what it takes.
Again thats 280 link file names.
If I look at the memory usage if I load the spreadsheet and DONT up the links
the size is 146,000k (soffice.bin) Then I answer the update all links
and the size grows to over 1000,000k and then recovers back down to 193,000k
This take about 5 min. Then it seems to hang. Have to ues task manager and kill
it. I can select a cell but can not type into it. I can select small subsets
of links to update cells and then save but it would be nice to be able to
update all since I dont always know which linked files have changes. Any
advice would be helpful. I am at 3.4.0 and should update.
All the Links are of the form:
=OFFSET('file:///C:/Users/Dell Inspiron
580/Videos/AndrewBrown/AB50R.xlsx'#$Sheet1.$C$1;AA2;0)
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
