Visual Basic (Declaration) | |
---|---|
Public Property NumberFormat As System.String |
C# | |
---|---|
public System.string NumberFormat {get; set;} |
Property Value
String.For foreign currency symbols such as the Japanese Yen you can use a format such as: "[$¥-0]#,##0.00". Replace the Yen sign (¥) with whatever currency symbol you want to use.
C# | Copy Code |
---|---|
sb.Sheets[0].Cell(0,0).Alignment = GrapeCity.SpreadBuilder.Style.HorzAlignments.Right; sb.Sheets[0].Cell(0,0).BorderBottomColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderBottomStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderDiagonalColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderDiagonalEnum = GrapeCity.SpreadBuilder.Style.BorderDiagonalStyles.Both; sb.Sheets[0].Cell(0,0).BorderDiagonalStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Hair; sb.Sheets[0].Cell(0,0).BorderLeftColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderLeftStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderRightColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderRightStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).BorderTopColor = System.Drawing.Color.Red; sb.Sheets[0].Cell(0,0).BorderTopStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double; sb.Sheets[0].Cell(0,0).FillColor = System.Drawing.Color.Gray; sb.Sheets[0].Cell(0,0).FontBold = true; sb.Sheets[0].Cell(0,0).FontItalic = true; sb.Sheets[0].Cell(0,0).FontName = "Times New Roman"; sb.Sheets[0].Cell(0,0).FontSize = 14; sb.Sheets[0].Cell(0,0).FontUnderlineStyle = GrapeCity.SpreadBuilder.Style.FontUnderlineStyles.Single; sb.Sheets[0].Cell(0,0).ForeColor = System.Drawing.Color.Blue; sb.Sheets[0].Cell(0,0).Hyperlink = "www.GrapeCity.com"; sb.Sheets[0].Cell(0,0).NumberFormat = "[$¥-0]#,##0.00"; sb.Sheets[0].Cell(0,0).TextAngle = 255; sb.Sheets[0].Cell(0,0).VertAlignment = GrapeCity.SpreadBuilder.Style.VertAlignments.Top; sb.Sheets[0].Cell(0,0).WrapText = true; |
Visual Basic | Copy Code |
---|---|
With sb.Sheets(0).Cell(0, 0) .Alignment = GrapeCity.SpreadBuilder.Style.HorzAlignments.Right .BorderBottomColor = System.Drawing.Color.Red .BorderBottomStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double .BorderDiagonalColor = System.Drawing.Color.Red .BorderDiagonalEnum = GrapeCity.SpreadBuilder.Style.BorderDiagonalStyles.Both .BorderDiagonalStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Hair .BorderLeftColor = System.Drawing.Color.Red .BorderLeftStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double .BorderRightColor = System.Drawing.Color.Red .BorderRightStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double .BorderTopColor = System.Drawing.Color.Red .BorderTopStyle = GrapeCity.SpreadBuilder.Style.BorderLineStyle.Double .FillColor = System.Drawing.Color.Gray .FontBold = True .FontItalic = True .FontName = "Times New Roman" .FontSize = 14 .FontUnderlineStyle = GrapeCity.SpreadBuilder.Style.FontUnderlineStyles.Single .ForeColor = System.Drawing.Color.Blue .Hyperlink = "www.GrapeCity.com" .NumberFormat = "[$¥-0]#,##0.00" .TextAngle = 255 .VertAlignment = GrapeCity.SpreadBuilder.Style.VertAlignments.Top .WrapText = True End With |
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2