Calc will not save file after sheet deleted.

users
#41

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

#42

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 that could have occurred while the affected file was open that could have resulted in the identified corruption. In fact, on reflection I did have a power blackout 3-weeks ago! I know pretty much exactly when it occurred and so was able to work out exactly what I was doing... as it turns out I was editing the exact sheet in the corrupted file that contained the corrupted image!

As LO had 'recovered' the file; all text, formula and images were present and encountered for; and rendering as expected, I never even thought the file was damaged; so much so that 2-weeks later when peculiar 'sheet/tab deletion errors' appeared I did not even connect the two events (power outage and corruption).

Thanks everyone for your help - I appreciate your efforts and suggestions.

#43

In news:4E4867E6.8030804@botanicusaustralia.com.au,
Simon Cropper <scropper@botanicusaustralia.com.au> typed:

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 that could have occurred while
the affected file was open that could have resulted in
the identified corruption. In fact, on reflection I did
have a power blackout 3-weeks ago! I know pretty much
exactly when it occurred and so was able to work out
exactly what I was doing... as it turns out I was editing
the exact sheet in the corrupted file that contained the
corrupted image!
As LO had 'recovered' the file; all text, formula and
images were present and encountered for; and rendering as expected, I
never even thought the file was damaged; so much so that
2-weeks later when peculiar 'sheet/tab deletion errors' appeared I did not
even connect the two events (power outage and corruption).

Thanks everyone for your help - I appreciate your efforts
and suggestions.
--
Cheers Simon

   Simon Cropper
   Principal Consultant
   Botanicus Australia Pty Ltd
   PO Box 160, Sunshine, VIC
   W: www.botanicusaustralia.com.au

What does "could of" mean in the context of your usage? It makes no sense.
Could "have" would make sense, but several times you said "could of".

#44

Hi :slight_smile:
English has grown in many different directions. Pick any 'owsin' estate round
my way guv an you'll ear some riiite crackers an no mistake. Enuf t make your
hair curl ducks. Cor blimey n stone the crows. Eee burrit snot d same just
down the cherry and even up the apples it's all said different like. What,
what, what, smoke me a kipper, i'll be back for breakfast captain.

"Could have" contracts to "Could've" which morphs into "could of". Hth
Regards from
Tom :slight_smile:

#45

Hello Twayne,

Thank you for your feedback, albeit off topic. I take your point and will endeavour to ensure my colloquial tongue does not make it to the page again.

I find it a bit pretentious though that you ask what is obviously a rhetorical question - a gibe at the tail end of a lengthy technical discussion - on an international mail list dedicated to discussing the use of a particular program (rather than say a list that is discussing 'grammar' or 'English Usage') and personally I consider it bad etiquette (akin to FlameBait [1]); a polite email to me privately would have sufficed, if you actually did not know what I was saying.

In future, if you have the need to surreptitiously dress down someone for a spelling mistake, a grammatical error or maybe an unusual writing style, please refrain yourself from doing it. Participants on most mail lists come from a wide variety of backgrounds and do not appreciated being belittled in public.

[1] http://en.wikipedia.org/wiki/Flaming_(Internet)#Flamebait

#46

...

What does "could of" mean in the context of your usage? It makes no sense.
Could "have" would make sense, but several times you said "could of".

Hello Twayne,

Thank you for your feedback, albeit off topic. I take your point and
will endeavour to ensure my colloquial tongue does not make it to the
page again.

I find it a bit pretentious though that you ask what is obviously a
rhetorical question - a gibe at the tail end of a lengthy technical
discussion - on an international mail list dedicated to discussing the
use of a particular program (rather than say a list that is discussing
'grammar' or 'English Usage') and personally I consider it bad etiquette
(akin to FlameBait [1]); a polite email to me privately would have
sufficed, if you actually did not know what I was saying.

In future, if you have the need to surreptitiously dress down someone
for a spelling mistake, a grammatical error or maybe an unusual writing
style, please refrain yourself from doing it. Participants on most mail
lists come from a wide variety of backgrounds and do not appreciated
being belittled in public.

[1] http://en.wikipedia.org/wiki/Flaming_(Internet)#Flamebait

And don't forget to trim :slight_smile:

#47

Sorry :slight_smile:

#48

Yes, with your name you should certainly have no need to remember to
crop....

Many lists now recommend top posting, as that is far better when folks
read it on mobile devices. There seem to be a lot of posts on here
where the actually reply is a few lines right at the bottom of acres of
quoting.

Dave

> And don't forget to trim

Sorry :slight_smile:

http://www.davesergeant.com

#49

Hi :slight_smile:
Oh nooooo, Not that old flame-war again! lol

We have very adamant fan-boys (and ladies) on all 3 sides of this on-going
argument all with legitimate and great reasons why their way is the only
acceptable way and everyone else is a moron. Please, lets not go there again!
Regards from
Tom :slight_smile:

#50

Lets stir it, if we had a forum (like the old OOO one) there wouldn't be an argument on top or bottom posting.
I've read all the arguments, there are pros and cons for both (top/bottom, list/forum, the field is divided, so I just go with the flow.
I do object to trimming tho' because it wastes time trying to find all the trimmings to see the full discussion.
steve

#51

Hi :slight_smile:
+1
I think Twayne was showing his sense of humour again. In England good friends
often do petty jibes at each other in that way. The better the friendship the
more outrageous the jibes/jokes.

The problem imo is how people outside that friendship view it. A non-native
English speaker might be terrified to learn the level of precision apparently
required. On the other hand jokes/jibes like that can often release tension.

The next comment by someone else about snipping was hilarious imo but again it's
easy to read it in a different way from the way it was intended. If we were all
in a pub or at a cocktail party or other social gathering the meaning would have
been clearer from body-language and facial expressions. Sadly (or perhaps
fortunately in my case) all we see are the words printed on the screen.

Regards from
Tom :slight_smile:

#52

Hi :slight_smile:
Lol, superb. Great comedy timing! Now we might get a flame-war about which
flame-war is more important! Lol!!
Regards from
Tom :slight_smile: