Re: [libreoffice-users] Error in calc file

On 04/01/12 15:58, Jay Lozier wrote:
> Theo,
>
> On 01/03/2012 08:58 PM, Theo wrote:
> > I have an error in a spreadsheet on opening.
> >
> > Any help would be very much appreciated.
> >
> > Read-Error
> > Format error discovered in the file in sub-document content.xml
> > at 2,734592(row,col).
> >
> > Thanks,
> >
> > Theo
> Can you open or create a new spreadsheet in Calc? You might have a 
> corrupted file. However the ods file can be unzipped and you can open 
> the xml file inside to text editor.
Thanks for the answer Jay.

I have tried some suggestions found by Googling.

1. I copied the file to a new folder and renames it from .sxc to .zip.
2. I extracted the files within.
3. The content.xml file is big - over 4mb. I tried opening it with gedit 
and notepad without success.
4. Opened the file in Windows with notepad and got a mass of text - 4049 
lines and 1070 columns.

I guess this means I can edit the text, but what do I edit?

Thanks, Theo

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted