https://bugs.freedesktop.org/show_bug.cgi?id=70882
Priority: medium
Bug ID: 70882
Assignee: [email protected]
Summary: FormulaResultType return VALUE for cells with formula
result #DIV/0! or #NAME?
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: BASIC
Product: LibreOffice
Created attachment 88141
--> https://bugs.freedesktop.org/attachment.cgi?id=88141&action=edit
spreadsheet with mentioned macro and formulas
Formula in A1 "=0/0" -> result #DIV/0!
Formula in B1 "=nonexistingsheet!A0" -> result #NAME?
Formula in C1 "=sums(A2:A3)" -> result #NAME?
Basic macro:
Sub Main
sheet = thiscomponent.sheets.getbyindex(0)
msgbox sheet.getcellbyposition(0,0).formularesulttype
msgbox sheet.getcellbyposition(1,0).formularesulttype
msgbox sheet.getcellbyposition(2,0).formularesulttype
End Sub
All mesageboxes return 1 (VALUE) instead of 4 (ERROR)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
