Sheets Format for Thousands without Decimal


#1

I’ve reviewed all the documentation on Number Format, but I have not seen a way to remove the insignificant decimal from the format to get the display correctly. Example being have 1,234,567 as the display tried the following mask:

#,##0
#,###
#,##0.

Using the “format” property of sheets as:
formats: [
{
name: “Thousands”,
id: “thousands”,
mask: “#,##0”,
example: “1234567”
}
]

They all display inaccurate formatting by either dropping the last digit so it ends up as (12345,67) - any suggestions to show thousands separator without any decimals?


#2

I apologize for the delay with the reply.
Please, try to check the latest update of the spreadsheet. We have fixed the problem with insignificant decimals. Now it should work well:
https://snippet.dhtmlx.com/du0n8ixq