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! Whaaaa?
>
> 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.
> >>
> >> 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 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: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
