https://bz.apache.org/ooo/show_bug.cgi?id=127292
mroe <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOT_AN_ISSUE --- Comment #3 from mroe <[email protected]> --- http://www.openoffice.org/api/docs/common/ref/com/sun/star/table/XCell.html#getType http://www.openoffice.org/api/docs/common/ref/com/sun/star/table/CellContentType.html If you get a cell object Cell, you can use something like Dim lLong As Long lLong = Cell.getType() Select Case lLong Case com.sun.star.table.CellContentType.VALUE MsgBox( "Numeric: " & Cell.getValue() ) Case com.sun.star.table.CellContentType.TEXT MsgBox( "String: " & Cell.getString() ) Case com.sun.star.table.CellContentType.FORMULA MsgBox( "Formula: " & Cell.getFormula() ) Case Else MsgBox( "Nothing." ) End Select Please discuss problems first at a user forum! -- You are receiving this mail because: You are the assignee for the issue.
