1. Forum
  2. Usenet
  3. ALT.OS.LINUX.UBUNTU

  • Libre Office Calc puzzle

    From Davey@21:1/5 to All on Wed May 7 10:00:32 2025
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jeff Layman@21:1/5 to Davey on Wed May 7 18:37:59 2025
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Davey@21:1/5 to Jeff Layman on Wed May 7 21:14:31 2025
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)