https://bugs.documentfoundation.org/show_bug.cgi?id=170784
--- Comment #6 from Andreas Säger <[email protected]> --- @ady Have a close look at the formula Sheet5.A2: =SUBTOTAL(9;$Sheet1.$A$1:$Sheet4.$A$19) Clear Sheet1.A17:A19 and re-enter the formula on Sheet5.A2. It changes to =SUBTOTAL(9;$Sheet1.$A$1:$Sheet4.$A$16) The little video demonstrates the issue on my system in safe mode. Version: 26.2.0.2 (X86_64) Build ID: 750d5fef117734aeeb00d37a069d6c814e9eb8ce CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: x11 Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded I'm in office right now and can reproduce the same issu with LO 26.2 on Windows. -- You are receiving this mail because: You are the assignee for the bug.
