Improve display of number values

[philipfrench]

Users always complain about the handling of numbers.

Looking at left-aligned numbers like 1234567890.123 is painful, especially for users coming from Excel, ERP, CRM tools etc.

Please…. Field types Float, Integer and Money should have a “Format” option.

This could be a pick-list with these options:

• Accounting
• Scientific
• Custom1
• Custom2
• Custom3
• Custom4

In General settings, please provide us the ability to specify these settings.

In this way, administrators can provide field-level formatting. If no selection, the current behaviour should default.

When specified, the formatting should be used everywhere:

• Column mode: (Bom, Grid, Managed Items, …) + respect alignment option
• Item Details – in a matrix + respect alignment option
• Item details non-matrix – ignore alignment option

Computed fields should also support this option (if easiest, only apply when a formula returns a numeric value)

Derived fields should also support this (or could take the source field’s definition)

Roll-up fields should also support this, for numeric types.

Reports too (html only)

APV & API should ignore this formatting, for backwards compatibility of integrations.

I would want numeric columns to still sort numerically (not as alphabetically after rendering)

Please allow specify using sprintf type formatting (eg java.text.DecimalFormat is powerful, allows optional specification of negative numbers too) - or perhaps the postgres to_char() equivalent.

When specifying number formats at tenant level, this should not attempt any browser/profile specific rendering. Users should get the same everywhere on the tenant.

Only dates should remain rendered based on profile setting.

The above is specific, but is for "inspiration" only. Anything that improves on the display of number values would be awesome.

[Adrian.GrischottMLEX9]

In Europe we like to have the following format 1'000.