Subject: [OASIS Issue Tracker] Commented: (OFFICE-2329) Consistentdefinition of "empty cell"
[ http://tools.oasis-open.org/issues/browse/OFFICE-2329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17579#action_17579 ] Eike Rathke commented on OFFICE-2329: ------------------------------------- I agree we should not mention COUNTBLANK in the definition of empty cell. "If the outermost expression is a reference to an empty cell, it shall be converted to the number 0." does not hold true. If cell A1 is empty, the expression =A1 in A2 has an undefined return type until the result is used. For display purposes it is converted to the number 0. A comparison =A2="" may still yield true, at least in OOo, Excel and Gnumeric do not have that behavior and already force the result of =A1 to 0. The return type of a function of course depends on the function, or I also misunderstood that question. > Consistent definition of "empty cell" > ------------------------------------- > > Key: OFFICE-2329 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-2329 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Bug > Components: OpenFormula > Affects Versions: ODF 1.2 Part 2 CD 1 > Reporter: Patrick Durusau > Priority: Blocker > > In the reference paragraph (final paragraph of 3.1 in the current public version we say: > " An empty cell is neither zero nor the empty string, and an empty cell can be distinguished from cells containing values (including zero and the empty string) by some functions (such as ISBLANK and COUNTBLANK). An empty cell is not the same as an Error, in particular, it is distinguishable from the Error #N/A (not available). As discussed below, in many scalar contexts a reference to an empty cell is converted into 0 or the empty string, and in most sequences empty cells are automatically omitted. If the outermost expression is a reference to an empty cell, it shall be converted to the number 0." > But, if we look at COUNTBLANK we find: > " 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." > And if we look at ISBLANK we find: > "If X is a reference to a cell, examine the cell; if it is blank (has no value), return TRUE, but if it has a value, return FALSE. A cell with the empty string is not considered blank." > We need a consistent definition of empty cell that can be defined once. Across all functions that may encounter an empty cell. > It isn't clear why there is a special rule for the "outermost" expression, assuming that's meaningful, in the last sentence. > Question: Do we define for scalar functions whether they return 0 or the empty string? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira