Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP; CAUSE IDENTIFIED]
On 12/08/11 14:38, planas wrote: On Fri, 2011-08-12 at 13:52 +1000, Simon Cropper wrote: Hi Everyone, I have been doing some follow-up investigations that I thought you might like to be made aware. First, why? Well after testing the file that I recreated by copying the text, formula and styles I could not cause the error to occur again. This is what I reported yesterday. I then proceeded with importing the few images and 'artwork' objects from the old file to the new. After several saves and sheet manipulations I noticed the file became unstable again. The outcome of my investigation was that one of the image files used on one of the sheets had become corrupted* and adding this file in caused the file to become unstable - eventually exhibiting the problem I mentioned about not being able to save after a sheet was deleted. These 'corrupted' files are relatively benign with the error only becoming apparent *once* you attempt to delete the sheet. So somehow the error caused problems with the broader 'workbook' structure not the sheet structure. Although I compared files between different versions of the file the XML were too varied (usually style names and definitions; content was identical). * note I say corrupted but it rendered OK and only resulted in the observed behaviour one a sheet is deleted. I 'deem' it corrupted as once replaced with a clean version render and saved as a new file by GIMP, the problem disappeared. The error was with the particular corrupt objects. On recreating new images and inserting them into a file I have not been able to trigger any problems. If I cut-and-paste from the original 'corrupt' file the file becomes unstable after a few saves and sheet manipulations. So the steps for salvage is... 1. recreate a new file with the exact number of sheets as the original. Ensure each sheet names are the same. 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the content being placed in the new file to text, numbers, date time, formulas and formats. 3. If you have images in the file. Recreate / Save using another package. As mentioned I used GIMP. 4. Insert new copies of the images into file. *Don't* cut-and-paste objects from the old file. 5. If you have any lines, text boxes and artwork; recreate them from new. During this process... - Save as a new version (+tabs, +data, +images, +other objects) following each step. - Test each version thoroughly before proceeding. - Only add one object at a time, so if something goes wrong you can isolate the problem component. - To check it is not a bug try and recreate with a fresh file. A couple of quick notes that may be valuable to others... - ODS files are archives. Use an archive facility to extract the data inside. Inspect the contents in the folders to see what is different. - On every 'Save as' the file size changes. This is not due to changes in the file contents, but rather in changes in how the components of the file is compressed/archived. If you open a file, add objects then save, the file size with be so big. Open that file and Save as a new name and the file will be a different size. If you extract the files the contents of all the files and directories are identical. It is just the internal archive facility in LO will decide the best compaction routine based on what it encounters. - The content.xml file can be quite large and has no internal end-of-line characters. This make it difficult to open and be parse by various text editors, xml viewers and comparison facilities. To insert a EOL character after the end of each tag (i.e.), I used the following command in the terminal (requires Linux). cat content.xml | sed -e 's//\n/g' content_with_linebreaks.xml cat just spews the content of the text file to the standard output. I then pipe it to sed, where I used regular expressions to find '' and replace every instance of it with '\n'. I then compared the contents with Diffuse. Snip +1 I wonder how the images got corrupted, interesting. Good question and something I was not happy just leaving alone. Once I satisfied myself that this was most likely not a bug but file corruption the questions that came to mind were... (1) How this file became corrupted? and (2) How extensive is the damage (physical damage, system wide, file specific)? As mentioned I currently use Linux so needed to find a method to check the file system for errors and see if any blocks or clusters were damaged. I am assuming here that I could of had a power spike or jolt to my machine that could of caused the platter on my hard disk becoming damaged. I did this by running 'fsck.ext4' from a LiveCD on all my hard disks. It took all Saturday to do this. Thankfully no errors were detected. Anyone interested in how I did this can check out my more specific response on the Ubuntu Forums... http://ubuntuforums.org/showthread.php?p=11152491#post11152491 This left me with an event
Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP]
*** Jorge, as I respond to your email I find out a range of things of note, as I try and support or refute my ideas. It is enlightening to read the entire post but you can just as easily jump to HERE *** Sorry Jorge, I suppose it is confusing. The problem is the corruption due to the insertion of the image is not immediately obvious. Then as the file becomes more progressively more corrupt. The sequence was like this 1. Cut-and-paste data 2. Reinsert images and objects 3. Other stuff... 4. Issue with comments noted What surprised me was after recreating a clean file for use I then ended up with an error popping up. No comments were found anywhere. So I stripped the file back to the individual components -- data, format, images, etc. Adding each one separately then testing extensively. On adding the images I noted some funny stuff happening to the file size. as I saved, re-saved, deleted sheets, re-saved, etc... I noticed that the file showed more problems rendering images (images disappeared as well as references to files disappeared). Soon afterwards the file had problems saving after deletion of the sheet. So I presume that the images caused the corruption of the structure, the problem progressively got worse, then the comments field tipped the scale and caused the error in saving after the deletion of the sheet. anyway that seems as plausible as any explanation I have seen already. As stated I am unable to reproduce these errors on new files. despite trying repeatedly for hours. As stated previously I was able to shake the problem by cutting-and-pasting the data into the spreadsheet. This included everything images and all. I could not trigger the error despite hours of testing. Consequently I posted the 'solution' to this thread. After several hours of adding and deleting data, the problem reappeared. As stated I then recreated the file including data-formula-format, minus other objects then progressively built up the file until it mimicked the original. Each step I tested, retested and checked yet again. In the end I noted things got 'wonky' after insertion of the images-artwork. this did not particularly make sense to me but I persisted in splitting the objects being inserted in the document until I could identify the culprit. This eventually identified a single image (originally a GIF that was converted to a PNG). Add this image to the sheet and progressively problems appear. If I recreate a PNG file using GIMP and insert this I can't get the problems to appear. This is using the same file, data and files - side by side. Very confusing. There is only two conclusions (a) that the file is corrupt, something corrupted it and at present the first thing I notice a problem occurring after it is inserted is this image. (b) that LO accesses and manipulated the file incorrectly. In other words their is a bug in the code. As I am not inclined to post a file with all my financial details on the Internet, and I have no other versions of LO around to test the second theory I am in a quantry. HERE Well... As it turns out I have an old version of OpenOffice 3.1.0 OOO310m11 (Build: 9399) lying around on an old Windows Vista laptop I was unaware about. Exact same file (except for one computer is accessing the local drive and the other a SAMBA network drive)... - LO baulks with the error blah blah unable to write - OO does not! Wh? Alright I am on Ununtu. I opened a copy of the file via nautilus from a local drive mounted using fstab - the error occurs. If I use nautilus to locate and access the same samba share the windows machine used - the error occurs. Somehow I am relieved. OK, I test using another machine ubuntu-ubuntu using LO 3.3.2, both via a NFS mount and Samba share. Both sheet deletions and saved worked on the exact same file that my machine baulks with - that is the error did not occur. I am bloody confused! The problem is computer specific and file specific. As part of the entire exercise I completely uninstalled every LO related package and reinstalled them with all the dependencies. I have check and rechecked the file permissions, ownerships and groups. Nothing untoward. Anyone got any ideas? if the disk was damaged then then all computer would complain. This leaves be with some conflict or background process that is interfering with the operation I am trying to do... you know the operation I can reproduce on any other file, except when I cut and paste data from the original file. Sound a lot like a corrupt disk, but how does the NFS and Samba Shares NOT trigger this error. On 12/08/11 14:28, jorge wrote: Hi I'm some confused. Was the comment or the image the problem ? or Both ? Regards, Jorge Rodríguez _ El vie, 12-08-2011 a las 13:52 +1000, Simon Cropper escribió: Hi Everyone, I have been doing some follow-up investigations that I thought you might like to be made aware.
Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP]
On 12/08/11 14:38, planas wrote: On Fri, 2011-08-12 at 13:52 +1000, Simon Cropper wrote: Hi Everyone, I have been doing some follow-up investigations that I thought you might like to be made aware. First, why? Well after testing the file that I recreated by copying the text, formula and styles I could not cause the error to occur again. This is what I reported yesterday. I then proceeded with importing the few images and 'artwork' objects from the old file to the new. After several saves and sheet manipulations I noticed the file became unstable again. The outcome of my investigation was that one of the image files used on one of the sheets had become corrupted* and adding this file in caused the file to become unstable - eventually exhibiting the problem I mentioned about not being able to save after a sheet was deleted. These 'corrupted' files are relatively benign with the error only becoming apparent *once* you attempt to delete the sheet. So somehow the error caused problems with the broader 'workbook' structure not the sheet structure. Although I compared files between different versions of the file the XML were too varied (usually style names and definitions; content was identical). * note I say corrupted but it rendered OK and only resulted in the observed behaviour one a sheet is deleted. I 'deem' it corrupted as once replaced with a clean version render and saved as a new file by GIMP, the problem disappeared. The error was with the particular corrupt objects. On recreating new images and inserting them into a file I have not been able to trigger any problems. If I cut-and-paste from the original 'corrupt' file the file becomes unstable after a few saves and sheet manipulations. So the steps for salvage is... 1. recreate a new file with the exact number of sheets as the original. Ensure each sheet names are the same. 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the content being placed in the new file to text, numbers, date time, formulas and formats. 3. If you have images in the file. Recreate / Save using another package. As mentioned I used GIMP. 4. Insert new copies of the images into file. *Don't* cut-and-paste objects from the old file. 5. If you have any lines, text boxes and artwork; recreate them from new. During this process... - Save as a new version (+tabs, +data, +images, +other objects) following each step. - Test each version thoroughly before proceeding. - Only add one object at a time, so if something goes wrong you can isolate the problem component. - To check it is not a bug try and recreate with a fresh file. A couple of quick notes that may be valuable to others... - ODS files are archives. Use an archive facility to extract the data inside. Inspect the contents in the folders to see what is different. - On every 'Save as' the file size changes. This is not due to changes in the file contents, but rather in changes in how the components of the file is compressed/archived. If you open a file, add objects then save, the file size with be so big. Open that file and Save as a new name and the file will be a different size. If you extract the files the contents of all the files and directories are identical. It is just the internal archive facility in LO will decide the best compaction routine based on what it encounters. - The content.xml file can be quite large and has no internal end-of-line characters. This make it difficult to open and be parse by various text editors, xml viewers and comparison facilities. To insert a EOL character after the end of each tag (i.e.), I used the following command in the terminal (requires Linux). cat content.xml | sed -e 's//\n/g' content_with_linebreaks.xml cat just spews the content of the text file to the standard output. I then pipe it to sed, where I used regular expressions to find '' and replace every instance of it with '\n'. I then compared the contents with Diffuse. Snip +1 I wonder how the images got corrupted, interesting. planas, See my reply to Jorge. In particular the discovery that suggests that the file may be physically damaged, or at lease the sector that it resides. I am going to check for damage now. -- 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+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP]
Hi I don't know what will be happening. But I think that if in other computer or program LO 3.3.2 you don't have problem to use the file, ...the file ins't corrupted and newer LO neither. I think that Vista or the OpenOffice 3.1.0 would lose something as program by whatever way and / or the computer where you have it installed has something fisical bad. I suggest you a probe (If you have some free time): Why not install again OpenOffice 3.1.0 in other computer and try to use the file? (With and without new Vista installation) Regards, Jorge Rodríguez ___ El vie, 12-08-2011 a las 16:04 +1000, Simon Cropper escribió: *** Jorge, as I respond to your email I find out a range of things of note, as I try and support or refute my ideas. It is enlightening to read the entire post but you can just as easily jump to HERE *** Sorry Jorge, I suppose it is confusing. The problem is the corruption due to the insertion of the image is not immediately obvious. Then as the file becomes more progressively more corrupt. The sequence was like this 1. Cut-and-paste data 2. Reinsert images and objects 3. Other stuff... 4. Issue with comments noted What surprised me was after recreating a clean file for use I then ended up with an error popping up. No comments were found anywhere. So I stripped the file back to the individual components -- data, format, images, etc. Adding each one separately then testing extensively. On adding the images I noted some funny stuff happening to the file size. as I saved, re-saved, deleted sheets, re-saved, etc... I noticed that the file showed more problems rendering images (images disappeared as well as references to files disappeared). Soon afterwards the file had problems saving after deletion of the sheet. So I presume that the images caused the corruption of the structure, the problem progressively got worse, then the comments field tipped the scale and caused the error in saving after the deletion of the sheet. anyway that seems as plausible as any explanation I have seen already. As stated I am unable to reproduce these errors on new files. despite trying repeatedly for hours. As stated previously I was able to shake the problem by cutting-and-pasting the data into the spreadsheet. This included everything images and all. I could not trigger the error despite hours of testing. Consequently I posted the 'solution' to this thread. After several hours of adding and deleting data, the problem reappeared. As stated I then recreated the file including data-formula-format, minus other objects then progressively built up the file until it mimicked the original. Each step I tested, retested and checked yet again. In the end I noted things got 'wonky' after insertion of the images-artwork. this did not particularly make sense to me but I persisted in splitting the objects being inserted in the document until I could identify the culprit. This eventually identified a single image (originally a GIF that was converted to a PNG). Add this image to the sheet and progressively problems appear. If I recreate a PNG file using GIMP and insert this I can't get the problems to appear. This is using the same file, data and files - side by side. Very confusing. There is only two conclusions (a) that the file is corrupt, something corrupted it and at present the first thing I notice a problem occurring after it is inserted is this image. (b) that LO accesses and manipulated the file incorrectly. In other words their is a bug in the code. As I am not inclined to post a file with all my financial details on the Internet, and I have no other versions of LO around to test the second theory I am in a quantry. HERE Well... As it turns out I have an old version of OpenOffice 3.1.0 OOO310m11 (Build: 9399) lying around on an old Windows Vista laptop I was unaware about. Exact same file (except for one computer is accessing the local drive and the other a SAMBA network drive)... - LO baulks with the error blah blah unable to write - OO does not! Wh? Alright I am on Ununtu. I opened a copy of the file via nautilus from a local drive mounted using fstab - the error occurs. If I use nautilus to locate and access the same samba share the windows machine used - the error occurs. Somehow I am relieved. OK, I test using another machine ubuntu-ubuntu using LO 3.3.2, both via a NFS mount and Samba share. Both sheet deletions and saved worked on the exact same file that my machine baulks with - that is the error did not occur. I am bloody confused! The problem is computer specific and file specific. As part of the entire exercise I completely uninstalled every LO related package and reinstalled them with all the dependencies. I have check and rechecked the file permissions, ownerships and groups. Nothing
Re: [libreoffice-users] Calc will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 05:23 PM, Simon Cropper wrote: It is obvious that you do not like OO or LO Calc, and that you don't like the fact that your data is continually corrupted. LO is a tool. I neither like or dislike it. As a tool, it has a major defect in that it periodically destroys the product which was built using it. You're right in that I don't like the tool I'm using to destroy my work. You also say you continuously have to rebuild your spreadsheet and that the process can take several days. Just spent 2 long days recreating the spreadsheet using 2 machines. Not fun. If you are so unhappy with the format, corruption and dirty code, my question is why do you persist? I've got a lot of investment in my macro code (9000 lines of it) that can only function within LO. I can't migrate it to something else as is. Had I known about the corruption when I started the project 6 years ago, I would have chosen a different platform. I would have never imagined that over the course of several years that corruption issues would be ignored. That's just inconceivable to me as a professional software developer, but that's apparently the reality. Change packages. Can't, as was mentioned above, unless I rewrite everything. Sad to say, LO is the only real competitor to MS Office and given its corruption history it will turn a lot of people off that might have moved away from MS Windows to Linux had the product been reliable. My real interest is in moving people away from a lousy operating system like Windows to something near bullet proof like Linux. We all need applications tools like word processing, spreadsheet, etc, so a tool like LO is vitally important to Linux adoption. If I could get MS Office compiled to run on Linux as a native application, I'd forget about LO in a heartbeat. MS Office is the best thing Microsoft has. It works well in its native environment. I wish I could say the same for LO, and that's why I'm critical of it. With the time and effort you have already put into recreating corrupted spreadsheets you could of written your own application or mastered alternative packages. I guess you don't write code for a living. I estimate a rewrite of my POS system would take well over a year of my time. While that's going on, I need something reliable to help run a business. I have sketched out a web based replacement much much more sophisticated than what I'm using now, and plan on developing it when I have the time. Wasting time reporting OO / LO bugs that never get taken seriously and recreating a spreadsheet periodically helps keeps me from such a new development effort. My wife (also a professional software developer) keeps telling me to stop wasting time reporting issues - that I'm tilting at windmills. She may be right. I am not trying to be rude here it just if I had a package that caused me so much wasted time I would just move on. I will move on in time, but in the interim, I'd like LO to thrive in the market, and that won't happen unless it becomes reliable. My problem is really with LO management. There isn't any. Despite what you may think, I'm more interested in LO's success than most people are, and I know it won't be successful long term unless its reliable. It hasn't been reliable for years and that's a problem. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5EEGMACgkQ7Orvev+eC8rvIACgly5u6U6eM9DeiCbJJ5++k8rf BpUAoIy9kOViLVFCssIwmN3BfCGnR+Dy =ct68 -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP]
Hi Everyone, I have been doing some follow-up investigations that I thought you might like to be made aware. First, why? Well after testing the file that I recreated by copying the text, formula and styles I could not cause the error to occur again. This is what I reported yesterday. I then proceeded with importing the few images and 'artwork' objects from the old file to the new. After several saves and sheet manipulations I noticed the file became unstable again. The outcome of my investigation was that one of the image files used on one of the sheets had become corrupted* and adding this file in caused the file to become unstable - eventually exhibiting the problem I mentioned about not being able to save after a sheet was deleted. These 'corrupted' files are relatively benign with the error only becoming apparent *once* you attempt to delete the sheet. So somehow the error caused problems with the broader 'workbook' structure not the sheet structure. Although I compared files between different versions of the file the XML were too varied (usually style names and definitions; content was identical). * note I say corrupted but it rendered OK and only resulted in the observed behaviour one a sheet is deleted. I 'deem' it corrupted as once replaced with a clean version render and saved as a new file by GIMP, the problem disappeared. The error was with the particular corrupt objects. On recreating new images and inserting them into a file I have not been able to trigger any problems. If I cut-and-paste from the original 'corrupt' file the file becomes unstable after a few saves and sheet manipulations. So the steps for salvage is... 1. recreate a new file with the exact number of sheets as the original. Ensure each sheet names are the same. 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the content being placed in the new file to text, numbers, date time, formulas and formats. 3. If you have images in the file. Recreate / Save using another package. As mentioned I used GIMP. 4. Insert new copies of the images into file. *Don't* cut-and-paste objects from the old file. 5. If you have any lines, text boxes and artwork; recreate them from new. During this process... - Save as a new version (+tabs, +data, +images, +other objects) following each step. - Test each version thoroughly before proceeding. - Only add one object at a time, so if something goes wrong you can isolate the problem component. - To check it is not a bug try and recreate with a fresh file. A couple of quick notes that may be valuable to others... - ODS files are archives. Use an archive facility to extract the data inside. Inspect the contents in the folders to see what is different. - On every 'Save as' the file size changes. This is not due to changes in the file contents, but rather in changes in how the components of the file is compressed/archived. If you open a file, add objects then save, the file size with be so big. Open that file and Save as a new name and the file will be a different size. If you extract the files the contents of all the files and directories are identical. It is just the internal archive facility in LO will decide the best compaction routine based on what it encounters. - The content.xml file can be quite large and has no internal end-of-line characters. This make it difficult to open and be parse by various text editors, xml viewers and comparison facilities. To insert a EOL character after the end of each tag (i.e. ), I used the following command in the terminal (requires Linux). cat content.xml | sed -e 's//\n/g' content_with_linebreaks.xml cat just spews the content of the text file to the standard output. I then pipe it to sed, where I used regular expressions to find '' and replace every instance of it with '\n'. I then compared the contents with Diffuse. 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
Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP]
Hi I'm some confused. Was the comment or the image the problem ? or Both ? Regards, Jorge Rodríguez _ El vie, 12-08-2011 a las 13:52 +1000, Simon Cropper escribió: Hi Everyone, I have been doing some follow-up investigations that I thought you might like to be made aware. First, why? Well after testing the file that I recreated by copying the text, formula and styles I could not cause the error to occur again. This is what I reported yesterday. I then proceeded with importing the few images and 'artwork' objects from the old file to the new. After several saves and sheet manipulations I noticed the file became unstable again. The outcome of my investigation was that one of the image files used on one of the sheets had become corrupted* and adding this file in caused the file to become unstable - eventually exhibiting the problem I mentioned about not being able to save after a sheet was deleted. These 'corrupted' files are relatively benign with the error only becoming apparent *once* you attempt to delete the sheet. So somehow the error caused problems with the broader 'workbook' structure not the sheet structure. Although I compared files between different versions of the file the XML were too varied (usually style names and definitions; content was identical). * note I say corrupted but it rendered OK and only resulted in the observed behaviour one a sheet is deleted. I 'deem' it corrupted as once replaced with a clean version render and saved as a new file by GIMP, the problem disappeared. The error was with the particular corrupt objects. On recreating new images and inserting them into a file I have not been able to trigger any problems. If I cut-and-paste from the original 'corrupt' file the file becomes unstable after a few saves and sheet manipulations. So the steps for salvage is... 1. recreate a new file with the exact number of sheets as the original. Ensure each sheet names are the same. 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the content being placed in the new file to text, numbers, date time, formulas and formats. 3. If you have images in the file. Recreate / Save using another package. As mentioned I used GIMP. 4. Insert new copies of the images into file. *Don't* cut-and-paste objects from the old file. 5. If you have any lines, text boxes and artwork; recreate them from new. During this process... - Save as a new version (+tabs, +data, +images, +other objects) following each step. - Test each version thoroughly before proceeding. - Only add one object at a time, so if something goes wrong you can isolate the problem component. - To check it is not a bug try and recreate with a fresh file. A couple of quick notes that may be valuable to others... - ODS files are archives. Use an archive facility to extract the data inside. Inspect the contents in the folders to see what is different. - On every 'Save as' the file size changes. This is not due to changes in the file contents, but rather in changes in how the components of the file is compressed/archived. If you open a file, add objects then save, the file size with be so big. Open that file and Save as a new name and the file will be a different size. If you extract the files the contents of all the files and directories are identical. It is just the internal archive facility in LO will decide the best compaction routine based on what it encounters. - The content.xml file can be quite large and has no internal end-of-line characters. This make it difficult to open and be parse by various text editors, xml viewers and comparison facilities. To insert a EOL character after the end of each tag (i.e. ), I used the following command in the terminal (requires Linux). cat content.xml | sed -e 's//\n/g' content_with_linebreaks.xml cat just spews the content of the text file to the standard output. I then pipe it to sed, where I used regular expressions to find '' and replace every instance of it with '\n'. I then compared the contents with Diffuse. 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
Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP]
On Fri, 2011-08-12 at 13:52 +1000, Simon Cropper wrote: Hi Everyone, I have been doing some follow-up investigations that I thought you might like to be made aware. First, why? Well after testing the file that I recreated by copying the text, formula and styles I could not cause the error to occur again. This is what I reported yesterday. I then proceeded with importing the few images and 'artwork' objects from the old file to the new. After several saves and sheet manipulations I noticed the file became unstable again. The outcome of my investigation was that one of the image files used on one of the sheets had become corrupted* and adding this file in caused the file to become unstable - eventually exhibiting the problem I mentioned about not being able to save after a sheet was deleted. These 'corrupted' files are relatively benign with the error only becoming apparent *once* you attempt to delete the sheet. So somehow the error caused problems with the broader 'workbook' structure not the sheet structure. Although I compared files between different versions of the file the XML were too varied (usually style names and definitions; content was identical). * note I say corrupted but it rendered OK and only resulted in the observed behaviour one a sheet is deleted. I 'deem' it corrupted as once replaced with a clean version render and saved as a new file by GIMP, the problem disappeared. The error was with the particular corrupt objects. On recreating new images and inserting them into a file I have not been able to trigger any problems. If I cut-and-paste from the original 'corrupt' file the file becomes unstable after a few saves and sheet manipulations. So the steps for salvage is... 1. recreate a new file with the exact number of sheets as the original. Ensure each sheet names are the same. 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the content being placed in the new file to text, numbers, date time, formulas and formats. 3. If you have images in the file. Recreate / Save using another package. As mentioned I used GIMP. 4. Insert new copies of the images into file. *Don't* cut-and-paste objects from the old file. 5. If you have any lines, text boxes and artwork; recreate them from new. During this process... - Save as a new version (+tabs, +data, +images, +other objects) following each step. - Test each version thoroughly before proceeding. - Only add one object at a time, so if something goes wrong you can isolate the problem component. - To check it is not a bug try and recreate with a fresh file. A couple of quick notes that may be valuable to others... - ODS files are archives. Use an archive facility to extract the data inside. Inspect the contents in the folders to see what is different. - On every 'Save as' the file size changes. This is not due to changes in the file contents, but rather in changes in how the components of the file is compressed/archived. If you open a file, add objects then save, the file size with be so big. Open that file and Save as a new name and the file will be a different size. If you extract the files the contents of all the files and directories are identical. It is just the internal archive facility in LO will decide the best compaction routine based on what it encounters. - The content.xml file can be quite large and has no internal end-of-line characters. This make it difficult to open and be parse by various text editors, xml viewers and comparison facilities. To insert a EOL character after the end of each tag (i.e. ), I used the following command in the terminal (requires Linux). cat content.xml | sed -e 's//\n/g' content_with_linebreaks.xml cat just spews the content of the text file to the standard output. I then pipe it to sed, where I used regular expressions to find '' and replace every instance of it with '\n'. I then compared the contents with Diffuse. Snip +1 I wonder how the images got corrupted, interesting. Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
On 10/08/11 13:07, Steve Edmonds wrote: Hi. On 2011-08-10 14:00, Simon Cropper wrote: On 10/08/11 10:22, Bill Gradwohl wrote: On 08/09/2011 05:46 PM, Simon Cropper wrote: *Has anyone encountered or heard of a similar problem?* *Anyone got some ideas?* Check out the bug I just created at https://bugs.freedesktop.org/show_bug.cgi?id=39930 I've been fighting this corruption issue for YEARS and can't get anyone to look at it seriously. They keep coming out with new releases, but none of them ever solve these corruption problems. When LO saves a file and then can't reopen it successfully, it is LO's problem regardless of what an end user might have done. They keep putting a new coat of paint on a rusty chassis and are shocked, shocked when someone points out the rot. -- Bill Gradwohl Roatan, Honduras Hi Bill, I was aware of your issue but don't believe we are talking about the same problem. My symptoms are quite different. I am not sure at present whether the problem is a corrupt file or wonky OO/LO code. I may be wrong, but I have always thought that a Save As saves in a newly created file formatted from scratch. If a file that has been Saved As still exhibits the problem I would think that 1. if the file is corrupted LO is corrupting it and has a bug or 2. if the file is not corrupted (you could delete a sheet in say OOO?) then the bug is in LO. Either way LO has a bug. steve Steve, 1. I am not sure about 'Save as' myself. My testing though suggests it only converts or resets the internal file structure on conversion to another format. ODS to ODS does not appear to rewrite the internal structure. 2. the files created with 'Save as' does exhibit the problem. This indicates the problem is file specific and able to be transmitted to derivatives. 3. The problem can not be recreated in a freshly created ODS file, so in essence you could argue it is not a bug. 4. My gut feeling is the file structure is somehow corrupted. Nothing that would affect normal operation but shows up when conducting broadscale sheet manipulations. How this change has come about is unclear. OK, to prove a point, I stripped everything out of a copy of the file except the tabs and underlying structure. I opened each tab, deleted the text and cleared the font / background / linework formatting using the toolbar options. Removed the freeze panes and an object (images or textboxes) from the sheet. Saved. Tried to delete a sheet and behold, wouldn't you guess it, the file saved OK. This is a Seinfield moment I am currently holding my head in my hands repeating serenity now! serenity now! OK. OK. This indicates that something has been added to the file in recent months that is causing the problem -- an image, some imported text... h.. Really the only input to this file is text/numbers entered via the keyboard or the importation of text/numbers via CSV downloaded from a bank account. I stripped these but it made no change. *The short version* To cut a long process short I deleted a sheet then proceeded to clear the contents of other sheets progressively *until* I was able to save. This identified the sheet. I then repeated this process until I identified a single cell. In fact it was a 'duplicate cell'. This cell has an associated picklist -- that is cell range with a variety of legitimate values. It also has a comment inserted. This comment is simply an explanation and reminder to do something. *Delete the comment* and the sheet saves as expected; undo the change and the error appears. I say 'duplicate' because I copied and paste this block to another location on the same sheet as a 'fixed' copy (as the original has VLOOKUPs that change based on picklist value) but neglected to omit the comments so they were duplicated. *Some additional testing* 1. Going back to some 'uncorrupted' files from 2009 I am unable to reproduce the error. 2. If I create a new file I can not reproduce the error. 3. It is necessary to delete both the original and copy of the comment in question. Deleting one or the other makes no difference, both must be deleted. inspection of the contents.xml in the archive only shows one comment (I have no idea if this is normal; I presume a reference to the 'comment' object was cmpies not the object). 4. Once the offending comment-pair are deleted then the file works as expected. 5. If you reinsert a comment in the sheet -- after saving, closing and reopening the 'corrupted' file, you get an error again. 6. If you insert a comment in other sheet. In most the save works but for a couple it does not. I can not find any visible similarity in the data, format or objects on these pages (the error is triggered on certain sheets only). 7. If you create a new sheet, copy the text/numbers/format//formulas to the new sheet and delete the offending 'corrupt sheet'. Deleting another sheet does not trigger the error. If you insert a
Re: [libreoffice-users] Calc will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 12:41 AM, Simon Cropper wrote: Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. When LO can't read its own handwriting, so to speak, does that not prove LO has a serious problem? When you use only the tools provided by LO to manipulate your document and that document gets trashed due to corruption, does that not prove LO has a serious problem? Now that you've concluded that corruption has occurred, what do you think should happen to the software that did the corrupting? A: ) Should it get fixed? or B: ) Should it stay broken, and in return for not expending the effort to fix the underlying rot, you'll accept the next releases 3 new bells and 4 whistles? Check the archives and you'll note that file corruption is a frequent problem. Its as though giving buggy software the label file corruption absolves the developers of investigating and eliminating the underlying code bugs. I've been reporting corruption issues for years and in that time only one developer (with an oracle email address) ever showed any interest. Even he dropped off the radar when Oracle lost interest in the office suite. Does LO provide a needed service? Yes it does, just as a Ford coasting down a highway provides a service. The difference is that if a Ford gas tank blew up periodically, Ford would fix it. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CkUsACgkQ7Orvev+eC8p1pQCeOXYJZ0Hxviu0Vx3FQrS1y0KY OPAAn1FA2iVoMjWyXvUwdLIuTaYVfAT6 =KOyQ -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
Hi :) Please post a new bug-report against LibreOffice rather than against OpenOffice. It stands a good chance of getting soem attention now. A lot of stuff just got sat on by Sun forever it seems. LibreOffice is vastly more interested in actually fixing things and TDF doesn't block the devs from doing stuff even if they are voluntary devs rather employees. As long as stuff passes quality control it's allowed in. Regards from Tom :) From: Bill Gradwohl b...@ycc.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 15:10:26 Subject: Re: [libreoffice-users] Calc will not save file after sheet deleted. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 12:41 AM, Simon Cropper wrote: Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. When LO can't read its own handwriting, so to speak, does that not prove LO has a serious problem? When you use only the tools provided by LO to manipulate your document and that document gets trashed due to corruption, does that not prove LO has a serious problem? Now that you've concluded that corruption has occurred, what do you think should happen to the software that did the corrupting? A: ) Should it get fixed? or B: ) Should it stay broken, and in return for not expending the effort to fix the underlying rot, you'll accept the next releases 3 new bells and 4 whistles? Check the archives and you'll note that file corruption is a frequent problem. Its as though giving buggy software the label file corruption absolves the developers of investigating and eliminating the underlying code bugs. I've been reporting corruption issues for years and in that time only one developer (with an oracle email address) ever showed any interest. Even he dropped off the radar when Oracle lost interest in the office suite. Does LO provide a needed service? Yes it does, just as a Ford coasting down a highway provides a service. The difference is that if a Ford gas tank blew up periodically, Ford would fix it. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CkUsACgkQ7Orvev+eC8p1pQCeOXYJZ0Hxviu0Vx3FQrS1y0KY OPAAn1FA2iVoMjWyXvUwdLIuTaYVfAT6 =KOyQ -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 08:24 AM, Tom Davies wrote: Hi :) Please post a new bug-report against LibreOffice rather than against OpenOffice. It stands a good chance of getting soem attention now. I already did: https://bugs.freedesktop.org/show_bug.cgi?id=39930 I'm in the process of once again rewriting my spreadsheet from scratch and importing my macro code into it. At least 2 days worth of tedious work. The bug report I submitted was to help someone else avoid my problems in the future should the underlying root cause of the corruption I'm seeing get fixed. A fix won't help me now, as I don't trust the .ods file contents. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CpyoACgkQ7Orvev+eC8rAvwCgs8vTIfZBzm7oljLl0U8yPRmK NqMAoMT9BNc7BctLOyye0ILePyYN2m5Y =UQsx -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
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 scrop...@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 -- For unsubscribe instructions e-mail to: users+h
Re: [libreoffice-users] Calc will not save file after sheet deleted.
On 11/08/11 00:10, Bill Gradwohl wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 12:41 AM, Simon Cropper wrote: Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. When LO can't read its own handwriting, so to speak, does that not prove LO has a serious problem? When you use only the tools provided by LO to manipulate your document and that document gets trashed due to corruption, does that not prove LO has a serious problem? Now that you've concluded that corruption has occurred, what do you think should happen to the software that did the corrupting? A: ) Should it get fixed? or B: ) Should it stay broken, and in return for not expending the effort to fix the underlying rot, you'll accept the next releases 3 new bells and 4 whistles? Check the archives and you'll note that file corruption is a frequent problem. Its as though giving buggy software the label file corruption absolves the developers of investigating and eliminating the underlying code bugs. I've been reporting corruption issues for years and in that time only one developer (with an oracle email address) ever showed any interest. Even he dropped off the radar when Oracle lost interest in the office suite. Does LO provide a needed service? Yes it does, just as a Ford coasting down a highway provides a service. The difference is that if a Ford gas tank blew up periodically, Ford would fix it. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ Bill, It is obvious that you do not like OO or LO Calc, and that you don't like the fact that your data is continually corrupted. You also say you continuously have to rebuild your spreadsheet and that the process can take several days. If you are so unhappy with the format, corruption and dirty code, my question is why do you persist? Change packages. With the time and effort you have already put into recreating corrupted spreadsheets you could of written your own application or mastered alternative packages. I am not trying to be rude here it just if I had a package that caused me so much wasted time I would just move on. -- 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+h...@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
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 Cropperscrop...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted [SOLUTION]
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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted [SOLUTION]
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 -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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
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+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
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 -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
Simon, On Wed, 2011-08-10 at 09:46 +1000, Simon Cropper wrote: 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 I have two thoughts: first can you from a known well behaved file move forward without any difficulties and the second is to either install 3.4.2 or 3.3.3 and see if the problem clears up. I believe you have a corrupted file. If moving forward works, its a pain but it might be easier to recreate what you need from the clean fork. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
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 -- 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+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
On 10/08/11 10:08, planas wrote: Simon, On Wed, 2011-08-10 at 09:46 +1000, Simon Cropper wrote: 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 I have two thoughts: first can you from a known well behaved file move forward without any difficulties and the second is to either install 3.4.2 or 3.3.3 and see if the problem clears up. I believe you have a corrupted file. If moving forward works, its a pain but it might be easier to recreate what you need from the clean fork. 1. I can but it will require effort. This is not a problem except that without knowing the problem I might spend a day cutting-and-pasting the formulas and macros only to find the problem is transferred. 2. Downloading 3.4.2 as we speak to see if the problem persists. 3. I also suspect I have a corrupt file but as it contains unique data and complex formula I will need to move these into the new file. As stated above I am reticent to do this without knowing where the error resides and why it occurred. 4. My preference is to recreate a clean fork -- assuming the file is actually corrupt, so I have confidence it using the file. -- 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+h...@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
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+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
On 08/09/2011 05:46 PM, Simon Cropper wrote: *Has anyone encountered or heard of a similar problem?* *Anyone got some ideas?* Check out the bug I just created at https://bugs.freedesktop.org/show_bug.cgi?id=39930 I've been fighting this corruption issue for YEARS and can't get anyone to look at it seriously. They keep coming out with new releases, but none of them ever solve these corruption problems. When LO saves a file and then can't reopen it successfully, it is LO's problem regardless of what an end user might have done. They keep putting a new coat of paint on a rusty chassis and are shocked, shocked when someone points out the rot. -- Bill Gradwohl Roatan, Honduras -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
On 10/08/11 10:22, Bill Gradwohl wrote: On 08/09/2011 05:46 PM, Simon Cropper wrote: *Has anyone encountered or heard of a similar problem?* *Anyone got some ideas?* Check out the bug I just created at https://bugs.freedesktop.org/show_bug.cgi?id=39930 I've been fighting this corruption issue for YEARS and can't get anyone to look at it seriously. They keep coming out with new releases, but none of them ever solve these corruption problems. When LO saves a file and then can't reopen it successfully, it is LO's problem regardless of what an end user might have done. They keep putting a new coat of paint on a rusty chassis and are shocked, shocked when someone points out the rot. -- Bill Gradwohl Roatan, Honduras Hi Bill, I was aware of your issue but don't believe we are talking about the same problem. My symptoms are quite different. I am not sure at present whether the problem is a corrupt file or wonky OO/LO code. -- 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+h...@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
Re: [libreoffice-users] Calc will not save file after sheet deleted.
Hi. On 2011-08-10 14:00, Simon Cropper wrote: On 10/08/11 10:22, Bill Gradwohl wrote: On 08/09/2011 05:46 PM, Simon Cropper wrote: *Has anyone encountered or heard of a similar problem?* *Anyone got some ideas?* Check out the bug I just created at https://bugs.freedesktop.org/show_bug.cgi?id=39930 I've been fighting this corruption issue for YEARS and can't get anyone to look at it seriously. They keep coming out with new releases, but none of them ever solve these corruption problems. When LO saves a file and then can't reopen it successfully, it is LO's problem regardless of what an end user might have done. They keep putting a new coat of paint on a rusty chassis and are shocked, shocked when someone points out the rot. -- Bill Gradwohl Roatan, Honduras Hi Bill, I was aware of your issue but don't believe we are talking about the same problem. My symptoms are quite different. I am not sure at present whether the problem is a corrupt file or wonky OO/LO code. I may be wrong, but I have always thought that a Save As saves in a newly created file formatted from scratch. If a file that has been Saved As still exhibits the problem I would think that 1. if the file is corrupted LO is corrupting it and has a bug or 2. if the file is not corrupted (you could delete a sheet in say OOO?) then the bug is in LO. Either way LO has a bug. steve -- For unsubscribe instructions e-mail to: users+h...@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