Libreoffice and linux


#1

I am a Linux[Ubuntu(16.04.02 LTS)] user and use libreoffice[version 5.4] .
While opening the .csv it shows an error indicating that data could not be loaded completely because the maximum no rows per sheet was exceeded.
Please tell me how to solve it.


#2

Hey from Libre Office Documentation,

The maximum number of columns is 1,024 (from column A to column AMJ);
the maximum number of rows is 1,048,576 (220);

While the same is true for MS Excel. If your data points are more than this then you’d have to use another tool like python/R. If it is less than this then there might be some issue in your csv.