Steps to Reproduce: 1. Open attachment 178640 [details] in bug 147744. Observe in "Data > Calculate" the option "Auto Calculate" is enabled. If not, enable it manually. 2. Follow the steps in bug 147744 to make Calc crash. 3. Click OK and finish the recovery process when you are asked whether to recover the document. 4. Now observe in "Data > Calculate", that the option "Auto Calculate" is disabled. Expected Result: After recovery Calc Auto Calculate should remain enabled. Current Result: After recovery Calc Auto Calculate is disabled. Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 85a5b1d92ebb4d66c9ed683df99dc8b37c0f02a5 CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Build Platform: Fedora34@X64, Branch:master, bibisect-linux-64-7.4-CN Calc: threaded Fedora 34.
Also reproduced in: Version: 7.3.2.0.0+ / LibreOffice Community Build ID: 789fbf732ad6db002fd83b307385940c392cc457 CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Calc: threaded
I don't think is is bibisectable because I do not find other ways to make it crash. I do not reproduce this bug if I make Calc to crash by killing the soffice process.
On pc Debian x86-64 with master sources updated today, I did things slightly differently. 1) Retrieved the ods file 2) Opened it and saw that "Auto Calculate" is disabled 3) Enabled it, saved 4) Reproduced the crash 5) Waited the auto recovery "Auto Calculate" was still enabled. I think it's quite expected LO doesn't retain the change on "Auto Calculate" if there's no saving step before the crash. IMHO, NOTABUG.
Could you try with sth a little different: 1) Retrieved the ods file, renamed it as crash-original.ods. 2) Opened it and saw that "Auto Calculate" is disabled. 3) Enabled it, saved a copy as crash-new.ods, close. 4) Reopen the crash-new.ods. Observe that the "Auto Calculate" is enabled. 5) Reproduced the crash 6) Waited the auto recovery "Auto Calculate" is disabled. These two bugs may be highly related. It is possible that the crash may be caused by the auto calculate staff. The ods file I uploaded may be the one after crash which then had auto calculate disabled.
(In reply to Kevin Suo from comment #4) > Could you try with sth a little different: > > 1) Retrieved the ods file, renamed it as crash-original.ods. > 2) Opened it and saw that "Auto Calculate" is disabled. > 3) Enabled it, saved a copy as crash-new.ods, close. > 4) Reopen the crash-new.ods. Observe that the "Auto Calculate" is enabled. > 5) Reproduced the crash > 6) Waited the auto recovery > "Auto Calculate" is disabled. > > These two bugs may be highly related. It is possible that the crash may be > caused by the auto calculate staff. The ods file I uploaded may be the one > after crash which then had auto calculate disabled. Idem, crash-new.ods has "Auto Calculate" enabled. Just a remark, when there's the autorecovery, LO doesn't open directly the file, it shows first the LO interface without any module opened (I don't remember the name), then I select the thumbnail which corresponds to the file and it opens.
For me, after recovery lo opens the (recovered) crash-new.ods. That is where I noticed the auto calculate disabled.
I could reproduce it with the current latest commit in the 7.4 Linux bibisect repo: c97a3592c78ce276a353f95ce68c70a8a39174a0. AutoCalculate was off by default, so I enabled it, saved the file and reopened it, and indeed it got turned off after recovery. LO reopened the file after recovery for me as well. I know of the following way to get a crash in Calc: bug 111187. It's unrelated to the file, but the steps can be performed with this file open. In this case, AutoCalculate was on after recovery. I'm wondering whether this could be an intended protection mechanism to avoid a crash-loop.
(In reply to Aron Budea from comment #7) > AutoCalculate was off by default, so I enabled it, saved the file and > reopened it [*], and indeed it got turned off after recovery. LO reopened the > file after recovery for me as well. [*] I didn't mention, but of course I performed the crashing steps here.
Not reproduced in: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Same in 7.4.7.2. Document opens after recovery, and autoCalculate is still on. I used bug 154072 to crash Calc. Kevin, do you still reproduce in 7.6.2.1 and with a new profile?