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

Tom,

I have checked all these issues. Permissions, folder permissions, 
owner/grp attributes have all been checked.

As stated I can turn the save / no-save behaviour on and off with 
deletion or reinsertion of comments into the sheet. If the file was read 
only or write protected then this could not be done.

No harm asking though :)

On 11/08/11 03:23, Tom Davies wrote:
> Hi :)
> I was wondering if it's to do with permissions of the folder you are trying to
> save into.  In linux systems it's difficult to save in folders such as
>
> /root
> /boot
> and sometimes into other users or guests folders on a multi-user system.  I have
> a feeling that you have already tried saving into another folder or onto your
> own desktop but i am not certain.
>
> Regards from
> Tom :)
>
>
>
> ________________________________
> From: Simon Cropper<scropper@botanicusaustralia.com.au>
> To: users@global.libreoffice.org
> Sent: Wed, 10 August, 2011 1:46:06
> Subject: 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

   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