チャートコントロール

チャートコントロールを使用すると、チャートを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>