Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.