Calc crashes working on large file

asked 2015-06-26 20:13:00 +0200

Polite Master gravatar image

updated 2015-08-24 18:13:04 +0200

Alex Kemp gravatar image

Hello LibreOffice community,

I am having trouble working on my spreadsheet in LibreOffice Calc. Once opened, most operations in Calc have a pronounced lag (scrolling, selecting all data with Ctrl+A, applying a Standard Filter), don't make apparent changes (ascending/descending sorting of a column using expand selection), or crash the application (deleting multiple selected rows).

My file and system specs:

The workbook is a 4,294 KB .csv (I also tried working with a .ods copy) that contains one spreadsheet tab with text in less than 60,000 rows and exactly 4 columns. Every even row is blank. (I was trying to filter and delete these blank rows before Calc churned for 10 minutes and crashed.) Two of the columns contain strings between 4 and 12 characters, while one of the columns has strings that are admittedly long (many around 256 characters). However, this is not a particularly large nor demanding spreadsheet; I would expect any spreadsheet application in the last 18-20 years to handle it. Is this a normal threshold limit for Calc?

I am currently trying LibreOffice v4.4.3.2 (latest stable) and LibreOfficePortable v4.4.3.2 (latest stable) on Windows 7 SP-1 with latest Windows updates. The system uses an Intel i7-3770K CPU and 16 GB of DDR3 1600 MHz RAM.

I received the following error upon crash: LibreOffice 4.4 Fatal Error - bad allocation. While posting my message, I left the error dialogue open (the application crashed but did not yet close). About 5 minutes after the initial crash, I received another message: Visual C++ Runtime Error.

Any thoughts or comments are greatly appreciated. Thank you kindly in advance!

edit retag flag offensive close merge delete