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 <[email protected]> To: [email protected] 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 -- For unsubscribe instructions e-mail to: [email protected] 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 -- For unsubscribe instructions e-mail to: [email protected] 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
