CalcEdit.FormatTotalResult Property (ExCalcEdit)

By default, the FormatTotalResult property is "[=%%]". The AllowTotal property defines the Total keyword. The Total keyword, specifies the sum of all lines that are not empty, valid and defines no variables. Use the Result property to retrieve the result on specified line. The TextLine property specifies the content of the giving line. Use the IsValid property to specify whether the expression on giving line, is syntactically correct and may be evaluated. The Result is not displayed, if the FormatTotalResult property is empty. For instance, the format "</r>%%" displays the result in the right side of the control.

The list of supported built-in HTML tags is:

bold
italic
<s>~~strikeout~~</s>
underline
<fgcolor=RRGGBB>fgcolor</fgcolor>
<bgcolor=RRGGBB>bgcolor</bgcolor>
text displays portions of text with a different font and/or different size. For instance, the bit draws the bit text using the Tahoma font, on size 12 pt. If the name of the font is missing, and instead size is present, the current font is used with a different size. For instance, bit displays the bit text using the current font, but with a different size.

For instance, let's say we have the following sample:

With CalcEdit1
	.MultiLine = True
	.InsertText "100 * 200"
	.InsertText "300 * 400 * 1.5"
	.InsertText "200 + ( 400 * 1.5 + 300 / 1.19)"
End With 
The following screen shot shows the control if the FormatResult property is "<fgcolor=808080>[=%%]</fgcolor>" (default), FormatLocal property is "" (default)

The following screen shot shows the control if the FormatResult property is "<fgcolor=808080><r> = %%", FormatLocal property is "" (default)

The following screen shot shows the control if the FormatResult property is "<fgcolor=808080><r> = %l%", FormatLocal property is "" (default)

The following screen shot shows the control if the FormatResult property is "<fgcolor=808080><r> = %l%", FormatLocal property is "currency(value)"

The following screen shot shows the control if the FormatResult property is "<fgcolor=808080><r> = %l%", FormatLocal property is "value format `2`"

The following screen shot shows the control if the FormatResult property is "<fgcolor=808080><r> = %l%", FormatLocal property is "value"

The following screen shot shows the control if the FormatResult property is "<fgcolor=808080><r> = %l%", FormatLocal property is "( value > 10000 ? `<fgcolor=FF0000>` : ``) + (value format `2`)"

The following screen shot shows the control if the FormatResult property is "<fgcolor=808080><r> = %l%", FormatLocal property is "( value < 10000 ? `<fgcolor=000000>` : ``) + (value format `2`)"

		Type	Description
		String	A string expression that indicates the HTML format being used to display the result for a Total line. The FormatTotalResult property should include %% sequence that's replaced with the result. The FormatTotalResult supports also %l%, which is replaced by the evaluation of the FormatLocal property using the current result.