https://bugs.documentfoundation.org/show_bug.cgi?id=143211
--- Comment #5 from Rafael Lima <rafael.palma.l...@gmail.com> ---
It makes sense... LO does not evaluate the formula before validating cell
content.
My only concern about using "CellFormula" instead of "CellValue" is that it
would cause the same confusion in users. Maybe they'll start thinking LO should
evaluate formulas before validating the cell value.
How about we use the proposed code, but keeping CellValue to avoid confusion?
Hence, the new example would be:
Function ExampleValidity(CellValue as String, TableCell as String) as Boolean
Dim msg as string
Dim iAnswer as integer
Dim MB_FLAGS as integer
msg = "Invalid value: " & "'" & CellFormula & "'"
msg = msg & " in table: " & "'" & TableCell & "'"
msg = msg & Chr(10) & "Accept anyway?"
MB_FLAGS = MB_YESNO + MB_ICONEXCLAMATION + MB_DEFBUTTON2
iAnswer = MsgBox (msg , MB_FLAGS, "Error message")
ExampleValidity = (iAnswer = IDYES)
End Function
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs