Created attachment 79043 [details] SUBTOTAL test spreedsheet I don't know if I may set this as bug or enhancement... =SUBTOTAL(3;A2) will returns always 1 even if A2 (non-emty) hidden by filtering. Workaround : Works with a pseudo-range =SUBTOTAL(3;A2:A2) Someone (Eike ?) fix the same kind of bug with MATCH. But it is perhaps more difficult...
GerardF: I'm not Calc expert but indeed A2, on the contrary of A2:A2, is not a range. So it seems normal that subtotal works as you expect on column C but not on column B. (tested with master sources updated today). Eike: should "A2" be considered as a range or converted to "A2:A2" as it?
(In reply to comment #1) > GerardF: I'm not Calc expert but indeed A2, on the contrary of A2:A2, is not > a range. So it seems normal that subtotal works as you expect on column C > but not on column B. Right. SUBTOTAL expect a range here but MATCH also and MATCH was changed to accept a scalar... That's also why I suggest to tag this as an Enhancement.
Taking. Simply a bug, not an enhancement.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3c2d0acc871057573fe9ab45b8161fce70190e80 resolved fdo#64384 check subtotal row filtered also for single reference The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f21815f9fe2609dd4ea152c65bb98b77b0a141f7&h=libreoffice-4-0 resolved fdo#64384 check subtotal row filtered also for single reference It will be available in LibreOffice 4.0.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2c84287f151f14a4a6204fef30546414cf3d27f8&h=libreoffice-3-6 resolved fdo#64384 check subtotal row filtered also for single reference It will be available in LibreOffice 3.6.7. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.