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

[Fry1]

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

[olspookishmagus]

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