Page History

Description

Excerpt
Creates an accounting format string.

Signature

	C#
	C#

 public System.String CreateAccounting(int numDecimalPlaces, boolean useDollarSign, Color negativeColor)

Signature

	vb.net
	vb.net

Public Function CreateAccounting(ByVal numDecimalPlaces As Integer, ByVal useDollarSign As Boolean, ByVal negativeColor As Color) As String

Parameters

Param

	numDecimalPlaces
	numDecimalPlaces

The number of decimal places to display.

Param

	useDollarSign
	useDollarSign

If true, the dollar sign will be displayed.

Param

	negativeColor
	negativeColor

A color to use when displaying negative numbers. negativeColor may be null.

Returns
An accounting format string.

Example

Code Block

	csharp
	csharp
title	C#


          //--- Create a style.
          Style styl = wb.CreateStyle();

          //--- The following creates the format
          //--- "_($* #,##0.00_);[Green]_($* #,##0.00_);_(* \"-\"_);_(@_)"
          styl.NumberFormat = wb.NumberFormat.CreateAccounting(2,
               true,
               NumberFormat.Color.Green);

Code Block

	vb.net
	vb.net
title	vb.net


          '--- Create a style.
          Dim styl As Style = wb.CreateStyle()

          '--- The following creates the format
          '--- "_($* #,##0.00_);[Green]_($* #,##0.00_);_(* \"-\"_);_(@_)"
          styl.NumberFormat = wb.NumberFormat.CreateAccounting(2, _
               True, _
               NumberFormat.Color.Green)

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version Current

Key