https://bz.apache.org/ooo/show_bug.cgi?id=35718
--- Comment #12 from [email protected] --- (In reply to orcmid from comment #11) > (In reply to mrost from comment #10) > > The updated site for the excel behavior: > > > > https://support.office.com/en-us/article/SUBTOTAL-function-e27c301c-be9a- > > 458b-9d12-b9a2ce3c62af > > > > This issue is still affecting version 4.1.1 > > Thank you for confirming this. I assume you mean that both function > numbers, 1 to 11 and 101 to 111 are still not supported. These are now > specified for ODF 1.2 OpenFormula the same as for Excel. > > PS: The SUBTOTAL parameters specified for ODF 1.2 OpenFormula are not quite > the same as those employed for the Excel p1, p2, ..., however. This may be > an error in the OpenFormula specification and not in the Apache OpenOffice > implementation. Function numbers 1 thru 11 work fine. It's function numbers 101 thru 111 that are the problem. At this point I'd be fine if both sets of numbers did the same thing, just so it wouldn't always give the formula errors when I open excel spreadsheets with subtotals. -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
