Congratulations,... it was an interesting investigation. Regards,
Jorge Rodríguez ______ El jue, 11-08-2011 a las 11:50 +1000, Simon Cropper escribió: > On 10/08/11 16:41, Simon Cropper wrote: > > *The upshot* > > > > Unless someone recognised these symptoms and can put forward some ideas, > > I am treating this as a corrupt file. I have drawn this conclusion > > because (a) I can only reproduce the error on the effected file, (b) the > > comment insert/delete trick is suggestive but not consistent (or at > > least from what I can tell) - random sheets cause the file save error if > > comments are inserted; inserting comments into new sheets also trigger > > the error. > > > > I just hope that recreating this file does not corrupt the new file as I > > will need to copy blocks of text, numbers and formulas. > > > > *My attempts at recreating a clean file* > > ATTEMPT 1 > > Created a new file with one less tab. All tabs were named the same as > the original. I then cut-and-paste all the data from the original to > this newly created file. This took about 10 minutes. > > The problem is that all tab / sheet references after the omitted sheet > moved across one. Despite the formula referencing the sheet name, the > name is actually just a human readable cue for the underlying sheet > number. So sheet Accounts (sheet #17 on the original file), which > pointed to 'accounts lookup list' now points to the Tax sheet, which was > #18 but is now #17 in the new file. > > ATTEMPT 2 > > Created a new file with exactly the same number of tabs. All tabs were > named the same as the original. I then cut-and-paste all the data from > the original to this newly created file. This took about 10 minutes. > > Then with baited breath I deleted the unrequired sheet that triggered > this journey in the first place and clicked save. *It worked* - that is, > it saved without triggering a write error. > > I have checked - (a) all data is intact, and (b) all the formulas are > working. :) > > -- > Cheers Simon > > Simon Cropper > Principal Consultant > Botanicus Australia Pty Ltd > PO Box 160, Sunshine, VIC > W: www.botanicusaustralia.com.au > -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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
