Apache OpenOffice (AOO) Bugzilla – Issue 98329
inappropriate semicolon in SUBTOTAL() help for Calc
Last modified: 2009-02-25 10:29:14 UTC
If you look in the online help for the SUBTOTAL() function in Calc, the example is wrong. There should be a comma in the formula instead of a semicolon. If you use the example as-is you get a 508 error code in your spreadsheet. The help reads as follows: Example You have a table in the cell range A1:B5 containing cities in column A and accompanying figures in column B. You have used an AutoFilter so that you only see rows containing the city Hamburg. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. In this case the correct formula would be: =SUBTOTAL(9;B2:B5) The formula as given won't work but =SUBTOTAL(9, B2:B5) does work.
This appears to be a global issue in Calc formulas. All examples in the online help use semicolons instead of commas, and all semicolons in formulas yield vague error codes when utilized. Therefore everyone should just use commas instead. This is then not a bug but an issue for the whole Calc formula-handling routine:-(
Please tell us in which version on which platform by which distribution you found this.
This seems to be an Ubuntu bug --> closed