Created attachment 139973 [details] Sheet showing the problem Version: 5.4.4.2 (x64) Build ID: 2524958677847fb3bb44820e40380acbe820f960 CPU threads: 8; OS: Windows 6.1; UI render: default; Locale: en-GB (en_GB); Calc: group Clicking on cell A2 in the attached shows, in the status bar Count: 2; CountA: 2 Even worse, highlighting cells A1 up to and including A47 shows, in the status bar Count: 56; CountA: 57 And just as bad, highlighting cells B1 through B6 shows, in the status bar Average: 3.28571428571429; Count: 7; CountA: 8; Sum: 23 With the latter four in the status-bar, just scrolling through row 2 will show all kinds of "interesting" values that have nothing to do with the actual values of the cells! Note that I have not tried to reduce the sheet to something minimalistic.
This is awkward, the results mentioned earlier disappeared after reloading the sheet. FWIW, the sheet was originally loaded after an other sheet that was updated with values from the attached one. I will try to recreate what I've done using backups.
I do NOT reproduce with: - Version: 6.0.1.1 Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6 Threads CPU : 8; OS : Linux 4.13; UI Render : par défaut; VCL: gtk2; Locale : fr-FR (fr_FR.UTF-8); Calc: group - Version: 5.4.5.1 Build ID: 79c9829dd5d8054ec39a82dc51cd9eff340dbee8 Threads CPU : 8; OS : Linux 4.13; UI Render : par défaut; VCL : gtk2; Locale : fr-FR (fr_FR.UTF-8); Calc: group - Version: 5.3.7.2 Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059 Threads CPU : 8; Version de l'OS :Linux 4.13; UI Render : par défaut; VCL : gtk2; Moteur de mise en page : nouveau; Locale : fr-FR (fr_FR.UTF-8); Calc: group(In reply to robert from comment #0) > Version: 5.4.4.2 (x64) You are urgently recommended to upgrade to Version 5.4.5 due to security issue: https://github.com/jollheef/libreoffice-remote-arbitrary-file-disclosure
can not reproduce Version: 5.4.6.0.0+ Build ID: 01f19aba638860db54ca9a60e30ce6f21ee0ea5a CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 5.3.1.2 Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2 CPU Threads: 8; OS Version: Linux 4.14; UI Render: default; VCL: kde4; Layout Engine: new; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 6.1.0.0.alpha0+ Build ID: bf2e3dc2a9b3801366c83b0036ca1778198fa8ae CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group
I've spent the last hours trying to recreate the problem by restoring both sheets from backups. Sadly it didn't result in the same problem, possibly because this morning I had to actually close LO because it hung, after which I cancelled the recovery, which still left a .lock file (deleted manually). Trying to repeat the steps I made this morning, as much as I could remember, did not result in the same problem, but it most certainly was present. If this problem occurs again, I will actually take a video of the screen, and either upload that here, or to my Google drive.
If you recreate with steps, please set back to Unconfirmed.