デモアプリケーショントップ
ナビゲーション リンクのスキップ
 新機能 の展開 新機能
 InputMan連携 の展開 InputMan連携
 マルチタッチ機能 の展開 マルチタッチ機能
 セル、行、列、ヘッダ の展開 セル、行、列、ヘッダ
 シート の展開 シート
 スタイル の展開 スタイル
 選択 の展開 選択
 セル型 の展開 セル型
 編集 の展開 編集
 ソート の展開 ソート
 フィルタリング の展開 フィルタリング
 グループ化 の展開 グループ化
 ページング の展開 ページング
 スクロール の展開 スクロール
 データ連結 の展開 データ連結
 階層表示 の展開 階層表示
 コマンドバー の展開 コマンドバー
 チャート の縮小 チャート
 数式 の展開 数式
 インポート／エクスポート の展開 インポート／エクスポート
 クライアント側スクリプト の展開 クライアント側スクリプト

チャートコントロール

チャートコントロールを使用すると、チャートをSPREADのシート上ではなく、コントロールとしてWebフォームに配置できます。
 ABCDEF
1 SEWNNE
2S15025853026
3S29214152465
4S36526706043
5S42480261127
6      
   

ソースコード

別ウィンドウで表示 
using FarPoint.Web.Chart;
using FarPoint.Web.Spread;
using FarPoint.Web.Spread.Chart;
using System;
using System.Collections.Generic;
using System.Drawing;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class chart_control : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
        {
            return;
        }

        // SPREADの設定
        InitSpread(FpSpread1);

        // シート設定
        InitSpreadStyles(FpSpread1.Sheets[0]);
    }

    private void InitSpread(FarPoint.Web.Spread.FpSpread spread)
    {
        spread.CssClass = "spreadStyle2";
        spread.UseClipboard = false;
    }

    private void InitSpreadStyles(FarPoint.Web.Spread.SheetView sheet)
    {
        // 行列の設定
        sheet.RowCount = 6;
        sheet.ColumnCount = 6;
        sheet.PageSize = 25;
        sheet.DefaultColumnWidth = 100;

        // フォントサイズの設定
        sheet.DefaultStyle.Font.Size = FontUnit.Parse("80%");
        sheet.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%");
        sheet.RowHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%");
        sheet.SheetCorner.DefaultStyle.Font.Size = FontUnit.Parse("80%");

        // テストデータの設定
        sheet.SetClipValue(0, 1, 1, 5, "S\tE\tW\tN\tNE");
        sheet.SetClipValue(1, 0, 1, 6, "S1\t50\t25\t85\t30\t26");
        sheet.SetClipValue(2, 0, 1, 6, "S2\t92\t14\t15\t24\t65");
        sheet.SetClipValue(3, 0, 1, 6, "S3\t65\t26\t70\t60\t43");
        sheet.SetClipValue(4, 0, 1, 6, "S4\t24\t80\t26\t11\t27");

        // グリッド線の設定
        sheet.GridLines = GridLines.None;

        // 罫線と配置の設定
        for (int i = 0; i < 6; i++)
        {
            for (int j = 0; j < 6; j++)
            {
                sheet.Cells[i, j].Border = new FarPoint.Web.Spread.Border(BorderStyle.Solid, Color.LightGray, 1);
                sheet.Cells[i, j].HorizontalAlign = HorizontalAlign.Center;
                sheet.Cells[i, j].VerticalAlign = VerticalAlign.Middle;
            }
        }

        // シリーズを作成
        FarPoint.Web.Chart.BarSeries series1 = new FarPoint.Web.Chart.BarSeries();
        series1.SeriesName = "s1";
        series1.SeriesNameDataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldSeriesName", "Sheet1!$A$2:$A$2", FarPoint.Web.Spread.Chart.SegmentDataType.Text);
        series1.CategoryNames.DataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldCategoryName", "Sheet1!$B$1:$F$1", FarPoint.Web.Spread.Chart.SegmentDataType.Text);
        series1.Values.DataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldValue", "Sheet1!$B$2:$F$2");

        FarPoint.Web.Chart.BarSeries series2 = new FarPoint.Web.Chart.BarSeries();
        series2.SeriesName = "s2";
        series2.SeriesNameDataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldSeriesName", "Sheet1!$A$3:$A$3", FarPoint.Web.Spread.Chart.SegmentDataType.Text);
        series2.CategoryNames.DataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldCategoryName", "Sheet1!$B$1:$F$1", FarPoint.Web.Spread.Chart.SegmentDataType.Text);
        series2.Values.DataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldValue", "Sheet1!$B$3:$F$3");

        FarPoint.Web.Chart.BarSeries series3 = new FarPoint.Web.Chart.BarSeries();
        series3.SeriesName = "s3";
        series3.SeriesNameDataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldSeriesName", "Sheet1!$A$4:$A$4", FarPoint.Web.Spread.Chart.SegmentDataType.Text);
        series3.CategoryNames.DataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldCategoryName", "Sheet1!$B$1:$F$1", FarPoint.Web.Spread.Chart.SegmentDataType.Text);
        series3.Values.DataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldValue", "Sheet1!$B$4:$F$4");

        FarPoint.Web.Chart.BarSeries series4 = new FarPoint.Web.Chart.BarSeries();
        series4.SeriesName = "s4";
        series4.SeriesNameDataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldSeriesName", "Sheet1!$A$5:$A$5", FarPoint.Web.Spread.Chart.SegmentDataType.Text);
        series4.CategoryNames.DataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldCategoryName", "Sheet1!$B$1:$F$1", FarPoint.Web.Spread.Chart.SegmentDataType.Text);
        series4.Values.DataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldValue", "Sheet1!$B$5:$F$5");

        FarPoint.Web.Chart.ClusteredBarSeries barSeries = new FarPoint.Web.Chart.ClusteredBarSeries();
        barSeries.Series.AddRange(new FarPoint.Web.Chart.BarSeries[] { series1, series2, series3, series4 });

        // プロット領域を作成します
        FarPoint.Web.Chart.YPlotArea plotArea = new FarPoint.Web.Chart.YPlotArea();
        plotArea.Location = new System.Drawing.PointF(0.06f, 0.12f);
        plotArea.Size = new System.Drawing.SizeF(0.84f, 0.71f);
        plotArea.XAxis.MajorGridVisible = true;
        plotArea.Vertical = false;
        plotArea.Series.AddRange(new FarPoint.Web.Chart.Series[] { barSeries });

        // 凡例を設定します
        FarPoint.Web.Chart.LegendArea legend = new FarPoint.Web.Chart.LegendArea();
        legend.Location = new System.Drawing.PointF(0.995f, 0.5f);
        legend.AlignmentX = 1f;
        legend.AlignmentY = 0.5f;

        // チャートモデルに各情報を追加します
        FarPoint.Web.Chart.ChartModel model = new FarPoint.Web.Chart.ChartModel();
        model.LegendAreas.Add(legend);
        model.PlotAreas.Add(plotArea);

        FpChart1.Model = model;

        FpSpread1.HorizontalScrollBarPolicy = ScrollBarPolicy.Never;
        FpSpread1.VerticalScrollBarPolicy = ScrollBarPolicy.Never;
        FpSpread1.CommandBar.Visible = true;

        FpSpread1.ShowFocusRectangle = false;
    }
}

Imports FarPoint.Web.Chart
Imports FarPoint.Web.Spread
Imports FarPoint.Web.Spread.Chart
Imports System.Collections.Generic
Imports System.Drawing
Imports System.Linq
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls

Partial Public Class chart_control
    Inherits System.Web.UI.Page
    Protected Sub Page_Load(sender As Object, e As EventArgs)
        If IsPostBack Then
            Return
        End If

        ' SPREADの設定
        InitSpread(FpSpread1)

        ' シート設定
        InitSpreadStyles(FpSpread1.Sheets(0))
    End Sub

    Private Sub InitSpread(spread As FarPoint.Web.Spread.FpSpread)
        spread.CssClass = "spreadStyle2"
        spread.UseClipboard = False
    End Sub

    Private Sub InitSpreadStyles(sheet As FarPoint.Web.Spread.SheetView)
        ' 行列の設定
        sheet.RowCount = 6
        sheet.ColumnCount = 6
        sheet.PageSize = 25
        sheet.DefaultColumnWidth = 100

        ' フォントサイズの設定
        sheet.DefaultStyle.Font.Size = FontUnit.Parse("80%")
        sheet.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%")
        sheet.RowHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%")
        sheet.SheetCorner.DefaultStyle.Font.Size = FontUnit.Parse("80%")

        ' テストデータの設定
        sheet.SetClipValue(0, 1, 1, 5, "S" & vbTab & "E" & vbTab & "W" & vbTab & "N" & vbTab & "NE")
        sheet.SetClipValue(1, 0, 1, 6, "S1" & vbTab & "50" & vbTab & "25" & vbTab & "85" & vbTab & "30" & vbTab & "26")
        sheet.SetClipValue(2, 0, 1, 6, "S2" & vbTab & "92" & vbTab & "14" & vbTab & "15" & vbTab & "24" & vbTab & "65")
        sheet.SetClipValue(3, 0, 1, 6, "S3" & vbTab & "65" & vbTab & "26" & vbTab & "70" & vbTab & "60" & vbTab & "43")
        sheet.SetClipValue(4, 0, 1, 6, "S4" & vbTab & "24" & vbTab & "80" & vbTab & "26" & vbTab & "11" & vbTab & "27")

        ' グリッド線の設定
        sheet.GridLines = GridLines.None

        ' 罫線と配置の設定
        For i As Integer = 0 To 5
            For j As Integer = 0 To 5
                sheet.Cells(i, j).Border = New FarPoint.Web.Spread.Border(BorderStyle.Solid, Color.LightGray, 1)
                sheet.Cells(i, j).HorizontalAlign = HorizontalAlign.Center
                sheet.Cells(i, j).VerticalAlign = VerticalAlign.Middle
            Next
        Next

        ' シリーズを作成
        Dim series1 As New FarPoint.Web.Chart.BarSeries()
        series1.SeriesName = "s1"
        series1.SeriesNameDataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldSeriesName", "Sheet1!$A$2:$A$2", FarPoint.Web.Spread.Chart.SegmentDataType.Text)
        series1.CategoryNames.DataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldCategoryName", "Sheet1!$B$1:$F$1", FarPoint.Web.Spread.Chart.SegmentDataType.Text)
        series1.Values.DataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldValue", "Sheet1!$B$2:$F$2")

        Dim series2 As New FarPoint.Web.Chart.BarSeries()
        series2.SeriesName = "s2"
        series2.SeriesNameDataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldSeriesName", "Sheet1!$A$3:$A$3", FarPoint.Web.Spread.Chart.SegmentDataType.Text)
        series2.CategoryNames.DataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldCategoryName", "Sheet1!$B$1:$F$1", FarPoint.Web.Spread.Chart.SegmentDataType.Text)
        series2.Values.DataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldValue", "Sheet1!$B$3:$F$3")

        Dim series3 As New FarPoint.Web.Chart.BarSeries()
        series3.SeriesName = "s3"
        series3.SeriesNameDataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldSeriesName", "Sheet1!$A$4:$A$4", FarPoint.Web.Spread.Chart.SegmentDataType.Text)
        series3.CategoryNames.DataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldCategoryName", "Sheet1!$B$1:$F$1", FarPoint.Web.Spread.Chart.SegmentDataType.Text)
        series3.Values.DataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldValue", "Sheet1!$B$4:$F$4")

        Dim series4 As New FarPoint.Web.Chart.BarSeries()
        series4.SeriesName = "s4"
        series4.SeriesNameDataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldSeriesName", "Sheet1!$A$5:$A$5", FarPoint.Web.Spread.Chart.SegmentDataType.Text)
        series4.CategoryNames.DataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldCategoryName", "Sheet1!$B$1:$F$1", FarPoint.Web.Spread.Chart.SegmentDataType.Text)
        series4.Values.DataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldValue", "Sheet1!$B$5:$F$5")

        Dim barSeries As New FarPoint.Web.Chart.ClusteredBarSeries()
        barSeries.Series.AddRange(New FarPoint.Web.Chart.BarSeries() {series1, series2, series3, series4})

        ' プロット領域を作成します
        Dim plotArea As New FarPoint.Web.Chart.YPlotArea()
        plotArea.Location = New System.Drawing.PointF(0.06F, 0.12F)
        plotArea.Size = New System.Drawing.SizeF(0.84F, 0.71F)
        plotArea.XAxis.MajorGridVisible = True
        plotArea.Vertical = False
        plotArea.Series.AddRange(New FarPoint.Web.Chart.Series() {barSeries})

        ' 凡例を設定します
        Dim legend As New FarPoint.Web.Chart.LegendArea()
        legend.Location = New System.Drawing.PointF(0.995F, 0.5F)
        legend.AlignmentX = 1.0F
        legend.AlignmentY = 0.5F

        ' チャートモデルに各情報を追加します
        Dim model As New FarPoint.Web.Chart.ChartModel()
        model.LegendAreas.Add(legend)
        model.PlotAreas.Add(plotArea)

        FpChart1.Model = model

        FpSpread1.HorizontalScrollBarPolicy = ScrollBarPolicy.Never
        FpSpread1.VerticalScrollBarPolicy = ScrollBarPolicy.Never
        FpSpread1.CommandBar.Visible = True

        FpSpread1.ShowFocusRectangle = False
    End Sub
End Class


<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="chartcontrol.aspx.cs" Inherits="chart_control" %>

<%@ Register Assembly="FarPoint.Web.SpreadJ" Namespace="FarPoint.Web.Spread" TagPrefix="FarPoint" %>
<%@ Register Assembly="FarPoint.Web.Chart" Namespace="FarPoint.Web.Chart" TagPrefix="FarPoint" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeaderPlaceHolder1" runat="Server">
</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <FarPoint:FpChart ID="FpChart1" runat="server" Height="250px" Width="680px" BorderStyle="Solid" BorderWidth="1px" style="margin-bottom:10px" BorderColor="#A0A0A0" ViewType="View2D">
        <Model>
            <LabelAreas>
                <FarPoint:LabelArea AlignmentX="0.5" Location="0.5, 0.02"></FarPoint:LabelArea>
            </LabelAreas>
            <LegendAreas>
                <FarPoint:LegendArea AlignmentX="1" AlignmentY="0.5" Location="0.98, 0.5"></FarPoint:LegendArea>
            </LegendAreas>
            <PlotAreas>
                <FarPoint:YPlotArea Elevation="15" GlobalAmbientLight="50,50,50" Location="0.2, 0.2" Rotation="-20" Size="0.6, 0.6">
                    <YAxes>
                        <FarPoint:ValueAxis></FarPoint:ValueAxis>
                    </YAxes>
                    <Series>
                        <FarPoint:BarSeries />
                    </Series>
                    <Lights>
                        <FarPoint:DirectionalLight AmbientColor="128,128,128" DiffuseColor="128, 128, 128" DirectionX="10" DirectionY="20" DirectionZ="30"></FarPoint:DirectionalLight>
                    </Lights>
                </FarPoint:YPlotArea>
            </PlotAreas>
        </Model>
    </FarPoint:FpChart>

    <FarPoint:FpSpread ID="FpSpread1" runat="server" BorderColor="#A0A0A0" BorderStyle="Solid" BorderWidth="1px" Height="200px" ActiveSheetViewIndex="0" DesignString="&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;Spread /&gt;">
        <TouchInfo SelectionGripperLineColor=""></TouchInfo>

        <CommandBar BackColor="#F6F6F6" ButtonFaceColor="Control" ButtonHighlightColor="ControlLightLight" ButtonShadowColor="ControlDark">
            <Background BackgroundImageUrl="SPREADCLIENTPATH:/img/cbbg.gif"></Background>
        </CommandBar>
        <Sheets>
            <FarPoint:SheetView SheetName="Sheet1" DesignString="&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;Sheet&gt;&lt;Data&gt;&lt;RowHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;3&quot; columns=&quot;1&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/RowHeader&gt;&lt;ColumnHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;4&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/ColumnHeader&gt;&lt;DataArea class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;3&quot; columns=&quot;4&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;SheetName&gt;Sheet1&lt;/SheetName&gt;&lt;/DataArea&gt;&lt;SheetCorner class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;1&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/SheetCorner&gt;&lt;ColumnFooter class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;4&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/ColumnFooter&gt;&lt;/Data&gt;&lt;Presentation&gt;&lt;AxisModels&gt;&lt;Column class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; orientation=&quot;Horizontal&quot; count=&quot;4&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/Column&gt;&lt;RowHeaderColumn class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;40&quot; orientation=&quot;Horizontal&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;Size&gt;40&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RowHeaderColumn&gt;&lt;ColumnHeaderRow class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;22&quot; orientation=&quot;Vertical&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;Size&gt;22&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/ColumnHeaderRow&gt;&lt;ColumnFooterRow class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;22&quot; orientation=&quot;Vertical&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;Size&gt;22&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/ColumnFooterRow&gt;&lt;/AxisModels&gt;&lt;StyleModels&gt;&lt;RowHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;3&quot; Columns=&quot;1&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;RowHeaderDefault&quot; /&gt;&lt;ConditionalFormatCollections /&gt;&lt;/RowHeader&gt;&lt;ColumnHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;1&quot; Columns=&quot;4&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;ColumnHeaderDefault&quot; /&gt;&lt;ConditionalFormatCollections /&gt;&lt;/ColumnHeader&gt;&lt;DataArea class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;3&quot; Columns=&quot;4&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;DataAreaDefault&quot; /&gt;&lt;ColumnStyles&gt;&lt;ColumnStyle Index=&quot;0&quot;&gt;&lt;HorizontalAlign&gt;Center&lt;/HorizontalAlign&gt;&lt;/ColumnStyle&gt;&lt;/ColumnStyles&gt;&lt;RowStyles&gt;&lt;RowStyle Index=&quot;0&quot;&gt;&lt;HorizontalAlign&gt;Center&lt;/HorizontalAlign&gt;&lt;/RowStyle&gt;&lt;/RowStyles&gt;&lt;CellStyles&gt;&lt;CellStyle Row=&quot;1&quot; Column=&quot;1&quot;&gt;&lt;c class=&quot;FarPoint.Web.Spread.IntegerCellType&quot; BaseDropDown=&quot;1&quot;&gt;&lt;m&gt;整数型: (ex, 123)&lt;/m&gt;&lt;w&gt;False&lt;/w&gt;&lt;i&gt;False&lt;/i&gt;&lt;n&gt;&lt;CurrencyDecimalDigits&gt;0&lt;/CurrencyDecimalDigits&gt;&lt;CurrencyDecimalSeparator&gt;.&lt;/CurrencyDecimalSeparator&gt;&lt;CurrencyGroupSeparator&gt;,&lt;/CurrencyGroupSeparator&gt;&lt;CurrencyGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/CurrencyGroupSizes&gt;&lt;CurrencyNegativePattern&gt;1&lt;/CurrencyNegativePattern&gt;&lt;CurrencyPositivePattern&gt;0&lt;/CurrencyPositivePattern&gt;&lt;CurrencySymbol&gt;¥&lt;/CurrencySymbol&gt;&lt;NaNSymbol&gt;NaN&lt;/NaNSymbol&gt;&lt;NegativeInfinitySymbol&gt;-∞&lt;/NegativeInfinitySymbol&gt;&lt;NegativeSign&gt;-&lt;/NegativeSign&gt;&lt;NumberDecimalDigits&gt;0&lt;/NumberDecimalDigits&gt;&lt;NumberDecimalSeparator&gt;.&lt;/NumberDecimalSeparator&gt;&lt;NumberGroupSeparator&gt;,&lt;/NumberGroupSeparator&gt;&lt;NumberGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/NumberGroupSizes&gt;&lt;NumberNegativePattern&gt;1&lt;/NumberNegativePattern&gt;&lt;PercentDecimalDigits&gt;2&lt;/PercentDecimalDigits&gt;&lt;PercentDecimalSeparator&gt;.&lt;/PercentDecimalSeparator&gt;&lt;PercentGroupSeparator&gt;,&lt;/PercentGroupSeparator&gt;&lt;PercentGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/PercentGroupSizes&gt;&lt;PercentNegativePattern&gt;1&lt;/PercentNegativePattern&gt;&lt;PercentPositivePattern&gt;1&lt;/PercentPositivePattern&gt;&lt;PercentSymbol&gt;%&lt;/PercentSymbol&gt;&lt;PerMilleSymbol&gt;‰&lt;/PerMilleSymbol&gt;&lt;PositiveInfinitySymbol&gt;∞&lt;/PositiveInfinitySymbol&gt;&lt;PositiveSign&gt;+&lt;/PositiveSign&gt;&lt;/n&gt;&lt;g /&gt;&lt;bddct /&gt;&lt;t /&gt;&lt;/c&gt;&lt;h&gt;Right&lt;/h&gt;&lt;ts&gt;True&lt;/ts&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;1&quot; Column=&quot;2&quot;&gt;&lt;c class=&quot;FarPoint.Web.Spread.IntegerCellType&quot; BaseDropDown=&quot;1&quot;&gt;&lt;m&gt;整数型: (ex, 123)&lt;/m&gt;&lt;w&gt;False&lt;/w&gt;&lt;i&gt;False&lt;/i&gt;&lt;n&gt;&lt;CurrencyDecimalDigits&gt;0&lt;/CurrencyDecimalDigits&gt;&lt;CurrencyDecimalSeparator&gt;.&lt;/CurrencyDecimalSeparator&gt;&lt;CurrencyGroupSeparator&gt;,&lt;/CurrencyGroupSeparator&gt;&lt;CurrencyGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/CurrencyGroupSizes&gt;&lt;CurrencyNegativePattern&gt;1&lt;/CurrencyNegativePattern&gt;&lt;CurrencyPositivePattern&gt;0&lt;/CurrencyPositivePattern&gt;&lt;CurrencySymbol&gt;¥&lt;/CurrencySymbol&gt;&lt;NaNSymbol&gt;NaN&lt;/NaNSymbol&gt;&lt;NegativeInfinitySymbol&gt;-∞&lt;/NegativeInfinitySymbol&gt;&lt;NegativeSign&gt;-&lt;/NegativeSign&gt;&lt;NumberDecimalDigits&gt;0&lt;/NumberDecimalDigits&gt;&lt;NumberDecimalSeparator&gt;.&lt;/NumberDecimalSeparator&gt;&lt;NumberGroupSeparator&gt;,&lt;/NumberGroupSeparator&gt;&lt;NumberGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/NumberGroupSizes&gt;&lt;NumberNegativePattern&gt;1&lt;/NumberNegativePattern&gt;&lt;PercentDecimalDigits&gt;2&lt;/PercentDecimalDigits&gt;&lt;PercentDecimalSeparator&gt;.&lt;/PercentDecimalSeparator&gt;&lt;PercentGroupSeparator&gt;,&lt;/PercentGroupSeparator&gt;&lt;PercentGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/PercentGroupSizes&gt;&lt;PercentNegativePattern&gt;1&lt;/PercentNegativePattern&gt;&lt;PercentPositivePattern&gt;1&lt;/PercentPositivePattern&gt;&lt;PercentSymbol&gt;%&lt;/PercentSymbol&gt;&lt;PerMilleSymbol&gt;‰&lt;/PerMilleSymbol&gt;&lt;PositiveInfinitySymbol&gt;∞&lt;/PositiveInfinitySymbol&gt;&lt;PositiveSign&gt;+&lt;/PositiveSign&gt;&lt;/n&gt;&lt;g /&gt;&lt;bddct /&gt;&lt;t /&gt;&lt;/c&gt;&lt;h&gt;Right&lt;/h&gt;&lt;ts&gt;True&lt;/ts&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;2&quot; Column=&quot;1&quot;&gt;&lt;c class=&quot;FarPoint.Web.Spread.IntegerCellType&quot; BaseDropDown=&quot;1&quot;&gt;&lt;m&gt;整数型: (ex, 123)&lt;/m&gt;&lt;w&gt;False&lt;/w&gt;&lt;i&gt;False&lt;/i&gt;&lt;n&gt;&lt;CurrencyDecimalDigits&gt;0&lt;/CurrencyDecimalDigits&gt;&lt;CurrencyDecimalSeparator&gt;.&lt;/CurrencyDecimalSeparator&gt;&lt;CurrencyGroupSeparator&gt;,&lt;/CurrencyGroupSeparator&gt;&lt;CurrencyGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/CurrencyGroupSizes&gt;&lt;CurrencyNegativePattern&gt;1&lt;/CurrencyNegativePattern&gt;&lt;CurrencyPositivePattern&gt;0&lt;/CurrencyPositivePattern&gt;&lt;CurrencySymbol&gt;¥&lt;/CurrencySymbol&gt;&lt;NaNSymbol&gt;NaN&lt;/NaNSymbol&gt;&lt;NegativeInfinitySymbol&gt;-∞&lt;/NegativeInfinitySymbol&gt;&lt;NegativeSign&gt;-&lt;/NegativeSign&gt;&lt;NumberDecimalDigits&gt;0&lt;/NumberDecimalDigits&gt;&lt;NumberDecimalSeparator&gt;.&lt;/NumberDecimalSeparator&gt;&lt;NumberGroupSeparator&gt;,&lt;/NumberGroupSeparator&gt;&lt;NumberGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/NumberGroupSizes&gt;&lt;NumberNegativePattern&gt;1&lt;/NumberNegativePattern&gt;&lt;PercentDecimalDigits&gt;2&lt;/PercentDecimalDigits&gt;&lt;PercentDecimalSeparator&gt;.&lt;/PercentDecimalSeparator&gt;&lt;PercentGroupSeparator&gt;,&lt;/PercentGroupSeparator&gt;&lt;PercentGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/PercentGroupSizes&gt;&lt;PercentNegativePattern&gt;1&lt;/PercentNegativePattern&gt;&lt;PercentPositivePattern&gt;1&lt;/PercentPositivePattern&gt;&lt;PercentSymbol&gt;%&lt;/PercentSymbol&gt;&lt;PerMilleSymbol&gt;‰&lt;/PerMilleSymbol&gt;&lt;PositiveInfinitySymbol&gt;∞&lt;/PositiveInfinitySymbol&gt;&lt;PositiveSign&gt;+&lt;/PositiveSign&gt;&lt;/n&gt;&lt;g /&gt;&lt;bddct /&gt;&lt;t /&gt;&lt;/c&gt;&lt;h&gt;Right&lt;/h&gt;&lt;ts&gt;True&lt;/ts&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;2&quot; Column=&quot;2&quot;&gt;&lt;c class=&quot;FarPoint.Web.Spread.IntegerCellType&quot; BaseDropDown=&quot;1&quot;&gt;&lt;m&gt;整数型: (ex, 123)&lt;/m&gt;&lt;w&gt;False&lt;/w&gt;&lt;i&gt;False&lt;/i&gt;&lt;n&gt;&lt;CurrencyDecimalDigits&gt;0&lt;/CurrencyDecimalDigits&gt;&lt;CurrencyDecimalSeparator&gt;.&lt;/CurrencyDecimalSeparator&gt;&lt;CurrencyGroupSeparator&gt;,&lt;/CurrencyGroupSeparator&gt;&lt;CurrencyGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/CurrencyGroupSizes&gt;&lt;CurrencyNegativePattern&gt;1&lt;/CurrencyNegativePattern&gt;&lt;CurrencyPositivePattern&gt;0&lt;/CurrencyPositivePattern&gt;&lt;CurrencySymbol&gt;¥&lt;/CurrencySymbol&gt;&lt;NaNSymbol&gt;NaN&lt;/NaNSymbol&gt;&lt;NegativeInfinitySymbol&gt;-∞&lt;/NegativeInfinitySymbol&gt;&lt;NegativeSign&gt;-&lt;/NegativeSign&gt;&lt;NumberDecimalDigits&gt;0&lt;/NumberDecimalDigits&gt;&lt;NumberDecimalSeparator&gt;.&lt;/NumberDecimalSeparator&gt;&lt;NumberGroupSeparator&gt;,&lt;/NumberGroupSeparator&gt;&lt;NumberGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/NumberGroupSizes&gt;&lt;NumberNegativePattern&gt;1&lt;/NumberNegativePattern&gt;&lt;PercentDecimalDigits&gt;2&lt;/PercentDecimalDigits&gt;&lt;PercentDecimalSeparator&gt;.&lt;/PercentDecimalSeparator&gt;&lt;PercentGroupSeparator&gt;,&lt;/PercentGroupSeparator&gt;&lt;PercentGroupSizes&gt;&lt;Item&gt;3&lt;/Item&gt;&lt;/PercentGroupSizes&gt;&lt;PercentNegativePattern&gt;1&lt;/PercentNegativePattern&gt;&lt;PercentPositivePattern&gt;1&lt;/PercentPositivePattern&gt;&lt;PercentSymbol&gt;%&lt;/PercentSymbol&gt;&lt;PerMilleSymbol&gt;‰&lt;/PerMilleSymbol&gt;&lt;PositiveInfinitySymbol&gt;∞&lt;/PositiveInfinitySymbol&gt;&lt;PositiveSign&gt;+&lt;/PositiveSign&gt;&lt;/n&gt;&lt;g /&gt;&lt;bddct /&gt;&lt;t /&gt;&lt;/c&gt;&lt;h&gt;Right&lt;/h&gt;&lt;ts&gt;True&lt;/ts&gt;&lt;/CellStyle&gt;&lt;/CellStyles&gt;&lt;ConditionalFormatCollections /&gt;&lt;/DataArea&gt;&lt;SheetCorner class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;1&quot; Columns=&quot;1&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;CornerDefault&quot; /&gt;&lt;ConditionalFormatCollections /&gt;&lt;/SheetCorner&gt;&lt;ColumnFooter class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;1&quot; Columns=&quot;4&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;ColumnFooterDefault&quot; /&gt;&lt;ConditionalFormatCollections /&gt;&lt;/ColumnFooter&gt;&lt;/StyleModels&gt;&lt;MessageRowStyle class=&quot;FarPoint.Web.Spread.Appearance&quot;&gt;&lt;BackColor&gt;LightYellow&lt;/BackColor&gt;&lt;ForeColor&gt;Red&lt;/ForeColor&gt;&lt;/MessageRowStyle&gt;&lt;SheetCornerStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;CornerDefault&quot; /&gt;&lt;AllowLoadOnDemand&gt;false&lt;/AllowLoadOnDemand&gt;&lt;LoadRowIncrement &gt;10&lt;/LoadRowIncrement &gt;&lt;LoadInitRowCount &gt;30&lt;/LoadInitRowCount &gt;&lt;LoadOnDemandMode &gt;Standard&lt;/LoadOnDemandMode &gt;&lt;LoadOnDemandInterval &gt;500&lt;/LoadOnDemandInterval &gt;&lt;LoadOnDemandTriggerMode &gt;Timed&lt;/LoadOnDemandTriggerMode &gt;&lt;LoadOffsetFromBottom &gt;0&lt;/LoadOffsetFromBottom &gt;&lt;AllowVirtualScrollPaging&gt;false&lt;/AllowVirtualScrollPaging&gt;&lt;VirtualScrollPagingPrevRowCount&gt;0&lt;/VirtualScrollPagingPrevRowCount&gt;&lt;VirtualScrollPagingFormatString&gt;ページ {page} / {count}&lt;/VirtualScrollPagingFormatString&gt;&lt;TopRow&gt;0&lt;/TopRow&gt;&lt;PreviewRowStyle class=&quot;FarPoint.Web.Spread.PreviewRowInfo&quot; /&gt;&lt;FilterBar class=&quot;FarPoint.Web.Spread.FilterBar&quot;&gt;&lt;Height&gt;22&lt;/Height&gt;&lt;IndicatorCssClass /&gt;&lt;Style class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;2&quot; Columns=&quot;4&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;RowStyles&gt;&lt;RowStyle Index=&quot;0&quot; class=&quot;FarPoint.Web.Spread.FilterBarStyleInfo&quot; Parent=&quot;FilterBarDefault&quot; /&gt;&lt;RowStyle Index=&quot;1&quot; class=&quot;FarPoint.Web.Spread.FilterBarStyleInfo&quot; Parent=&quot;RowHeaderDefault&quot;&gt;&lt;HorizontalAlign&gt;Center&lt;/HorizontalAlign&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/RowStyle&gt;&lt;/RowStyles&gt;&lt;ConditionalFormatCollections /&gt;&lt;/Style&gt;&lt;/FilterBar&gt;&lt;/Presentation&gt;&lt;Settings&gt;&lt;Name&gt;Sheet1&lt;/Name&gt;&lt;Categories&gt;&lt;Appearance&gt;&lt;GridLineColor&gt;#d0d7e5&lt;/GridLineColor&gt;&lt;SelectionBackColor&gt;#eaecf5&lt;/SelectionBackColor&gt;&lt;SelectionBorder class=&quot;FarPoint.Web.Spread.Border&quot; /&gt;&lt;/Appearance&gt;&lt;Behavior&gt;&lt;EditTemplateColumnCount&gt;2&lt;/EditTemplateColumnCount&gt;&lt;GroupBarText&gt;グループ化するときには、ここに列名をドラッグします。&lt;/GroupBarText&gt;&lt;/Behavior&gt;&lt;Layout&gt;&lt;ColumnHeaderRowCount&gt;1&lt;/ColumnHeaderRowCount&gt;&lt;RowHeaderColumnCount&gt;1&lt;/RowHeaderColumnCount&gt;&lt;/Layout&gt;&lt;/Categories&gt;&lt;ActiveRow&gt;1&lt;/ActiveRow&gt;&lt;ActiveColumn&gt;1&lt;/ActiveColumn&gt;&lt;ColumnHeaderRowCount&gt;1&lt;/ColumnHeaderRowCount&gt;&lt;ColumnFooterRowCount&gt;1&lt;/ColumnFooterRowCount&gt;&lt;PrintInfo&gt;&lt;Header /&gt;&lt;Footer /&gt;&lt;ZoomFactor&gt;0&lt;/ZoomFactor&gt;&lt;FirstPageNumber&gt;1&lt;/FirstPageNumber&gt;&lt;Orientation&gt;Auto&lt;/Orientation&gt;&lt;PrintType&gt;All&lt;/PrintType&gt;&lt;PageOrder&gt;Auto&lt;/PageOrder&gt;&lt;BestFitCols&gt;False&lt;/BestFitCols&gt;&lt;BestFitRows&gt;False&lt;/BestFitRows&gt;&lt;PageStart&gt;-1&lt;/PageStart&gt;&lt;PageEnd&gt;-1&lt;/PageEnd&gt;&lt;ColStart&gt;-1&lt;/ColStart&gt;&lt;ColEnd&gt;-1&lt;/ColEnd&gt;&lt;RowStart&gt;-1&lt;/RowStart&gt;&lt;RowEnd&gt;-1&lt;/RowEnd&gt;&lt;ShowBorder&gt;True&lt;/ShowBorder&gt;&lt;ShowGrid&gt;True&lt;/ShowGrid&gt;&lt;ShowColor&gt;True&lt;/ShowColor&gt;&lt;ShowColumnHeader&gt;Inherit&lt;/ShowColumnHeader&gt;&lt;ShowRowHeader&gt;Inherit&lt;/ShowRowHeader&gt;&lt;ShowFilterBar&gt;Inherit&lt;/ShowFilterBar&gt;&lt;ShowColumnFooter&gt;Inherit&lt;/ShowColumnFooter&gt;&lt;ShowColumnFooterEachPage&gt;True&lt;/ShowColumnFooterEachPage&gt;&lt;ShowTitle&gt;True&lt;/ShowTitle&gt;&lt;ShowSubtitle&gt;True&lt;/ShowSubtitle&gt;&lt;UseMax&gt;True&lt;/UseMax&gt;&lt;UseSmartPrint&gt;False&lt;/UseSmartPrint&gt;&lt;Opacity&gt;255&lt;/Opacity&gt;&lt;PrintNotes&gt;None&lt;/PrintNotes&gt;&lt;Centering&gt;None&lt;/Centering&gt;&lt;RepeatColStart&gt;-1&lt;/RepeatColStart&gt;&lt;RepeatColEnd&gt;-1&lt;/RepeatColEnd&gt;&lt;RepeatRowStart&gt;-1&lt;/RepeatRowStart&gt;&lt;RepeatRowEnd&gt;-1&lt;/RepeatRowEnd&gt;&lt;SmartPrintPagesTall&gt;1&lt;/SmartPrintPagesTall&gt;&lt;SmartPrintPagesWide&gt;1&lt;/SmartPrintPagesWide&gt;&lt;HeaderHeight&gt;-1&lt;/HeaderHeight&gt;&lt;FooterHeight&gt;-1&lt;/FooterHeight&gt;&lt;/PrintInfo&gt;&lt;TitleInfo class=&quot;FarPoint.Web.Spread.TitleInfo&quot;&gt;&lt;Style class=&quot;FarPoint.Web.Spread.StyleInfo&quot;&gt;&lt;BackColor&gt;White&lt;/BackColor&gt;&lt;HorizontalAlign&gt;Right&lt;/HorizontalAlign&gt;&lt;/Style&gt;&lt;/TitleInfo&gt;&lt;WorksheetTemplate class=&quot;FarPoint.Web.Spread.WorksheetTemplate&quot;&gt;&lt;Layout&gt;&lt;ColumnCount&gt;4&lt;/ColumnCount&gt;&lt;/Layout&gt;&lt;AxisModels&gt;&lt;LayoutColumn class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; orientation=&quot;Horizontal&quot; count=&quot;4&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/LayoutColumn&gt;&lt;/AxisModels&gt;&lt;Data&gt;&lt;LayoutData class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;4&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;Cells&gt;&lt;Cell row=&quot;0&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;0&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;1&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;2&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;3&lt;/Data&gt;&lt;/Cell&gt;&lt;/Cells&gt;&lt;/LayoutData&gt;&lt;/Data&gt;&lt;/WorksheetTemplate&gt;&lt;LayoutMode&gt;CellLayoutMode&lt;/LayoutMode&gt;&lt;AutoFilterMode&gt;FilterGadget&lt;/AutoFilterMode&gt;&lt;CurrentPageIndex type=&quot;System.Int32&quot;&gt;0&lt;/CurrentPageIndex&gt;&lt;/Settings&gt;&lt;/Sheet&gt;">
            </FarPoint:SheetView>
        </Sheets>
        <TouchStrips>
            <FarPoint:TouchStrip Area="Chart" NoTouchStrip="True"></FarPoint:TouchStrip>
        </TouchStrips>

        <TitleInfo BackColor="White" ForeColor="" HorizontalAlign="Center" VerticalAlign="NotSet" Font-Size="X-Large" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False"></TitleInfo>
    </FarPoint:FpSpread>

</asp:Content>