You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/01/08 05:55:14 UTC
[Bug 121595] New: scalc hangs when using lots of file links and all
files exist
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: issues@openoffice.apache.org
Reporter: rick.malm@gmail.com
CC: issues@openoffice.apache.org
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.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rick Malm <ri...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #80117|0 |1
is obsolete| |
Attachment #80118|0 |1
is obsolete| |
Attachment #80119|0 |1
is obsolete| |
Attachment #80120|0 |1
is obsolete| |
Attachment #80121|0 |1
is obsolete| |
Attachment #80122|0 |1
is obsolete| |
Attachment #80123|0 |1
is obsolete| |
Attachment #80124|0 |1
is obsolete| |
Attachment #80125|0 |1
is obsolete| |
Attachment #80126|0 |1
is obsolete| |
Attachment #80127|0 |1
is obsolete| |
Attachment #80128|0 |1
is obsolete| |
Attachment #80129|0 |1
is obsolete| |
--- Comment #22 from Rick Malm <ri...@gmail.com> ---
Created attachment 80139
--> https://issues.apache.org/ooo/attachment.cgi?id=80139&action=edit
zip file of 30% linked spreadsheets
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #23 from Rick Malm <ri...@gmail.com> ---
Created attachment 80140
--> https://issues.apache.org/ooo/attachment.cgi?id=80140&action=edit
zip file 2 of 30% linked spreadsheets
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #3 from Rick Malm <ri...@gmail.com> ---
I noticed in the spreadsheet (only row 70 to 149) it loaded but there were 3
bad rows and even a message at the bottom saying invalid ref or link.
So I did find 3 links that did not have an existing files.
I created the 3 files and the bad rows have now have good reference values.
BUT loading 280 rows still fails. Reminder: loading with
the 1 to 140 rows of links or with rows from 140 to 280 both work
and both show reference numbers in all cells.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #10 from Rick Malm <ri...@gmail.com> ---
Created attachment 80122
--> https://issues.apache.org/ooo/attachment.cgi?id=80122&action=edit
tv more linked
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rick Malm <ri...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #80116|0 |1
is obsolete| |
--- Comment #21 from Rick Malm <ri...@gmail.com> ---
Created attachment 80138
--> https://issues.apache.org/ooo/attachment.cgi?id=80138&action=edit
file that contains sheet PHraw with 280 rows of many links. hangs
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rick Malm <ri...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rick.malm@gmail.com
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #6 from Rick Malm <ri...@gmail.com> ---
Created attachment 80118
--> https://issues.apache.org/ooo/attachment.cgi?id=80118&action=edit
more link files
C:\Users\Dell Inspiron 580\Videos
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rob Weir <ro...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
QA Contact| |jigishails2000@gmail.com
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rick Malm <ri...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|major |critical
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #14 from Rick Malm <ri...@gmail.com> ---
Created attachment 80126
--> https://issues.apache.org/ooo/attachment.cgi?id=80126&action=edit
rk more linked
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #27 from Rick Malm <ri...@gmail.com> ---
Created attachment 80291
--> https://issues.apache.org/ooo/attachment.cgi?id=80291&action=edit
memory free to allow scalc to finish links
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rick Malm <ri...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P2 |P1
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #9 from Rick Malm <ri...@gmail.com> ---
Created attachment 80121
--> https://issues.apache.org/ooo/attachment.cgi?id=80121&action=edit
ej more linked
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #7 from Rick Malm <ri...@gmail.com> ---
Created attachment 80119
--> https://issues.apache.org/ooo/attachment.cgi?id=80119&action=edit
more link files
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rick Malm <ri...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |crash
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #18 from Rick Malm <ri...@gmail.com> ---
Created attachment 80130
--> https://issues.apache.org/ooo/attachment.cgi?id=80130&action=edit
delete half of the rows. 1 to 140 ok
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #4 from Rick Malm <ri...@gmail.com> ---
Created attachment 80116
--> https://issues.apache.org/ooo/attachment.cgi?id=80116&action=edit
file that contains sheet PHraw with 280 rows of many links. hangs
This file is the ods file that is failing (hangs)
to run it requires the linked files to be in
folders in a specific path. The sheet with the links is PHraw. columns V to CB
C:\Users\Dell Inspiron 580\Videos
Will attach zip file for these files. 8M
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #12 from Rick Malm <ri...@gmail.com> ---
Created attachment 80124
--> https://issues.apache.org/ooo/attachment.cgi?id=80124&action=edit
sc more linked
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #16 from Rick Malm <ri...@gmail.com> ---
Created attachment 80128
--> https://issues.apache.org/ooo/attachment.cgi?id=80128&action=edit
jm more linked
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |elish@apache.org
Resolution|--- |IRREPRODUCIBLE
--- Comment #29 from Edwin Sharp <el...@apache.org> ---
Can not reproduce.
AOO410m1(Build:9750) - Rev. 1552994
Rev.1552994
Win 7
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #24 from Rick Malm <ri...@gmail.com> ---
Created attachment 80141
--> https://issues.apache.org/ooo/attachment.cgi?id=80141&action=edit
zip file 3 of 30% linked spreadsheets
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #5 from Rick Malm <ri...@gmail.com> ---
Created attachment 80117
--> https://issues.apache.org/ooo/attachment.cgi?id=80117&action=edit
zip file of some of the spreadsheets that will be linked
These files must go in the path
C:\Users\Dell Inspiron 580\Videos\
The 8M limit for attachments means I will provide zips at the level below
videos
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rick Malm <ri...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P3 |P2
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #28 from Rick Malm <ri...@gmail.com> ---
Created attachment 80295
--> https://issues.apache.org/ooo/attachment.cgi?id=80295&action=edit
task manager and runtime error window at time of fail.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #1 from Rick Malm <ri...@gmail.com> ---
Tried cutting number of links by 50% (deleted rows)
and also went to 3.4.1. Size of memory usage
when process all the links (140 rows) soffice.bin ->500,000k. seems to work
fine.
1 min to update links. Exit and office bin only drops to 438,000k
So I kill soffice.bin and retry with 280 row version.
Runs for 5min, mem usages gets up to 1,100,000k and then slowly decreases to
200,000 and then get a Microsoft Visual C++ runtime library error window
appears and says to terminate has been fielded and hangs. Had to kill process.
This is a non confidential set of data (link files are 8Mbytes total)
but must be installed in a specific path for the links.
c:\Users\Dell Inspiron 580\Videos
So the only solution (workaround) is two split this into 2 files resulting in
50% of the links in each. Bummer.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rick Malm <ri...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Component|ui |editing
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rick Malm <ri...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P1 |P2
Severity|critical |major
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #26 from Rick Malm <ri...@gmail.com> ---
(In reply to comment #25)
> (In reply to comment #0)
> UPDATE Jan 21 2013: I copied the data to a 2nd computer, windows 7, that
> has 2x the memory on a suggestion from a person on the scalc forum. 3.3
> failed (crashed) and asked for a error report and I submitted it. The I
> updated that computer to 3.4.1 loops. Its been running over 1 hr.
> soffice.bin is holding at 1.5G, total memory used via task manager is 3G.
> After 2hr in a loop, these number dropped by 15%.
Still no solution but have another observation Feb 16.
I added 280 more file links. The update of 50% at a time fails now.
Even only do 30% at a time fails now and then. (intermittent)
My process is to select 30% of the links for update, wait 5 min, save and exit.
Then re open the saved file, update the next 30% of the links, save and exit.
The last time it fails was on the last 30%, the links updated but when I saved
it hung. I killed the process, recovery showed a version that was only 60%
linked so before I did the last 30% I use a program called SpeedUpMyPC and
did a free deep memory. See attached image (deep ram recovery) of how much
memory it released. From 70% used (after killed scalc and open office bin)
down to 30% after SpeedUpMyPC finished.
After this clean up I did the last 30% updated, and I was able to save....
Clearly you guys have a bug here.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #13 from Rick Malm <ri...@gmail.com> ---
Created attachment 80125
--> https://issues.apache.org/ooo/attachment.cgi?id=80125&action=edit
rr more linked
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #19 from Rick Malm <ri...@gmail.com> ---
Created attachment 80131
--> https://issues.apache.org/ooo/attachment.cgi?id=80131&action=edit
delete half of the rows 140 to 280. ok
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #2 from Rick Malm <ri...@gmail.com> ---
Tried deleting the 1st 140 rows of links.
Remember deleting the last 140 rows worked.
(binary search for a bad link with rows 140 to 210).
This time memory usage grows to 1,340,000 and hangs. So something going on with
the last 140 rows.
I do Recover and delete contents of 70 more rows leaving 70 out of 280. (210 to
280) This works fine.
So try leaving rows 140 to 210. Works fine.
So its not a bad link
but the number of links or some combination since deleting the last 140 rows
works
but the deleting the 1st 140 did not.
???
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #8 from Rick Malm <ri...@gmail.com> ---
Created attachment 80120
--> https://issues.apache.org/ooo/attachment.cgi?id=80120&action=edit
more link files
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #20 from Rick Malm <ri...@gmail.com> ---
(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.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #25 from Rick Malm <ri...@gmail.com> ---
(In reply to comment #0)
UPDATE Jan 21 2013: I copied the data to a 2nd computer, windows 7, that has
2x the memory on a suggestion from a person on the scalc forum. 3.3 failed
(crashed) and asked for a error report and I submitted it. The I updated that
computer to 3.4.1 loops. Its been running over 1 hr.
soffice.bin is holding at 1.5G, total memory used via task manager is 3G.
After 2hr in a loop, these number dropped by 15%.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #17 from Rick Malm <ri...@gmail.com> ---
Created attachment 80129
--> https://issues.apache.org/ooo/attachment.cgi?id=80129&action=edit
ec last of more linked
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #15 from Rick Malm <ri...@gmail.com> ---
Created attachment 80127
--> https://issues.apache.org/ooo/attachment.cgi?id=80127&action=edit
mm more linked
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
Rick Malm <ri...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Latest|--- |AOO 3.4.1
Confirmation on| |
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121595] scalc hangs when using lots of file links and all files
exist
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121595
--- Comment #11 from Rick Malm <ri...@gmail.com> ---
Created attachment 80123
--> https://issues.apache.org/ooo/attachment.cgi?id=80123&action=edit
tk more linked
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.