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   -

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

1 answer

Raymond PENTIER Posted messages 58208 Registration date   Status Contributor Last intervention   17 478
 

Hello.

It's very simple: You ask the person who sent you the file what the password is to unlock it …


The retirement is good! Especially in the Antilles...
Raymond (INSA, AFPA)

2