Hi Olivier, On Thursday, 2025-04-10 10:08:10 -0300, Olivier Hallot wrote:
> For modules we have > "Number format codes can consist of up to four sections separated by a > semicolon (;)." > > https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html > > But for BASIC we have for function Format() > > "A format code can be divided into three sections that are separated by > semicolons. The first part defines the format for positive values, the > second part for negative values, and the third part for zero. If you only > specify one format code, it applies to all numbers." > > https://help.libreoffice.org/latest/en-US/text/sbasic/shared/03120301.html > > Both <modules> and BASIC share much common formats so is there a reason for > the difference (to be documented) or this difference is a mistake? It depends ... if the format code is not (does not contain) one of the "Predefined format" strings (or maybe other formats specifically handled) then the general number formatter is used, for which there is no difference regarding the number of sub-format sections. It is four possible sub-formats. For "Predefined format" placeholders it is three possible sub-format sections. For implementation see basic/source/sbx/sbxscan.cxx SbxValue::Format() and (via BasicFormatNum()) basic/source/sbx/sbxform.cxx SbxBasicFormater::BasicFormat() Eike -- GPG key 0x6A6CD5B765632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A
signature.asc
Description: PGP signature
