https://bugs.documentfoundation.org/show_bug.cgi?id=166232
--- Comment #8 from Cameron <[email protected]> --- (In reply to Robert Großkopf from comment #6) > MySheet.getCellByPosition(1, 1).Value = Clng(FieldA_string) / > CLng(FieldB_string) > > Be careful: CLng is a long Integer without decimal places. > Did you really use the function in this way? > Use CDbl instead. Will work with local decimal separator. Sorry Robert, I meant to write the comment in the GIF description but I'm quite new at using this forum. Basically, as you can see on the updated media, I have tried your recommendation by changing CDec to CDbl (that was the only change made) and it prompts an error saying "Incorrect value or data type. Inconsistent data type. Any idea why? Did I have to add something in my script in order to make the CDbl-conversion work properly? -- You are receiving this mail because: You are the assignee for the bug.
