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 unsubsc

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

Hi, Le 19/06/22 à 10:41, Czesław Wolański a écrit : 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 ask: Does it also happen with Excel 2003? Yes, in Excel 2003, both CInt, CLng, C

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

Hi Czesław, On 6/23/22 11:18 AM, Czesław Wolański wrote: 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-un

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, e-mai

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 ask:

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

Hi Carl, Le 18/06/22 à 17:49, Carl Marcum a écrit : I see that VBA does handle this now. I don't know if that was always the case. When tested on a VBA version Excel 2003,  CLng("+1") returns 1 Best regards, Lucien Hi Czesław, On 6/16/22 6:58 AM, Czesław Wolański wrote: Hi, The probl

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

; (stray ";" below) > > -Original Message- > From: dennis.hamil...@acm.org > Sent: Saturday, June 18, 2022 10:37 > To: 'qa@openoffice.apache.org' > Subject: RE: Value returned by CInt("+1") > > Excel has it so there has to be a solution i

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

Sorry, it is +#,##0.00;-#,##0.00;0.00 (stray ";" below) -Original Message- From: dennis.hamil...@acm.org Sent: Saturday, June 18, 2022 10:37 To: 'qa@openoffice.apache.org' Subject: RE: Value returned by CInt("+1") Excel has it so there has to be a sol

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

#0.00;; 0.00 -Original Message- From: Carl Marcum Sent: Saturday, June 18, 2022 08:49 To: qa@openoffice.apache.org Subject: Re: Value returned by CInt("+1") [orcmid] [ ... ] If I enter +1 into a cell my default number format changes it to a 1. I haven't found any number

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

Hi Czesław, On 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&sid=0481325a63f94adf45c49ba4175701d7#p525249 In version 4.1.12, CLng("+1") returns 0

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

Hi Carl, I never made a build on my own. As there are no builds for Windows available, yesterday I tested the issue on Matthias' builds: 4.1.13 and 4.2. Both functions return 0 in both builds. Regards, Czesław Le ven. 17 juin 2022 à 12:43, Carl Marcum a écrit : > Hi Czesław, > > On 6/16/22 6:5

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

Hi Czesław, On 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&sid=0481325a63f94adf45c49ba4175701d7#p525249 In version 4.1.12, CLng("+1") returns 0

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

Hi Czesław, Am 16.06.22 um 12:58 schrieb Czesław Wolański: > 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&sid=0481325a63f94adf45c49ba4175701d7#p525249 > > In version 4.1.12, CLng("+