Ask Your Question
0

LibreOffice Calc 5.0.42 Save error (xls); The document contains more rows that supported in the selected format Additional rows were not saved. I saved each file as .ods and .xls file extension. Any help would be appreciated..

asked 2016-01-09 01:37:47 +0200

Fry1 gravatar image

updated 2016-03-07 14:02:16 +0200

Alex Kemp gravatar image

I also have hyperlinks to photos. I get this save error constantly when I save. Any solutions, would be greatly appreciated.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2016-03-01 13:03:30 +0200

updated 2016-03-04 14:14:32 +0200

As the error message already informs there seems to be a different limitation on the number of rows per filetype.

I've stumbled upon this very message, when converting an .ods file to an .xls and searching for it got me to your question.

The odt file showed a total row count of 2^20 while the xls file showed a total row count of 2^16.

TL;DR

filetype    row count
---------   ----------
ods         2^20
xls         2^16
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2016-01-09 01:37:47 +0200

Seen: 392 times

Last updated: Mar 04 '16