https://bugs.documentfoundation.org/show_bug.cgi?id=166232
--- Comment #23 from Cameron <[email protected]> --- (In reply to Robert Großkopf from comment #21) Thanks Robert. I have changed: FieldA_string = ActivationInterface.getControl("FieldA").Text FieldB_string = ActivationInterface.getControl("FieldB").Text To: FieldA_string = ActivationInterface.getControl("FieldA").Value FieldB_string = ActivationInterface.getControl("FieldB").Value And kept CDec() here: MySheet.getCellByPosition(1, 1).Value = CDec(FieldA_string) / CDec(FieldB_string) ... And the macro and mathematical operation works well. However, it does not work if I take CDec() off. Cannot explain why but I've added the updated file & a GIF showing the error. Even though this "patch" works well on the test-file, I have applied the corrections to my own file and still cannot make it work properly. -- You are receiving this mail because: You are the assignee for the bug.
