ExcelNumberFormat icon indicating copy to clipboard operation
ExcelNumberFormat copied to clipboard

Support rounding numbers from format

Open andersnm opened this issue 7 years ago • 0 comments

Suggest a new NumberFormat.Round() method to return numeric inputs as numbers still, but with number formatting rules applied - i.e round to number of decimals, percent multiply, thousands division.

F.ex the number 0.02345 returns different values depending on the format:

Number format Round(0.02345) output
0% 2
0.00000, 0.00002
0.00 0.02

This helps for cases when the user wants to insert the "visual part" of a value into a numeric database field.

andersnm avatar Nov 02 '17 11:11 andersnm