Top posted rather than a new thread, and the original text pushed down
as simply history to keep it connected. This is essentially a re-start
of the thread:
OK, I had a second occurrence of Calc refusing to Save a file. The
first was with OOo 2.4, this time with 2.4.1 (XP Pro SP2).
It consists of a lot of pasted data from many sources, largely text,
including the 'net, and a lot of my own entries too.
ALL other applications continued to function properly but Calc would
not Save or Save As. I could copy, move, delete, to/from the Calc file,
to/from itself and to/from other applications (Excel, Word, Writer),
CTRL-x, c, v, and z all work. I could copy data to new sheets and
delete the old sheets, but none of that helped anything. Everything
literally seemed to work but Save or Save As.
Other apps or other Calc files would Save OK; there is apparently,
my guess, something "broken" in one of the three Calc sheets within this
file. I don't have a large number of Notes in it, but I do have a
couple that, though they are long, they don't approach the length
limitations.
The error message is simple, no number, it simply says Calc cannot
save the file. The "X" for it is in the upper left corner rather than
the upper right as expected, and goes away when you click OK.
There's nothing personal in the file at all if anyone would like to see
it, but after closing without saving and then reopening it, it again
saves OK, same as last time. I've been faithful about saving so no data
was lost either although it seems like the last entry should have been
missing; I don't -think- it is!
I plan to keep using Calc for the time being for this file's intended
purpose, so I should be able to get it to happen again and try some
other things I didn't think to try this time. Any suggestions, let me
know. I'm leaning toward the sheet somehow being corrupted right now.
Next time I plan to try deleting parts of it useing the rule of halves
to find where the corruption might be unless someone has abetter idea.
Like I said, it CAN be copied to another file for saving while it's in
the "won't save" mode.
Unfortunately though I have put all my other Calc files back into
Excel until this is worked out; not that many were converted yet; I make
transitions like this slowly.
Any tips or suggestions? Requests to see the file?
Twayne
=============================
> I've tried hard to make Writer and Calc and work work for me, I really
> have, but this one has me baffled.
>
> XP Pro SP2 OOo 2.4.1
>
> Calc, two sheets in use, first sheet 55 rows long, two columns, a few
> Notes:
> I added data to two columns, the data in columnA being a URL, and
> clicked Save as I have learned to do when I add data slowly to a
> program. It's been open for a couple hours total.
>
> First, it warned me there were Notes; I said OK
>
> Then it refused to save, givieng no logical reason other than it would
> not save.
>
> I deleted the most recent entry, tried Save again, still refused to
> save.
>
> Deleted another row, same thing.
>
> Ctrl-Z'd that data back in and copied it all into Excel before I lost
> it; very hard to reproduce. Yes, it gets archived but only nightly.
>
> Closed/reopened Calc and Calc's memory of the file in Recent Documents
> didn't exist. Prior to this it has been there (for about two weeks)
> and was not pushed out by opening new documents.
>
> Located, opened the .ods file; now it's read-only. Closed, reopened
> again:
> Still not in Recent Documents list, not read only and actually seems
> to be working OK now.
>
> Any thoughts what happened? Is there some relationship to that Notes
> message box? Any guesses why it did this and what odds are it will do
> it again?
>
> I plan to continue now using Excel, since I know it won't do things
> like that, or think so anyway, and I'll keep the Calc file around for
> fiddling with.
>
> TIA for your thoughts/advice
>
> Twayne
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
