Home arrow Reference arrow AssignCellFormat

CONTENT WARNING

This site refers to our older, server-based product. If you are interested in our new, Excel-based product, please see our main web site at http://www.nextanalytics.com

AssignCellFormat
Assigns numeric format to selected numeric columns.

Syntax:

AssignCellFormat, allPages, newFormat

Parameters:

allPages - Indicates to apply to all pages (true) or just the current page (false)

newFormat – Numeric format (see PageNumericFormat for details)

Examples:

AssignCellFormat,false,N0
AssignCellFormat,false,N2
AssignCellFormat,false,"#,##0.00"

Comments:

This format will work on both .NET and Unix.

Depending on the country and language of the server, it will format the number using the local thousands indicator and decimal indicator.

The numeric format will be used during export operations, so care should be taken to preserve data accuracy if needed.

 

Reference

Installation - Java