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

On 10/08/11 10:26, Steve Edmonds wrote:
> Hi.
>
> On 2011-08-10 12:18, Simon Cropper wrote:
> > Question -- Check if the file is opened as "read only"
> >
> >     No it is not and permissions are all OK.
> >
> > Question -- If it is like that you have to save the file with new name
> > for changing it.
> >
> >     The problem occurs on original, copies of original and when
> >     I try and save as different name.
> >
> >
> > On 10/08/11 10:03, jorge wrote:
> > > Hi
> > >
> > >      Check if the file is opened as "read only"
> > >
> > >      If it is like that you have to save the file with new name for
> > > changing
> > > it.
> > >
> > > Regards,
> > >
> > > Jorge Rodríguez
> > >
> > > __________
> > >
> > > El mié, 10-08-2011 a las 09:46 +1000, Simon Cropper escribió:
> > > > Hi,
> > > >
> > > > I have an old spreadsheet in ODS format. The file was originally an XLS
> > > > file then converted to ODS format several years ago *and* has been used
> > > > weekly over that period without any problems.
> > > >
> > > > When I try an delete a sheet from the file I get an error "Error saving
> > > > the document FILE: Write Error. The file could not be written."
> > > >
> > > > If, prior to attempting the sheet removal, I change the contents of a
> > > > cell the file is saved without any problems.
> > > >
> > > > When the error occurs the saving progress bar appears, moves to ~20%
> > > > completion stops for several seconds, then progresses to ~80%
> > > > completion
> > > > at normal saving speed, stops again for several seconds then crashes.
> > > > This is in contrast to a normal save where the progress bar moves at a
> > > > constant rate for the entire saving process.
> > > >
> > > > If I attempt to insert a sheet I get the same problem.
> > > >
> > > > *I should point out* here that the sheet being deleted and inserted are
> > > > mid-file, that is I have 18 tabs and I am trying to delete sheet 7.
> > > > When
> > > > I insert a sheet I am inserting after sheet 7 or 8 (does not really
> > > > matter).
> > > >
> > > > What I have noticed is if I use the 'add sheet' tab -- that is the last
> > > > tab with the green '+' sign instead of the name to add a sheet; a sheet
> > > > can be added and the document saved. This same sheet can be deleted,
> > > > although the progress bar behaves as if the error is going to happen,
> > > > that is it pauses at 20% and 80% completion; except this time it
> > > > finishes without the error dialog appearing.
> > > >
> > > > My tests indicate that the last sheet of the original untouched file
> > > > can
> > > > be deleted. Like above the progress bar behaves an unusual way but does
> > > > complete without the error dialog appearing.
> > > >
> > > > I can not reproduce the error on a new clean file.
> > > >
> > > > If I work back through the historical copies of the file, I can only
> > > > reproduce the error in this years version. It is as if the file has
> > > > become partially corrupted. The question is how and can it be easily
> > > > fixed.
> > > >
> > > > Before I spend the time recreating the file from scratch or modifying
> > > > one of the old backups...
> > > >
> > > > *Has anyone encountered or heard of a similar problem?*
> > > >
> > > > *Anyone got some ideas?*
> > > >
> > > > *Is it worth upgrading LibreOffice?*
> > > >
> > > > I am running LibreOffice 3.4.1 OOO340m1 (Build:103) on Ubuntu 10.04
> > > > LTS.
> > > > The java version used is Sun Microsystems Inc. 1.6.0_26, although I
> > > > have
> > > > also checked and verified the problem occurs on 1.6.0_20 (which just
> > > > happened to be on the system).
> > > >
> > > > LibreOffice was manually installed from downloaded DEB files *not*
> > > > installed from the LibreOffice PPA repository or the Ubuntu Software
> > > > Centre.
> > > >
> > > > --
> > > > Cheers Simon
> > > >
> > > >       Simon Cropper
> > > >       Principal Consultant
> > > >       Botanicus Australia Pty Ltd
> > > >       PO Box 160, Sunshine, VIC
> > > >       W: www.botanicusaustralia.com.au
> And do you get the same problem if you save as a new name without
> deleting the sheet (so it saves OK) and exit running instances of LO and
> then re-open it.
> Are there references to/from the sheet you deleted from other sheets
> that could be broken and causing problems.
> steve

1. do you get the same problem if you save as a new name without 
deleting the sheet... No. The file saves OK and behaves as per normal 
unless I delete or insert sheet mid-file.

2. Problem persists even if I reboot.

3. Are there references to/from the sheet... Yes, the file is riddled 
with cross-references. That said I have tried deleting sheets that are 
orphaned and the problem still occurs. If I insert a new sheet mid-file, 
the problem still occurs. I can chomp off the last sheet, which is 
cross-referenced in several locations elsewhere in the file and the 
problem *does not occur*.

--
Cheers Simon


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