From: davey@example.invalid   
      
   On Wed, 7 May 2025 18:37:59 +0100   
   Jeff Layman 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-DOS v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|