https://bz.apache.org/ooo/show_bug.cgi?id=118236
--- Comment #13 from Czesław Wolański <[email protected]> --- (In reply to damjan from comment #12) > > So what do we do now? Leave it as is, or make it return 16? It looks like - toutes proportions gardées - a million-dollar question... Reading all the documentation [1] has left me in a state of legitimate / reasoned confusion. If I understand correctly the rationale behind the entries in ODF spec v1.3: 6.3.3 Implied intersections "If a single cell is referenced; return it; otherwise, return an Error." 6.13.33 TYPE "This function does _not_ propagate Error values." and in AOO Help, the TYPE() function: "If an error occurs, the function returns a logical or numerical value." I would opt for making the TYPE() function return 16 (value 16 = error value), "unless the context otherwise requires". ;‑) SIDE NOTE: Err:502 in cells: I2 and I3 (attached .ods file). LO, Google Sheets and Excel 2010 return 1. ------------------------ [1] - Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format - "Documentation/How Tos/Using Arrays" https://wiki.openoffice.org/wiki/Documentation/How_Tos/Using_Arrays#Functions_not_expecting_array_parameters - "Documentation/How Tos/Calc: TYPE function" https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_TYPE_function - AOO Calc Help topic "Array Functions", section "Using Array Formulas in OpenOffice Calc" topic "Information Functions", section "TYPE" - their counterparts in the LO 7.6 Help Calc - LO 7.6 Calc Guide (p. 293) the "Implicit intersection of array formulas" section -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue.
