GrapeCity.Xaml.SpreadSheet.Data Namespace > Column Class : Formatter Property |
'Declaration <DefaultValueAttribute()> Public Property Formatter As IFormatter
'Usage Dim instance As Column Dim value As IFormatter instance.Formatter = value value = instance.Formatter
[DefaultValue()] public IFormatter Formatter {get; set;}
for (int i = 0; i < gcSpreadSheet1.Sheets[0].RowCount; i++) { gcSpreadSheet1.Sheets[0].Columns[1].SetValue(i, i); } gcSpreadSheet1.Sheets[0].Columns[1].Background = new SolidColorBrush(Windows.UI.Colors.Gray); gcSpreadSheet1.Sheets[0].Columns[1].Foreground = new SolidColorBrush(Windows.UI.Colors.Red); gcSpreadSheet1.Sheets[0].Columns[1].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("0.00"); gcSpreadSheet1.Sheets[0].Columns[1].FontSize = 12; gcSpreadSheet1.Sheets[0].Columns[1].FontWeight = Windows.UI.Text.FontWeights.Bold; gcSpreadSheet1.Sheets[0].Columns[1].BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin); gcSpreadSheet1.Sheets[0].Columns[1].BorderTop = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin); gcSpreadSheet1.Sheets[0].Columns[1].BorderLeft = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin); gcSpreadSheet1.Sheets[0].Columns[1].BorderRight = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin);
For i As Integer = 0 To GcSpreadSheet1.Sheets(0).RowCount - 1 GcSpreadSheet1.Sheets(0).Columns(1).SetValue(i, i) Next GcSpreadSheet1.Sheets(0).Columns(1).Background = New SolidColorBrush(Windows.UI.Colors.Gray) GcSpreadSheet1.Sheets(0).Columns(1).Foreground = New SolidColorBrush(Windows.UI.Colors.Red) GcSpreadSheet1.Sheets(0).Columns(1).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("0.00") GcSpreadSheet1.Sheets(0).Columns(1).FontSize = 12 GcSpreadSheet1.Sheets(0).Columns(1).FontWeight = Windows.UI.Text.FontWeights.Bold GcSpreadSheet1.Sheets(0).Columns(1).BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin) GcSpreadSheet1.Sheets(0).Columns(1).BorderTop = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin) GcSpreadSheet1.Sheets(0).Columns(1).BorderLeft = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin) GcSpreadSheet1.Sheets(0).Columns(1).BorderRight = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin)
Target Platforms: Windows Server 2012, Windows RT