https://bugs.documentfoundation.org/show_bug.cgi?id=70882
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|NEW |RESOLVED
--- Comment #7 from Mike Kaganski <[email protected]> ---
This is not a bug.
As described in description of FormulaResultType attribute of SheetCell Service
Reference [1], its return value is CellContentType (see comment 6), which lacks
any ERROR value (and it's impossible to change the enumeration, because it's
breaking the API and ABI); to obtain a com::sun::star::sheet::FormulaResult
constant (having ERROR value), you need to use FormulaResultType2 attribute of
the same service (which likely was introduced for that very reason).
Or you can use getError() of XCell Interface [2], like described in [3].
[1]
https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sheet_1_1SheetCell.html#affda686bb18571c67c625c9adc1c85f9
[2]
https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCell.html#a79278ec2dc4228f41254eef7e33729f0
[3]
https://ask.libreoffice.org/en/question/83622/macro-how-to-get-a-cell-value-set-by-a-formula/
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
