Ask Your Question

Cell contents beyond 65536 vanish when opening xls file from Calc. [closed]

asked 2014-09-02 11:01:34 +0200

enm1972 gravatar image

updated 2016-03-03 11:28:52 +0200

Alex Kemp gravatar image

Hello, I need some guidance on a problem that I have with my Calc tool. I am running LibreOffice v4.2.3.3 Engish ver. on a Windows 7 (English ver.) 64-bit Dell Latitude E5530 machine that has 8GB of RAM and a Intel i7@2.9GHz . I load a file with numerous data in a Calc spreadsheet that requires about 170,000 rows and 16 columns. Data loads with no problem, I can process them by adding four extra columns on the same spreadsheet, such as median, median of absolute deviation, etc, I save the sheet and close it. When I open it again, I can only see data entered up to row 65536, the rest of the rows are empty. This of course ruins my statistical processing (causes a #REF! message in every cell of the columns that I use in my statistical analysis), since it requires all the data to be present. I have seen that recent Calc versions can handle up to 1million rows, but I cannot understand why my data vanishes when I reload my file. Any hints?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 11:29:00.372777

1 Answer

Sort by » oldest newest most voted

answered 2014-09-02 11:24:58 +0200

karolus gravatar image

Store your File as native .ods and all will be fine.

( the .xls format stores only up to 65536 rows )

edit flag offensive delete link more



xlsx supports up to "Now with xlsx workbooks (and xlsm), the limits are 1,048,576 rows (220) and 16,384 columns (214) or the column XFD." as told by , so if one has to save as Excel, xlsx is way better option, but if not, then ods.

rautamiekka gravatar imagerautamiekka ( 2014-09-02 12:31:07 +0200 )edit

Thank you for the prompt response, I found about the .ods solution on my own after experimenting a little bit. It is a good thing that it also works with the .xlsx extension as you said, otherwise there would be serious problem communication results to MS Office users. I tried that too and it works as you suggested. Zillion thanks!

enm1972 gravatar imageenm1972 ( 2014-09-02 12:46:37 +0200 )edit

@enm1972: Mark the answer then, and if applicable upvote.

rautamiekka gravatar imagerautamiekka ( 2014-09-02 16:19:41 +0200 )edit

Question Tools

1 follower


Asked: 2014-09-02 11:01:34 +0200

Seen: 540 times

Last updated: Sep 02 '14