Re: Duplicate bugs: shall we follow strict chronological order?

Hi Arrigo, Marcus, @Arrigo Thanks for bringing this up. @Marcus Thank you for this extensive explanation. It will surely help me a lot in my bug hunting tusks - ykwim. ;‑) "Exception that proves the rule". Regards, Czesław чт, 11 февр. 2021 г. в 09:46, Marcus : > Am 11.02.21 um 09:03 schrieb

Re: isnumeric function

HI all, Just a poorly educated guess: In the source code, isNumeric() http://openoffice-vm1-he-de.apache.org/xref/trunk/main/basic/source/runtime/methods.cxx?r=710acb7f#2472 leads to ImpScan() http://openoffice-vm1-he-de.apache.org/xref/trunk/main/basic/source/sbx/sbxscan.cxx?r=323c3501#70

Re: Value returned by CInt("+1")

Hi all, Bugzilla issue 128518 - Basic - Converting "+1" to a number https://bz.apache.org/ooo/show_bug.cgi?id=128518 Regards, Czesław - To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org For additional commands,

Re: Value returned by CInt("+1")

Hi, Le lun. 27 juin 2022 à 09:18, Lucien Mathay a écrit : > > Yes, in Excel 2003, both CInt, CLng, CDec, CSng and CDbl > return 1 if the argument is "+1" > Thanks for checking it out, Lucien. Best regards, Czesław - To

Value returned by CInt("+1")

Hi, The problem was reported yesterday on the English forum: topic "CINT("+1") returns 0". https://forum.openoffice.org/en/forum/viewtopic.php?p=525249=0481325a63f94adf45c49ba4175701d7#p525249 In version 4.1.12, CLng("+1") returns 0 too. I haven't found any relevant report in Bugzilla. Do you

Re: Value returned by CInt("+1")

Hi Carl, all Thank you for your insight. A few observations on my part: (1) isNumeric("+1") returns False (2) for "+1" argument: CInt() and CLng() produce 0, CDec() gives 1 whereas CSng() and CDbl() - an error "Inadmissible value or data type. Data type mismatch" (3) the help text you quoted is

Re: Value returned by CInt("+1")

6/16/22 6:58 AM, Czesław Wolański wrote: > > Hi, > > > > The problem was reported yesterday on the English forum: topic > "CINT("+1") > > returns 0". > > > https://forum.openoffice.org/en/forum/viewtopic.php?p=525249=0481325a63f94adf45c49ba41

Re: Value returned by CInt("+1")

Hi Lucien, On 2022/06/18 20:34:56 Lucien Mathay wrote: > > When tested on a VBA version Excel 2003,  CLng("+1") returns 1 > In LibreOffice 7.2.7 each of the functions: CInt, CLng, CDec, CSng and CDbl returns 1 if the argument is "+1". Same outcome on a VBA version Excel 2010. If I may

Re: Bug report : comment after "if ... then ... else"

Hi, Regina Henschel schrieb am 06.06.2022 um 13:33 > >The if-statement misses endif. > Right. As I am slightly out of practice with Basic, my question might appear silly. The wiki topic "Branching" provides an example of a single-line If-Then-Else statement.