https://bugs.documentfoundation.org/show_bug.cgi?id=166232
--- Comment #27 from Cameron <[email protected]> --- (In reply to Robert Großkopf from comment #26) Yes, it works. Thanks. Cannot make it work on my own file (but even adding a MsgBox does not work on my own file either so it may have been corrupted). I could upload a copy of my own file but everything is written in French, would that be an issue? On another note: - Regarding the use of CDec, you suggested to use the "Double" variable type as the "Decimal" does not exist (even though it is already documented as a variable type [1]). Because I was not very familiar with the "Double" variable, I tried understanding the difference with the "Decimal" variable. The "Double" variable is presented as the appropriate variable for simple & quick calculations: "Further, double is concerned with is performance, while decimal is concerned with is precision. When using double, you are accepting a known trade-off: you won't be super precise in your calculations, but you will get an acceptable answer quickly. Whereas with decimal, precision is built into its type:" Would it be appropriate to add the "Decimal" variable type as an enhancement for future LibreOffice development? - Also regarding conversion functions like CDec: the available documentation does not include conditions and explanations on their use [3]. For instance, you explained that "CDec or CDbl don't know anything about '€'." and that does not feature in the documentation. Also as an enhancement suggestion (regarding the official website mostly), having additional explanations on their use would be useful to everyone. [1] https://help.libreoffice.org/latest/en-US/text/sbasic/shared/01020100.html?DbPAR=BASIC [2] https://exceptionnotfound.net/decimal-vs-double-and-other-tips-about-number-types-in-net/ [3] https://help.libreoffice.org/latest/en-US/text/sbasic/shared/03100060.html?DbPAR=BASIC -- You are receiving this mail because: You are the assignee for the bug.
