Apache OpenOffice (AOO) Bugzilla – Issue 85226
SUBTOTAL result not updated when undoing autofilter
Last modified: 2013-08-07 15:14:39 UTC
- create a sheet containing a range with autofilter and a SUBTOTAL function to the filtered range - modify filter -> SUBTOTAL result will be updated to calculate with visible cells only - undo the filter -> SUBTOTAL result will NOT be updated
Accepted.
Created attachment 55336 [details] A patch to the issue 85226
Even if the attached patch may fix the symptom, it does not fix the underlying cause. What this patch does is it recalculates the formula cell unconditionally, regardless whether it is flagged dirty or not. This is not desired. Furthermore, ScFormulaCell::InterpretTail() should never be called on its own, but only from the places within ScFormulaCell::Interpret() for which it was designed. Btw, please include the diff -p option when generating patches, which for C/C++ shows the method a change is in.
Created attachment 55488 [details] A new patch to issue 85226
Yes, it looks like that is really all that's needed (same as in ScDBDocFunc::Query).
taking the issue
I added the last patch to CWS "calc47".
Reassigning to QA for verification
verified in internal build cws_calc47
This issue is closed automatically and wasn't rechecked in a current version of OOo. The fixed issue should be integrated in OOo since more than half a year. If you think this issue isn't fixed in a current version (OOo 3.1), please reopen it and change the field 'Target Milestone' accordingly. If you want to download a current version of OOo => http://download.openoffice.org/index.html If you want to know more about the handling of fixed/verified issues => http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues
Sorry this issue was wrongly closed. This issue will be reopened automatically. And will be set after that back to fixed/verified.
Set to state 'fixed'.
Set back to state 'verified/fixed'. Again. Sorry for the mass of mails.
This issue is closed automatically. It should be fixed in a version with is available for longer than half a year (OOo 3.1). If you think this issue isn't fixed in the current version (OOo 3.2) please reopen it. But then please pay attention about the field 'target milestone'. The closure was approved by the Release Status Meeting at 22nd of February 2010 and it is based on the issue handling guideline for fixed/verified issues : http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues