Hi All,
Hoping someone like @mikekaganski might be able to help me with this.
I’ve just had the weirdest experience with file recovery.
I finished working on a Calc spreadsheet document last night. Every morning when I start I make a copy in the finder (Mac) and rename it so I have a safe copy archived and untouched of the work to date.
Often LO crashes the first time I try confirming a formula change. That can be hours into my day if I’m not amending formulas, but it happens this way quite often.
One of the last things I changed last night before I stopped working on that version of my document, was to swap out a fairly complicated and inefficient formula, with a more efficient “LET Function” version that did the same job.
This morning when I opened a copy of the file from last night to carry on where I left off, it was all working as I’d left it. Great. Normal expected behaviour.
I typed a small and inoccuous formula into an unrelated cell and when I confirmed, I had the usual crash with the offer to Recover my document. I selected OK and when the spreadsheet opened, my LET formula had been replaced with the old formula I’d swapped out last night.
No problem I thought, I’ll make a new copy of last night’s file and try afresh again.
This is where the weirdness gets very weird!
I opened the copy, and immediately noticed that my LET function was replaced again. Even though I’ve tried quiting and restarting LO thinking that might clear the bug, any new copy I make of last night’s working version of my sheet has had the LET function replaced with the old formula as well upon fresh open!!
How is this possible??
Anyone, please help!
CT
