To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97407
User dr changed the following:
What |Old value |New value
================================================================================
Assigned to|dr |jsc
--------------------------------------------------------------------------------
Target milestone|OOo 3.1 |OOo 3.2
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Wed Feb 4 09:22:36 +0000
2009 -------
DR->JSC: What is the correct solution for this problem?
IDL documentation of property com.sun.star.sheet.SheetCell.FormulaResultType
(http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/SheetCell.html#FormulaResultType)
states "long" as property data type which should be a constant of
com.sun.star.sheet.FormulaResult
(http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/FormulaResult.html),
but the implementation in OOo Calc returns a value of the enum
com.sun.star.table.CellContentType
(http://api.openoffice.org/docs/common/ref/com/sun/star/table/CellContentType.html),
either TEXT or VALUE.
The only place where FormulaResultType is correctly used, is the method
com.sun.star.sheet.XCellRangesQuery.queryFormulaCells
(http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangesQuery.html#queryFormulaCells).
There are already Basic macros out there that rely on the enum return type. The
disadvantage: it is not possible to detect that a formula returns an error
result.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
