Hi Ferdinando, Just tested v16.5 (on Mac, but that should not differ from Windows). IMHO there are no changes in number formatting between v16 and v17. Created a 1 column array based list box on a form. Populated the array with some random real numbers. The column is set to variable type 'Numeric' and number format being: ###,##0.###;-###,##0.###;
This means, positive non zero numbers format up to 6 digits to the left of the decimal point and 3 to the right. Negative non zero numbers have minus sign followed by the same format as positive numbers and zero is displayed as blank. In belgium we use period as thousands separator and comma as decimal point. Beware, 4D internally uses (US notation) period for decimal and comma for thousands. But at runtime uses the OS number format setting. There is a compatibility setting for upgraded databases (created before v11)* Eg: 1234567/1000 will display as 1.234,567 on my OS, but I have to set ###,##0.### as number format in the property pane. If you want to see three decimal digits for each number, you must use ###,##0.000 as number format. This will display 1 as 1,000 or 12/10 as 1,200 If you have larger numbers, add extra # on the left side, eg ###,###,##0.000 HTH Koen *4D Design Reference>Database Settings>Compatibility page: "Use period and comma as placeholders in numeric formats": starting with v11, 4D uses regional system parameters for numeric display formats (see “Number formats” in Display formats). 4D automatically replaces the “,” and “.” characters in numeric display formats by, respectively, the thousand separator and the decimal separator defined in the operating system. The period and comma are thus considered as placeholder characters, following the example of 0 or #. In previous versions of 4D, numeric display formats do not take the regional parameters of the system into account. For example, the “###,##0.00” format is a valid format for an American system. However, when it is applied to a numeric value displayed on a French or Swiss system, the result is incorrect. In converted database, for the sake of compatibility, this new mechanism is not activated. To take advantage of it, you must check this option. > Op 5 aug. 2019, om 23:24 heeft stardata.info via 4D_Tech > <[email protected]> het volgende geschreven: > > I need to display a number in an array real displayed in a list box. > In column settings of the list box, if I do not insert anything in Display > number format, the decimal numbers are correctly displayed, but I have 0 > instead of blank. -------------------- Compass bvba Koen Van Hooreweghe Kloosterstraat 65 9910 Aalter Belgium tel +32 495 511.653 ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
