| Summary: | COUNTBLANK doesn't count formulas | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | James <freedesktop> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | major | CC: | jeffdchang, yfjiang |
| Priority: | medium | ||
| Version: | 3.4.2 release | ||
| Hardware: | Other | ||
| OS: | macOS (All) | ||
| URL: | http://office.microsoft.com/en-us/excel-help/countblank-HP005209028.aspx | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Spreadsheet showing COUNTBLANK bug | ||
Confirmed for LibreOffice 3.4 340m1(Build:103) for OpenSuse Linux. For LibreOffice/OpenOffice the following url is more important: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_COUNTBLANK_function "A cell that contains blank text such as spaces, or even text with zero length such as returned by ="", is not considered empty, even though it may appear empty." Spurious incompatibility with Excel that breaks spreadsheets is surely a bad thing. Two points: -We are not excel -I Don't think we should change this behaviour because this is documented and old documetns may rely on this. Additionally the odf 1.2 standard mentions:
Counts the number of blank cells in the Reference provided. A cell is blank if the cell is empty for purposes of COUNTBLANK. If ISBLANK(R) is true, then it is blank. A cell with numeric value zero ('0') is not blank. It is implementation-defined whether or not a cell returning the empty string ("") is considered blank; because of this, there is a (potential) subtle difference between COUNTBLANK and ISBLANK.
I think that with this information it is clear that it is not a bug.
|
Created attachment 50217 [details] Spreadsheet showing COUNTBLANK bug According to the above URL from Microsoft, COUNTBLANK (unlike its sister function ISBLANK) counts as blank cells containing functions or formulas that return the null string (""). To see this bug in action, open the attached spreadsheet. In cells A1:A2 (R1C1:R2C1), you can see COUNTBLANK returning 0 when it should return 1.