Ask Your Question

Calc: formula doesn't recalculate when filter changes [closed]

asked 2017-10-19 12:27:25 +0200

TKYUP gravatar image

updated 2020-07-20 11:22:56 +0200

Alex Kemp gravatar image

Formula 1 (J2):

=SUBTOTAL(109, I6:I3001)

Formula 2 (J3):



When I update the filter in Calc to filter the rows that are being subtotaled by J2... J2 updates as expected, however J3 does not.

  • If I select cell J3, put cursor in formula bar and hit enter, the formula does NOT recalculate.
  • If I select cell J3, put cursor in formula bar, make an edit and then change it back and hit enter, the formula does recalculate.
  • If I close and re-open the file, the formula also doesn't update to the correct calculation based on the current filter.

Things I've tried:

  • Saving as xls, quitting/reopening,
  • saving as odf, quitting/reopening,
  • saving as xlsx, quitting/reopening.

None of these seem to resolve the issue...had a hunch it was related to file format...but if so I can't figure out the magic incantation to fix it.


image description

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-20 11:23:11.937444

1 Answer

Sort by » oldest newest most voted

answered 2017-10-19 12:34:28 +0200

Please file that as a bug report. Also possibly related is bug 111428.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-10-19 12:27:25 +0200

Seen: 208 times

Last updated: Oct 19 '17