Re: [libreoffice-users] Error in calc file

Hi Theo,

Theo schrieb:
> [..]
>
> 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:

That sounds like the case (1) I have described.

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

Can you see the error mark in Firefox? Firefox draws a dashed line and 
at the end of that line is a little triangle pointing to the error. But 
your document is really huge and Firefox might be unable to cope it. 
Perhaps you can estimate where 734593 characters end?

When you reach the place of the error, you should see some text twice. 
It will be a little bit before and after the error place. Remember that 
text and search for it in the editor. That are the "duplicate attribute" 
Firefox named as parsing error. In the editor delete one of them. Save 
the file and reopen it in Firefox and let Firefox show you the next 
error. It is very likely, that the error at place character 734593 is 
not the only error and you will have to loop several times.

[I hope, all repair tries are made on a copy!]


Another idea you can try: Take a document of the same kind, which has no 
data and unzip it the same way. Then copy that part of the broken 
content.xml, which contains the data, and replace the corresponding part 
of the new file with it. That will loose all formatting, but might 
recover the pure data.

Kind regards
Regina

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