SEMANTICFORMAT

Semantic formatting lets you highlight or emphasize positive and negative values.

Syntax

SETSEMANTICFORMATTING(VALUE)

Arguments

VALUE - Pass a boolean value of TRUE or FALSE.

Example

SETSEMANTICFORMATTING(TRUE)

SEMANTICFORMAT.POSTIVE.AFTER  // 123+
SEMANTICFORMAT.POSTIVE.BEFORE // +123
SEMANTICFORMAT.NEGATIVE.BRACKET //(123)

Notice how semantic formatting options have been applied in the reading view for positive and negative numbers using the SEMANTICFORMATTING functions.

Semantic formatting options

Last updated

Was this helpful?