[OFBIZ-7532] Form Display Field improvement to manage multiple number format

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Implemented
• Affects Version/s: Trunk
• Component/s: ALL COMPONENTS
• Flags: Patch
• Assignee: Nicolas Malin
• Reporter: Charles STELTZLEN
• Created: 21/Jun/16 15:07
• Updated: 02/Nov/21 10:32
• Resolved: 09/Aug/19 20:38

Description

On display field used in forms, there is a "type" "accounting-number" which is used to format number like property configuration : #,##0.0000;(#,##0.0000).

This JIRA propose to extend this idea by using a "type" "number" and an additional attribute called "format-pattern". This field will be used by form renderer to get the good property. It use FlexibleString to manage variable in this field and so allow to have different format for the same column according to some conditions.

example: <field name="amount"><display type="number" format-pattern="accounting"/></field>

The "format-pattern" will be stored in arithmetic.properties.

example:

1. the default number format
   default.number.format = ##0.00
   accounting.number.format = #,##0.0000;(#,##0.0000)
   quantity.number.format = ##0.00
   integer-quantity.number.format = #0
   percentage.number.format = ##.##%
   export.number.format = #.00

In ModelFormField.java, the system gets property using EntityUtilProperties.getPropertyValue to ba able to quickly add a new format.

I think that it will require a discussion on Dev mailing-list to validate the choices.

Issue Links

• breaks: OFBIZ-12357 Quote: Quote item quantity field not visable
• is a child of: OFBIZ-10750 Umbrella issue for misc. issues in form widget date-time field
• is related to: OFBIZ-10152 Use properties for hard-coded date/time strings