Re: [libreoffice-users] Error in calc file

On 01/03/2012 10:40 PM, Theo wrote:
> 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?
You can try saving the text file as either txt or csv which you can 
import into Calc. You will lose any formulas in the original file
> Thanks, Theo


--
Jay Lozier
jslozier@gmail.com


--
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