Re: [libreoffice-users] Re: Windows 7 - Very slow loading time spreadsheet

That's one solution, I just did this : right-click on a sheet, choose
Select all sheet, and copy them to another spreadsheet which now opens very
fast.

I tried a few things in the file in problem which has only 1 empty sheet,
like selecting all cells and choosing Clear formatting, or deleting all
rows and columns, changing the font, changing the borders but it still
loads it in 2m10 seconds.



On Sat, Aug 25, 2012 at 4:38 AM, Andreas Säger <villeroy@t-online.de> wrote:

> Am 25.08.2012 09:13, Zurd wrote:
>
> > Hi, hoping someone can help me with this problem I'm facing.
> >
> > When opening a spreadsheet, it takes around 2m10 seconds for LibreOffice
> > to
> > open it.
> >
> > It's an old .ODS file created years ago with OpenOffice, not a big file,
> > only 56 KB, nothing complicated in it, just a few functions like SUM,
> > COUNTIF, etc. I never had any problem in both Linux/Windows. Now on a new
> > computer with Windows 7 64 bit, I installed LibreOffice : Version 3.6.0.4
> > (Build ID: 932b512) and it takes a long time to open it up. If I open a
> > new
> > spreadsheet it is fast, like 3 seconds, I can put some text in it, save
> > it,
> > open it, still fast, just my old spreadsheet that is very slow to open.
> >
> > I deleted every sheets in it, created a new one, went into
> > File->Properties, click the Reset button, close, save, re-open : still
> > very
> > slow. I disabled the real-time protection of MS Security Essentials :
> > still
> > very slow. For the 2m10 duration to open it, my CPU (Intel i5) is only at
> > 1-3% and soffice.bin consumes only 23 080k of memory (I have a total of 6
> > GB).
> >
> > I'm attaching the file which is now only at 12 KB since I deleted all
> > sheets.
> >
> > Thanks for any help
> What happens if you copy over all sheet contents into a new file? Don't
> mind any formatting. Just copy over all data cells and formula cells.

-- 
For unsubscribe instructions e-mail to: users+help@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