FIXED

FIXED(arg1, arg2, arg3) → { string }

Rounds a number to the specified number of decimals and returns the result as text with or without commas.

Parameters:

Name Type Description
arg1 number

The number to round and convert to text.

arg2 number

The number of digits to the right of the decimal point. If omitted, the function will assume it to be 2.

arg3 boolean

Specifies whether do display commas in the returned text (false or omitted) or not (true).

Returns:

Type
string

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.FIXED(1234.9, 1, false));
builder.SaveFile("xlsx", "FIXED.xlsx");
builder.CloseFile();

Resulting document