https://bugs.documentfoundation.org/show_bug.cgi?id=168013
--- Comment #6 from Alexander Borouhin <[email protected]> --- Struggling with this bug too (v. 26.2.3.2) There is also one more side effect, probably from the same cause: if I create a named range "TestRange", set it to "A1:A999" and then add new data below existing rows to column A - the value of "=SUBTOTAL(9;TestRange)" is not updated. This is even worse than entering "A1:A999" in SUBTOTAL function directly, as there are no visible changes and nothing signals the user that something has gone wrong. Currently the only workaround I've found is using "=AGGREGATE(9;5;A1:A999)" instead of "=SUM(9;A1:A999)", which thankfully works. -- You are receiving this mail because: You are the assignee for the bug.
