OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 4

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Wiki Administrator

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

Creates an accounting format string.

Signature
C#
C#
 public System.String CreateAccounting(int numDecimalPlaces, boolean useDollarSign, Color negativeColor)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Function CreateAccounting(ByVal numDecimalPlaces As Integer, ByVal useDollarSign As Boolean, ByVal negativeColor As Color) As String
{signature}
{parameters}
{param:numDecimalPlaces}The number of decimal places to display.{param}
{param:useDollarSign}If {{true}}, the dollar sign will be displayed.{param}
{param:negativeColor}A color to use when displaying negative numbers.  {{negativeColor}} may be null.{param}
{returns}An accounting format string.{returns}
{example}{code:csharp|title=C#}
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
titleC#


          //--- 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} {code:
 Code Block
vb.net
|title=
vb.net
titlevb.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)
        
{code}

{example}