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 in description of the above functions;
except for CDec()
All in all, I agree that both the bug and the enhancement need to be
considered.
Best regards,
Czesław
Le sam. 18 juin 2022 à 19:39, <dennis.hamil...@acm.org> a écrit :
> Sorry, it is
>
> +#,##0.00;-#,##0.00;0.00
>
> (stray ";" below)
>
> -----Original Message-----
> From: dennis.hamil...@acm.org <dennis.hamil...@acm.org>
> Sent: Saturday, June 18, 2022 10:37
> To: 'qa@openoffice.apache.org' <qa@openoffice.apache.org>
> Subject: RE: Value returned by CInt("+1")
>
> Excel has it so there has to be a solution in AOO Calc. And indeed there
> is.
>
> It is in the built-in Help under Number Format Codes. Here is a
> conventional
> sign everything and show 0's format code for currency values (without any
> $)
> that I use in some investment tracking.
>
> +#,##0.00;-#,##0.00;; 0.00
>
> -----Original Message-----
> From: Carl Marcum <cmar...@apache.org>
> 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 format options where positive values have a
> leading
> + but I haven't checked them all.
>
> [orcmid] [ ... ]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: qa-h...@openoffice.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: qa-h...@openoffice.apache.org
>
>
