CalcEdit.FormatSubTotalResult Property (ExCalcEdit)

By default, the FormatSubTotalResult property is "<fgcolor=808080>[=%%]</fgcolor>". The AllowSubTotal property defines the SubTotal keyword. The SubTotal keyword, specifies the sum of all previously lines that are not empty, valid, defines no variables until another SubTotal keyword is found. 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 FormatSubTotalResult 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 SubTotal line. The FormatSubTotalResult property should include %% sequence that's replaced with the result. The FormatSubTotalResult supports also %l%, which is replaced by the evaluation of the FormatLocal property using the current result.