From Newsgroup: alt.os.linux.ubuntu

I use a couple of spreadsheets to keep track of my bank account. One is
a running log, the other is a month-long snapshot. This one gets
diminished in size, so that I can keep it on the screen while
working on the log. All well and good. Suddenly, something changed, and
the small one was now locked into a size bordered by a blue line. I
could not find how to unlock it. Beyond the line, there were no
gridlines, and no action allowed.
I could only get this undone by creating a new spreadsheet, and copying
and pasting the active cells from the original sheet to the new one.
All is good. I saved the old sheet with the additional tag '-old'. When
I later re-opened it, it was as right as rain, as though there had
never been a problem.
Does anybody have any idea what happened here?
--
Davey.

--- Synchronet 3.20c-Linux NewsLink 1.2

From Newsgroup: alt.os.linux.ubuntu

On 07/05/2025 10:00, Davey wrote:

I use a couple of spreadsheets to keep track of my bank account. One is
a running log, the other is a month-long snapshot. This one gets
diminished in size, so that I can keep it on the screen while
working on the log. All well and good. Suddenly, something changed, and
the small one was now locked into a size bordered by a blue line. I
could not find how to unlock it. Beyond the line, there were no
gridlines, and no action allowed.
I could only get this undone by creating a new spreadsheet, and copying
and pasting the active cells from the original sheet to the new one.
All is good. I saved the old sheet with the additional tag '-old'. When
I later re-opened it, it was as right as rain, as though there had
never been a problem.
Does anybody have any idea what happened here?

No, but if you hadn't yet saved that change, wouldn't using "Edit |
Undo" remove it? Or was that greyed out and unavailable?
--
Jeff
--- Synchronet 3.20c-Linux NewsLink 1.2

From Newsgroup: alt.os.linux.ubuntu

On Wed, 7 May 2025 18:37:59 +0100
Jeff Layman <Jeff@invalid.invalid> wrote:

On 07/05/2025 10:00, Davey wrote:

I use a couple of spreadsheets to keep track of my bank account.
One is a running log, the other is a month-long snapshot. This one
gets diminished in size, so that I can keep it on the screen while
working on the log. All well and good. Suddenly, something changed,
and the small one was now locked into a size bordered by a blue
line. I could not find how to unlock it. Beyond the line, there
were no gridlines, and no action allowed.
I could only get this undone by creating a new spreadsheet, and
copying and pasting the active cells from the original sheet to the
new one. All is good. I saved the old sheet with the additional tag
'-old'. When I later re-opened it, it was as right as rain, as
though there had never been a problem.
Does anybody have any idea what happened here?

No, but if you hadn't yet saved that change, wouldn't using "Edit |
Undo" remove it? Or was that greyed out and unavailable?

Well, when I re-re-opened it, it was back to the old bad version, so I
had probably looked at the working one by mistake. So I have the bad
version, still, that I cannot fix, and the working version, made
from the cells of the bad one. Which means that there is no edit to
undo, after all.
As long as I have the new, working version, I'm happy, but I would love
to know what was wrong, so that I can fix it if it ever happens again.
--
Davey.

--- Synchronet 3.21a-Linux NewsLink 1.2