https://bugs.documentfoundation.org/show_bug.cgi?id=166232
--- Comment #11 from Mike Kaganski <[email protected]> --- (In reply to Cameron from comment #10) > Friend, your first comment was made obsolete for good reasons Please note that it was myself who marked it as such; you may check history. Please note also, that there is no need to mark your comments with version tags (this makes our use of tags difficult). > I was not expecting another helpless comment like this one from you. OK. Possibly you would also will not accept me fixing the bug? Please say so, and I will stop trying to move your bug forward. > Obviously I searched the internet and the Document Foundation's resources > for an answer and even posted on forums. If, despite my best efforts to find > an error in my work (which is sourced from the available theory), I still > get an error, then considering a bug in the LibreOffice app would not be > inappropriate. Who claimed that "considering a bug in the LibreOffice app is inappropriate"? > ... > > 4- Here is a simplified version of the script as requested: > > '//----------------------------------------------------// > Sub Macro > '--DECLARING VARIABLES > Dim MyDoc As Object > Dim MySheet As Object > Dim FieldA_string As String > Dim FieldB_string As String > MyDoc = ThisComponent > MySheet = MyDoc.Sheets.getByName("SHEET") > > '--RETRIEVING DATA FROM DIALOGBOX. "FieldA" & "FieldB" ARE THE NAMES OF > TWO > TEXTFIELDS IN MY DIALOGBOX. > FieldA_string = ActivationInterface.getControl("FieldA").Text > FieldB_string = ActivationInterface.getControl("FieldB").Text > > '--CONVERSION STEP. CONVERTING STRING VALUE FROM DIALOGBOX INTO DECIMAL > VALUE ONTO SHEET, COMPATIBLE WITH DECIMAL SEPARATOR. > MySheet.getCellByPosition(1, 1).Value = CDec(FieldA_string) / > CDec(FieldB_string) > > End Sub > '//----------------------------------------------------// Please. This macro relies on some specific spreadsheet having sheet named "SHEET"; it uses something called "ActivationInterface". Could you please see if your code works simply starting LO in safe mode; from Start Center open Tools->Macros->Edit Macros; paste your code there; and running it - without anything opened first. And indeed, please ignore me, if you are uninterested in me actually reproducing and maybe fixing this. Thanks. -- You are receiving this mail because: You are the assignee for the bug.
