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

Thanks.

It was interesting. I am upset though I was unable to pin down the exact 
cause of the corruption.

+/- the comment was obviously a symptom of a underlying structural 
problem solved through ATTEMPT 2 below.

The file was originally created in June 2008 to replace my accounting 
package due to my frustration at the package not being able to do simple 
transactions and not being able to get at the underlying data or lookup 
tables (e.g. tax schedules).

The ODS spreadsheet has been accessed at over 152 times from both 
Windows XP/Ubuntu/XP+VirtualBox, had data imported from external 
Internet sites 45 times as CSV files, purged then repopulated 3 times 
and converted from XLS to ODS once.

I think all things considered the file has been relatively stable. What 
some people seem to forget who 'bag' the format, is that I have been 
able to access my data the entire time *even when this issue occurred*. 
In the absence of a RAD for a database system on Linux I will be 
sticking to using LibreOffice Calc to complete my accounting needs.


On 11/08/11 14:44, jorge wrote:
> 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


--
Cheers Simon

   Simon Cropper
   Principal Consultant
   Botanicus Australia Pty Ltd
   PO Box 160, Sunshine, VIC
   W: www.botanicusaustralia.com.au

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