Problem with Open Office spreadsheet
Andromede73
Posted messages
35
Registration date
Status
Member
Last intervention
-
Raymond PENTIER Posted messages 58208 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58208 Registration date Status Contributor Last intervention -
Hello
I installed Open Office on my PC.
Recently I was sent a large data table typed in Excel (it has 95,000 rows and a dozen columns).
But this file contains quite a few errors and its presentation is not very easy to read. Since the file in Excel is locked I can't modify it.
I therefore started to copy the file to Open Office, but I can't save beyond the 65,536th row. I’m missing about 30,000 rows of data!
So I created a second file to copy the rest, but from the 4,800th row it blocks again
How can I copy the entire folder/files under Open Office? And if possible in a single file? Or how can I unlock the file to modify it?
Thanks in advance