Re: [libreoffice-users] Calc worksheet stalls when opening

On Tue, Mar 11, 2014 at 9:21 PM, William Drago <wdrago@suffolk.lib.ny.us>wrote:

> I have a spreadsheet that stalls when I try to open it and when I try to
> save it. It does eventually open after a very long time. I

Just looking for confirmation the issue is with only one particular
spreadsheet?

Calc on Ubuntu does this to me fairly often with any spreadsheet. I filed a
bug report but I don't think there's active interest in it. When the report
was filed I got a suggestion to upgrade, did so and the problem stopped.
Now, a few Ubuntu patches later, and the stall when open behavior is back.

My work around has been Apache OpenOffice. When I get tired of the stalling
(and it's only Calc not Write or other programs) I start using AOO Calc.
Usually after a few LO patches are part of the Ubuntu updates the stalling
stops.

So... if is a problem with any spreadsheet, check if there is a newer LO
and install that to see if the issue is resolved.

If the issue isn't resolved by upgrading LO consider installing AOO and try
opening the spreadsheet with AOO Calc. If the problem persists when the
spreadsheet is opened with AOO Calc it is definitely the spreadsheet.

Regardless of trying AOO, if it is only one particular spreadsheet, a bit
more information would be helpful trying to diagnose the problem.

- did this spreadsheet always act this way?
 - if no,
  -- what changes were made to the computer between the time the
spreadsheet last opened normally and first opened slowly? i.e., add/remove,
upgrade, or patch software
  -- what changes were made to the spreadsheet between the time it last
opened normally and it first opened slowly? ie, add borders to cells,
create new formulas, add more data

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted