Re: [libreoffice-users] Calc will not save file after sheet deleted [SOLUTION]

Simon, 

On Thu, 2011-08-11 at 11:50 +1000, Simon Cropper wrote: 

> 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



+1
Now if configure out what caused the file to corrupt, but we may never
know.

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