Hi :) Ok, this is a long shot and going off on a tangent. I think most of us are guessing that you have already run through all this many times in your mind. If you turned on the back-ups feature then back-ups are stored in a sub-folder in the user-profile http://wiki.documentfoundation.org/Documentation/UserProfile Also did the file get copied onto a network? Is it stored on a local machine? Did it get saved on a local machine and then copied to a network folder? Did it get emailed? or saved to usb-stick/cd/dvd to work on at home or show in a meeting? Did it get saved in a different format such as .xls or .csv recently?
Regards from Tom :) --- On Wed, 4/1/12, Theo <[email protected]> wrote: From: Theo <[email protected]> Subject: Re: [libreoffice-users] Error in calc file To: [email protected] Date: Wednesday, 4 January, 2012, 20:56 The line in Firefox is just about at the top of the file. The only line before it is: <?xml version="1.0" encoding="UTF-8"?> Thanks, Theo On 05/01/12 09:31, Jay Lozier wrote: > On 01/04/2012 03:00 PM, Theo wrote: >> Many thanks for the help. This file contains aspects of our business records >> for the past 6 years. We had a regular 2 hourly backup scheduled which >> unhappily has meant our backup data was overwritten with the corrupted file >> before we knew we had a problem. So we really appreciate the help. Our last >> uncorrupted backup is from last May! > Ouch!!! >> >> Opening the file content.xml in Firefox shows a heading thus: >> >> XML Parsing Error: duplicate attribute >> Location: file:///home/theo/junk/repair/baddailyturnover/content.xml >> Line Number 2, Column 734593: >> >> The line that follows, in red, is more than 15 pages long when copied and >> pasted to a text document, which itself is 974 pages long. >> >> When previewed in Firefox, the file is converted to html, and in Firefox it >> can be seen that the affected line seems to be all the entries at the start >> of the file relating to "style", but I wouldn't know where to look for the >> error. I tried deleting that line but that didn't work!! > It could be the html code in the line or IMHO a line just prior. My guess is > that a tag is not properly closed or the wrong tag format is being used. XML > is fussier than html about using the correct tag formats and the like. For > example <br> is acceptable html but not acceptable XML, the correct XML is > <br />. If the line before the red text has the bad code, deleting the red > text will not help. > > If you can post a snippet on Nabble someone might sort out the problem. >> >> Theo >> >> On 05/01/12 02:41, Tom Davies wrote: >>> Hi :) >>> You can usually open xml documents in text-editors such as Notepad, Gedit, >>> Kate or whatever. Notepad doesn't colour-code it but most other ones do >>> after you have changed the view from plain text to something such as html, >>> css or xml or something like that. SciTe is quite good in Windows. >>> Regina's idea of using a web-browser means you can't edit the document (i >>> think) but it's a quick and neat way of getting colour coding without >>> fussing around. Regards from >>> Tom :) >>> >>> >>> --- On Wed, 4/1/12, Regina Henschel<[email protected]> wrote: >>> >>> From: Regina Henschel<[email protected]> >>> Subject: Re: [libreoffice-users] Error in calc file >>> To:[email protected] >>> Date: Wednesday, 4 January, 2012, 12:34 >>> >>> Hi Theo, >>> >>> Theo schrieb: >>>> 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. >>> You can open the content.xml file in a browser for example Firefox. It >>> shows you the place of the error. After you have repaired one place, >>> open the file again in the browser to show the next error. If the >>> browser shows a tree view, the file is successfully repaired. >>> >>>> I guess this means I can edit the text, but what do I edit? >>>> >>> As far as I remember there had been two kind of errors. >>> (1) There are duplicate attributes. You will see exactly same text >>> before and after the error mark. Delete one of them. >>> (2) Instead of one _5f or one _20 you see something like _5f_5f_5f. >>> Reduce them to one. >>> >>> These errors had been produced be some developer or beta versions long >>> ago. Your error might be different, but you should look whether it is >>> one I had described. >>> >>> Kind regards >>> Regina >>> >>> >> > > -- For unsubscribe instructions e-mail to: [email protected] 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 -- For unsubscribe instructions e-mail to: [email protected] 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
