Bug 55858

Summary:	Large table FILESAVE error
Product:	LibreOffice	Reporter:	Lee Oliver <oliverla.4>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal
Priority:	medium
Version:	3.6.2.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Lee Oliver 2012-10-11 02:19:09 UTC

Calc is able to read csv file with over 500,000 lines and 30 Columns.  Pivot table will operate as expected on the data.  

After performing FILESAVE to ods file, I do not believe all the data is written.
Calc cannot open the saved file at all.  Flashes on screen then immediately closes.

Comment 1 billhook 2012-10-11 23:36:24 UTC

Are you able to upload a sample? Perhaps zip it if it is large.

Comment 2 Lee Oliver 2012-10-21 15:24:00 UTC

The file contains proprietary data.  Can you generate a large table (550000
rows X 40 columns) of random numbers?  Just use column names of  A, B C,
......?
generate some stats with pivot table then try to save and recall the large
table.

thanks
Lee

On Thu, Oct 11, 2012 at 7:36 PM, <bugzilla-daemon@freedesktop.org> wrote:

>   *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=55858#c1> on bug
> 55858 <https://bugs.freedesktop.org/show_bug.cgi?id=55858> from
> billhook@y7mail.com *
>
> Are you able to upload a sample? Perhaps zip it if it is large.
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>

Comment 3 Lee Oliver 2012-11-09 01:41:37 UTC

I was able to read a csv text file with 247000 rows and 59 columns, do some stats and save and open the file as .ods.  So the problem must be between about 250000 and 500000 rows.

Comment 4 Jorendc 2013-01-27 18:58:36 UTC

Can't reproduce using LO 4.0.0.2 rc2 with Linux Mint 14 x64.

Is it possible for you to retest with LO4.0 (release candidate or final release in February)?
I'll upload a package of files with different amount of rows in it (see file names).

I set bug status to NEEDINFO.

Comment 5 Jorendc 2013-01-27 19:19:12 UTC

Because the files are a bit to big for FDO I uploaded it to dropbox. You can download the zip with testfiles I used to try to reproduce: https://www.dropbox.com/s/axn6040lvmnzy4s/testcases.zip

Comment 6 Lee Oliver 2013-02-01 02:36:36 UTC

I am also using Mint 14 64 Bit.

I installed version 4 of Libreoffice and tried again with the original big
file; 558151 rows and columns out to BL.
Everything seems to work fine now, no problems with FileSave.  The saved
ods file is 150 MB.

I think you can mark the bug resolved.

thanks
Lee

On Sun, Jan 27, 2013 at 2:19 PM, <bugzilla-daemon@freedesktop.org> wrote:

>   *Comment # 5 <https://bugs.freedesktop.org/show_bug.cgi?id=55858#c5> on bug
> 55858 <https://bugs.freedesktop.org/show_bug.cgi?id=55858> from Jorendc<joren.libreoffice@telenet.be>
> *
>
> Because the files are a bit to big for FDO I uploaded it to dropbox. You can
> download the zip with testfiles I used to try to reproduce:https://www.dropbox.com/s/axn6040lvmnzy4s/testcases.zip
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>

Comment 7 Jorendc 2013-02-01 12:18:48 UTC

(In reply to comment #6)
> I am also using Mint 14 64 Bit.
> 
> I installed version 4 of Libreoffice and tried again with the original big
> file; 558151 rows and columns out to BL.
> Everything seems to work fine now, no problems with FileSave.  The saved
> ods file is 150 MB.
Thanks for your feedback! I'm glad this is resolved.
> 
> I think you can mark the bug resolved.
Therefore I mark it as RESOLVED WORKSFORME. If this problem return, please feel free to REOPEN this bug.

Thanks for your time testing and sending us feedback,
Joren