Do you actually use the TYPE function? If so, what do you use it for? Do you use it directly in the spreadsheet or in a macro?
Background to the question: The ODF TC has received a public comment on the TYPE function, stating that its specification is insufficient. I am working on this issue in the TC.
There is no function TYPE() in LibO Basic.
I never tried to use the Calc function TYPE() via a FunctionAccess object. I can try it if you are interested. Shall I?
Concerning the usage in spredsheets: See attachment.
disask_133056_ODF.ods (18.6 KB)
Possibly related
tdf#137667,
LibreOffice: SheetCell Service Reference.
I use the TYPE function in Excel and Calc formulas. My comments are in the attached file.
TypeFunction.ods (8.4 KB)
No, that would give only a hypothetical use.
My question does not refer to hypothetical use, but to actual use. Result 8 for a cell with formula is wrong behavior of LibreOffice, see tdf#73085. Further problems are described in tdf#171183 and tdf#171160. In addition the result in LibreOffice is different from Excel for a cell range as parameter. Because of all these problems, my question is whether this function is actually used at all.
I think, it is not related.
Actually? For what purpose? That is, what do you do with the results? Why do you use TYPE and not the ISFOO functions or the CELL function? Do cases where Excel and Calc are different, or where LibreOffice do not confirm to the standard, not occur in your use? Or how you handle such cases?
How else can we find out the type of a cell value (number, text, logical (Excel only), or error)?
The TYPE function is the most convenient way.
In Calc macros, we have to analyze getError(), CellContentType and FormulaResultType2.
We are aware of and take these differences into account when creating documents intended for both Calc and Excel (usually .xlsx, .xltx).