Ask Your Question

Calc recalc broken when autofilter active

asked 2016-11-25 21:51:42 +0200

pmfrench gravatar image

I'm using Calc to clean up a listing. I have autofilter turned on to select a subset of records, then enter a formula in an adjacent column outside the filtered list to help isolate problems in the list. I've found that the results from the formula don't auto update when I edit items in the filtered list in ways that should cause the results to update. Pressing F9 to force an update has no effect unless the cell cursor is on the cell containing the formula.

A simple example:

In cell A1 enter "Letters" In cell A2 enter "ab" In cell A3 enter "abc" In cell A4 enter "ab" In cell A5 enter "abc"

With the cursor in one of those cells, select DATA/AUTOFILTER from the menus. From the drop-down arrow in cell A1, deselect ALL and tick the box in front of "abc", then click the OK button. The list should now show only the "abc" entries.

In cell C3, enter the formula =LEN(A3) Copy the forumla down to the row below which should be row 5. The results for both formulas should be "3"

Now if you edit the contents of A3 or A5 to change the length of the string, the results of the formulas in column C should auto update, but do not.

Using version on Win 10 64bit installation. I tried it with version 5.2.x.x on a different machine and got similar, but not identical results. I believe that on that version the first edit to entries in column A did result in an updated result in column C, but subsequent edits in the filtered list in column A did not.

Other spreadsheets (Excel, SoftMaker's PlanMaker) do not have this issue.

edit retag flag offensive close merge delete


I cannot confirm this with V5.2.3.3 (portable, 32 bit) on Win 10. Reproducing your steps everything works as expected. With 'AutoCalculate' on the string lengths are updated immediarely.

Lupp gravatar imageLupp ( 2016-11-25 22:28:25 +0200 )edit

Using version

Please upgrade. Really.

6.2.8 and 6.3.3 are available.

erAck gravatar imageerAck ( 2019-11-21 14:34:50 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-11-20 19:01:53 +0200

newbie-02 gravatar image

updated 2019-11-20 23:30:40 +0200

calc defintely has a problem with autocalculate esp. when the sheet contains 'shared formulas' ... :-(

it's under work and nearly solved,

'F9' doesn't help in this situation, it's easily misunderstood, 'F9' only! recalculates intentionally 'unfixed' values like date, time or 'random', and cells depending on them?

to recalculate the whole sheet use 'Ctrl-Shift-F9', sometimes referred to as 'hard-recalc' or 'forced-recalc', that is! save reg. autocalc-fails since some versions.

hope problem will be finally fixed soon ... 6.4. is very good, as long as you work without 'threaded' or 'CL' mode, but has other shortcomings thus i cannot use it, does! do autocalc-fails, plenty when 'CL', many when 'threaded', very few when 'unthreaded.



edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-25 21:51:42 +0200

Seen: 112 times

Last updated: Nov 20 '19