Excel format use a custom format that misrepresents the number when the a calculated column uses a function

[Adam Davis]

The format of a calculated column that uses a function is exported from the widget to excel. In Excel the custom format of “(#,##0.00)” is applied which formats negative numbers as: -(1,234). The format should be “#,##0.00”.

Using the UX Sample > Formula > DBRW Formula from the demo. File Attached. Add 3 formulas

1. Simple Calc: =c1 -b1 format in excel is #,##0.00.
2. Round Function: =Round( c1-b1, 2) the format in excel is “(#,##0.00)”.
3. IF Function: IF( c1 < b1, c1-b1, 0 ) the format in excel is “(#,##0.00)”.

See attached for examples.

[tomer ganz]

we will look into this issue