https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #20 from Rick Malm <[email protected]> --- (In reply to comment #0) > 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) Jan 10 2013: I just tried loading this spreadsheet with xlx. Version from 2002. No problem. It did stall on several files with the same name but in different paths. MissingVideo.xlsx. But was able to finish without a crash after I skipped the file names that were the same. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
