セル型

標準セル型の他に17種類のセル型を提供しています。 表示データの形式にあわせてセル型を自由に選べます。
 ABCD
1整数123ラベルLabel
2日付時刻2017/11/22ボタン(イメージ)
3倍精度123.45ボタン(プッシュ)
4通貨¥12,345ボタン(リンク)クリック
5テキストテキストイメージ
ImageAlignプロパティでイメージとテキストの位置を調整可能です。
6マスク123-45-6789リストボックス
赤色
緑色
青色
7パーセント25%チェックボックス
8  ラジオボタンリスト
9  ハイパーリンクGrapeCity Webサイト
10  コンボボックス
11  マルチカラムコンボボックス
12  タグクラウド型:

ソースコード

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

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

        // SPREAD初期化
        InitSpread(FpSpread1.Sheets[0]);

        // セル型の設定
        SetCellType(FpSpread1.Sheets[0]);
    }

    private void InitSpread(FarPoint.Web.Spread.SheetView sheet)
    {
        // SPREAD設定
        sheet.FpSpread.CommandBar.Visible = false;
        sheet.FpSpread.CssClass = "spreadStyle";
        sheet.FpSpread.UseClipboard = false;

        // フォントサイズの設定
        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.Columns[0].BackColor = System.Drawing.Color.Silver;
        sheet.Columns[2].BackColor = System.Drawing.Color.Silver;

        // シート設定
        sheet.RowCount = 12;
        sheet.ColumnCount = 4;
        sheet.PageSize = sheet.RowCount;

        // 列幅の設定
        sheet.Columns[0].Width = 100;
        sheet.Columns[1].Width = 120;
        sheet.Columns[2].Width = 180;
        sheet.Columns[3].Width = 180;

        sheet.Rows[5].Height = 60;

        // 縦方向の揃え位置を中央に設定
        sheet.DefaultStyle.VerticalAlign = VerticalAlign.Middle;
    }

    private void SetCellType(FarPoint.Web.Spread.SheetView sheet)
    {
        // 1列目のセルをロックしてユーザの編集を禁止
        sheet.Columns[0].HorizontalAlign = HorizontalAlign.Right;
        sheet.Columns[0].Locked = true;

        // セル型の設定
        sheet.Cells[0, 0].Text = "整数";
        sheet.Cells[0, 1].Text = "123";

        sheet.Cells[1, 0].Text = "日付時刻";
        sheet.Cells[1, 1].Text = DateTime.Now.ToOADate().ToString();

        sheet.Cells[2, 0].Text = "倍精度";
        sheet.Cells[2, 1].Text = "123.45";

        sheet.Cells[3, 0].Text = "通貨";
        sheet.Cells[3, 1].Text = "12345.01";

        sheet.Cells[4, 0].Text = "テキスト";
        sheet.Cells[4, 1].Text = "テキスト";

        sheet.Cells[5, 0].Text = "マスク";
        sheet.Cells[5, 1].Text = "123-45-6789";

        sheet.Cells[6, 0].Text = "パーセント";
        sheet.Cells[6, 1].Text = "25%";

        // 整数型セルの設定
        FarPoint.Web.Spread.IntegerCellType fpcell = new FarPoint.Web.Spread.IntegerCellType();
        fpcell.ErrorMessage = "数値を入力してください。";
        fpcell.ShowPopupButton = true;
        sheet.Cells[0, 1].CellType = fpcell;

        // 日付時刻型セルの設定
        FarPoint.Web.Spread.DateTimeCellType dtcell = new FarPoint.Web.Spread.DateTimeCellType();
        dtcell.ShowPopupButton = true;
        sheet.Cells[1, 1].CellType = dtcell;

        // 倍精度型セルの設定
        FarPoint.Web.Spread.DoubleCellType dCell = new FarPoint.Web.Spread.DoubleCellType();
        dCell.ShowPopupButton = true;
        sheet.Cells[2, 1].CellType = dCell;

        // 通貨型セルの設定
        FarPoint.Web.Spread.CurrencyCellType cCell = new FarPoint.Web.Spread.CurrencyCellType();
        cCell.ShowPopupButton = true;
        sheet.Cells[3, 1].CellType = cCell;

        // マスク型セルの設定
        FarPoint.Web.Spread.RegExpCellType rg = new FarPoint.Web.Spread.RegExpCellType();
        rg.ErrorMessage = "書式が異なります。例:123-45-6789";
        rg.ValidationExpression = "^\\d{3}-\\d{2}-\\d{4}$";
        sheet.Cells[5, 1].CellType = rg;

        // パーセント型セルの設定
        FarPoint.Web.Spread.PercentCellType pCell = new FarPoint.Web.Spread.PercentCellType();
        pCell.ShowPopupButton = true;
        sheet.Cells[6, 1].CellType = pCell;

        // 3列目のセルをロックしてユーザの編集を禁止
        sheet.Columns[2].HorizontalAlign = HorizontalAlign.Right;
        sheet.Columns[2].Locked = true;

        // セル型の設定
        sheet.Cells[0, 2].Text = "ラベル";
        sheet.Cells[0, 3].Text = "Label";

        sheet.Cells[1, 2].Text = "ボタン(イメージ)";
        sheet.Cells[2, 2].Text = "ボタン(プッシュ)";
        sheet.Cells[3, 2].Text = "ボタン(リンク)";

        sheet.Cells[4, 2].Text = "イメージ";
        sheet.Cells[4, 3].Text = "ImageAlignプロパティでイメージとテキストの位置を調整可能です。";

        sheet.Cells[5, 2].Text = "リストボックス";
        sheet.Cells[5, 3].Text = "0";

        sheet.Cells[6, 2].Text = "チェックボックス";
        sheet.Cells[6, 3].Value = true;

        sheet.Cells[7, 2].Text = "ラジオボタンリスト";
        sheet.Cells[7, 3].Text = "1";

        sheet.Cells[8, 2].Text = "ハイパーリンク";
        sheet.Cells[8, 3].Text = "GrapeCity Webサイト";

        sheet.Cells[9, 2].Text = "コンボボックス";
        sheet.Cells[9, 3].Text = "2";

        sheet.Cells[10, 2].Text = "マルチカラムコンボボックス";

        sheet.Cells[11, 2].Text = "タグクラウド型:";

        // ラベル型セルの設定
        sheet.Cells[0, 3].CellType = new FarPoint.Web.Spread.LabelCellType();

        // ボタン型セルの設定
        // 画像ボタン
        sheet.Cells[1, 3].CellType 
            = new FarPoint.Web.Spread.ButtonCellType("MyCommand", 
                FarPoint.Web.Spread.ButtonType.ImageButton,"../images/music.gif");
        
        // プッシュボタン
        sheet.Cells[2, 3].CellType 
            = new FarPoint.Web.Spread.ButtonCellType("MyCommand", 
                FarPoint.Web.Spread.ButtonType.PushButton, "クリック");

        // リンクボタン
        sheet.Cells[3, 3].CellType 
            = new FarPoint.Web.Spread.ButtonCellType("MyCommand", 
                FarPoint.Web.Spread.ButtonType.LinkButton, "クリック");
        sheet.Cells[3, 3].HorizontalAlign = HorizontalAlign.Center;

        // イメージ型セルの設定
        sheet.Cells[4, 3].CellType 
            = new FarPoint.Web.Spread.ImageCellType("../images/english.gif");        

        // リストボックス型セルの設定
        FarPoint.Web.Spread.ListBoxCellType lbcell = new FarPoint.Web.Spread.ListBoxCellType();
        lbcell.Items = new String[] { "赤色", "緑色", "青色" };
        sheet.Cells[5, 3].CellType = lbcell;        

        // チェックボックス型セルの設定
        FarPoint.Web.Spread.CheckBoxCellType ch = new FarPoint.Web.Spread.CheckBoxCellType();
        ch.AutoPostBack = true;
        ch.Text = "AutoPostBack";
        sheet.Cells[6, 3].CellType = ch;

        // ラジオボタンリスト型セルの設定
        sheet.Cells[7, 3].CellType 
            = new FarPoint.Web.Spread.RadioButtonListCellType(new string[] { "赤色", "緑色", "青色" }, 
                new string[] { "赤色", "緑色", "青色" });

        // ハイパーリンク型セルの設定
        sheet.Cells[8, 3].CellType 
            = new FarPoint.Web.Spread.HyperLinkCellType("http://www.grapecity.com/tools/");

        // コンボボックス型セルの設定
        FarPoint.Web.Spread.ComboBoxCellType cb 
            = new FarPoint.Web.Spread.ComboBoxCellType(new string[] { "赤色", "緑色", "青色" }, 
                new string[] { "赤色", "緑色", "青色" });
        cb.ShowButton = true;
        sheet.Cells[9, 3].CellType = cb;

        // マルチカラムコンボボックス型セルの設定
        System.Data.DataSet ds = new System.Data.DataSet();
        ds.ReadXml(MapPath("../App_Data/data.xml"));
        FarPoint.Web.Spread.MultiColumnComboBoxCellType mcombo = new FarPoint.Web.Spread.MultiColumnComboBoxCellType();
        mcombo.DataSource = ds;
        mcombo.ColumnEditName = "氏名";
        mcombo.DataColumnName = "ID";
        mcombo.ShowButton = true;
        mcombo.ListWidth = 500;
        mcombo.ListAlignment = FarPoint.Web.Spread.Editor.ListAlignment.Right;
        mcombo.ColumnWidths = new int[] { 50, 100, 100, 100, 50, 60, 60, 100, 120 };
        mcombo.AutoFilter = new FarPoint.Web.Spread.AutoFilter
        {
            Enabled = true,
            MatchingSource = FarPoint.Web.Spread.FilterMatchingSource.AllColumns,
            MinPrefixLength = 1,
            MaxFilteredItem = 10
        };

        sheet.Cells[10, 3].CellType = mcombo;
        sheet.Cells[10, 3].Font.Size = FontUnit.Point(10);

        // タグクラウド型セルの設定
        FarPoint.Web.Spread.TagCloudCellType tagCloudCellType = new FarPoint.Web.Spread.TagCloudCellType();
        FarPoint.Web.Spread.Renderer.TagCloudItem tagCloudItem = new FarPoint.Web.Spread.Renderer.TagCloudItem(".net", 39, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=.net", "39 item(s) tagged");
        tagCloudCellType.TagCloudItems.Add(tagCloudItem);
        tagCloudItem = new FarPoint.Web.Spread.Renderer.TagCloudItem("ajax", 18, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=ajax", "18 item(s) tagged");
        tagCloudCellType.TagCloudItems.Add(tagCloudItem);
        tagCloudItem = new FarPoint.Web.Spread.Renderer.TagCloudItem("asp.net", 45, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=asp.net", "45 item(s) tagged");
        tagCloudCellType.TagCloudItems.Add(tagCloudItem);
        tagCloudItem = new FarPoint.Web.Spread.Renderer.TagCloudItem("c#", 85, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=c%23", "85 item(s) tagged");
        tagCloudCellType.TagCloudItems.Add(tagCloudItem);
        tagCloudItem = new FarPoint.Web.Spread.Renderer.TagCloudItem("css", 26, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=css", "26 item(s) tagged");
        tagCloudCellType.TagCloudItems.Add(tagCloudItem);
        tagCloudItem = new FarPoint.Web.Spread.Renderer.TagCloudItem("dhtml", 42, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=dhtml", "42 item(s) tagged");
        tagCloudCellType.TagCloudItems.Add(tagCloudItem);
        tagCloudItem = new FarPoint.Web.Spread.Renderer.TagCloudItem("excel", 34, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=excel", "34 item(s) tagged");
        tagCloudCellType.TagCloudItems.Add(tagCloudItem);
        tagCloudItem = new FarPoint.Web.Spread.Renderer.TagCloudItem("script", 19, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=script", "19 item(s) tagged");
        tagCloudCellType.TagCloudItems.Add(tagCloudItem);

        tagCloudCellType.RankingColors = new string[] { "black", "cyan", "green", "orange", "pink", "red", "purple" };
        tagCloudCellType.RankingFonts = new string[] { "Arial", "Century", "High Tower Text", "Georgia", "Onyx", "Batang", "Times new roman" };
        sheet.Cells[11, 3].CellType = tagCloudCellType;

    }
}

Partial Class celltype_basiccelltype
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If IsPostBack Then
            Return
        End If

        ' SPREAD初期化
        InitSpread(FpSpread1.Sheets(0))

        ' セル型の設定
        SetCellType(FpSpread1.Sheets(0))
    End Sub

    Private Sub InitSpread(ByVal sheet As FarPoint.Web.Spread.SheetView)
        ' SPREAD設定
        sheet.FpSpread.CommandBar.Visible = False
        sheet.FpSpread.CssClass = "spreadStyle"
        sheet.FpSpread.UseClipboard = False

        ' フォントサイズの設定
        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.Columns(0).BackColor = System.Drawing.Color.Silver
        sheet.Columns(2).BackColor = System.Drawing.Color.Silver

        ' シート設定
        sheet.RowCount = 12
        sheet.ColumnCount = 4
        sheet.PageSize = sheet.RowCount

        ' 列幅の設定
        sheet.Columns(0).Width = 100
        sheet.Columns(1).Width = 120
        sheet.Columns(2).Width = 180
        sheet.Columns(3).Width = 180

        sheet.Rows(5).Height = 60

        ' 縦方向の揃え位置を中央に設定
        sheet.DefaultStyle.VerticalAlign = VerticalAlign.Middle
    End Sub

    Private Sub SetCellType(ByVal sheet As FarPoint.Web.Spread.SheetView)
        ' 1列目のセルをロックしてユーザの編集を禁止
        sheet.Columns(0).HorizontalAlign = HorizontalAlign.Right
        sheet.Columns(0).Locked = True

        ' セル型の設定
        sheet.Cells(0, 0).Text = "整数"
        sheet.Cells(0, 1).Text = "123"

        sheet.Cells(1, 0).Text = "日付時刻"
        sheet.Cells(1, 1).Text = DateTime.Now.ToOADate().ToString()

        sheet.Cells(2, 0).Text = "倍精度"
        sheet.Cells(2, 1).Text = "123.45"

        sheet.Cells(3, 0).Text = "通貨"
        sheet.Cells(3, 1).Text = "12345.01"

        sheet.Cells(4, 0).Text = "テキスト"
        sheet.Cells(4, 1).Text = "テキスト"

        sheet.Cells(5, 0).Text = "マスク"
        sheet.Cells(5, 1).Text = "123-45-6789"

        sheet.Cells(6, 0).Text = "パーセント"
        sheet.Cells(6, 1).Text = "25%"

        ' 整数型セルの設定
        Dim fpcell As New FarPoint.Web.Spread.IntegerCellType()
        fpcell.ErrorMessage = "数値を入力してください。"
        fpcell.ShowPopupButton = True
        sheet.Cells(0, 1).CellType = fpcell

        ' 日付時刻型セルの設定
        Dim  dtcell As New FarPoint.Web.Spread.DateTimeCellType()
        dtcell.ShowPopupButton = true
        sheet.Cells(1, 1).CellType = dtcell

        ' 倍精度型セルの設定
        Dim dCell As New FarPoint.Web.Spread.DoubleCellType()
        dCell.ShowPopupButton = True
        sheet.Cells(2, 1).CellType = dCell

        ' 通貨型セルの設定
        Dim cCell As New FarPoint.Web.Spread.CurrencyCellType()
        cCell.ShowPopupButton = True
        sheet.Cells(3, 1).CellType = cCell

        ' マスク型セルの設定
        Dim rg As New FarPoint.Web.Spread.RegExpCellType()
        rg.ErrorMessage = "書式が異なります。例:123-45-6789"
        rg.ValidationExpression = "^\d{3}-\d{2}-\d{4}$"
        sheet.Cells(5, 1).CellType = rg

        ' パーセント型セルの設定
        Dim pCell As New FarPoint.Web.Spread.PercentCellType()
        pCell.ShowPopupButton = True
        sheet.Cells(6, 1).CellType = pCell

        ' 3列目のセルをロックしてユーザの編集を禁止
        sheet.Columns(2).HorizontalAlign = HorizontalAlign.Right
        sheet.Columns(2).Locked = True

        ' セル型の設定
        sheet.Cells(0, 2).Text = "ラベル"
        sheet.Cells(0, 3).Text = "Label"

        sheet.Cells(1, 2).Text = "ボタン(イメージ)"
        sheet.Cells(2, 2).Text = "ボタン(プッシュ)"
        sheet.Cells(3, 2).Text = "ボタン(リンク)"

        sheet.Cells(4, 2).Text = "イメージ"
        sheet.Cells(4, 3).Text = "ImageAlignプロパティでイメージとテキストの位置を調整可能です。"

        sheet.Cells(5, 2).Text = "リストボックス"
        sheet.Cells(5, 3).Text = "0"

        sheet.Cells(6, 2).Text = "チェックボックス"
        sheet.Cells(6, 3).Value = True

        sheet.Cells(7, 2).Text = "ラジオボタンリスト"
        sheet.Cells(7, 3).Text = "1"

        sheet.Cells(8, 2).Text = "ハイパーリンク"
        sheet.Cells(8, 3).Text = "GrapeCity Webサイト"

        sheet.Cells(9, 2).Text = "コンボボックス"
        sheet.Cells(9, 3).Text = "2"

        sheet.Cells(10, 2).Text = "マルチカラムコンボボックス"

        sheet.Cells(11, 2).Text = "タグクラウド型:"

        ' ラベル型セルの設定
        sheet.Cells(0, 3).CellType = New FarPoint.Web.Spread.LabelCellType()

        ' ボタン型セルの設定
        ' 画像ボタン
        sheet.Cells(1, 3).CellType = New FarPoint.Web.Spread.ButtonCellType("MyCommand", FarPoint.Web.Spread.ButtonType.ImageButton, "../images/music.gif")

        ' プッシュボタン
        sheet.Cells(2, 3).CellType = New FarPoint.Web.Spread.ButtonCellType("MyCommand", FarPoint.Web.Spread.ButtonType.PushButton, "クリック")

        ' リンクボタン
        sheet.Cells(3, 3).CellType = New FarPoint.Web.Spread.ButtonCellType("MyCommand", FarPoint.Web.Spread.ButtonType.LinkButton, "クリック")
        sheet.Cells(3, 3).HorizontalAlign = HorizontalAlign.Center

        ' イメージ型セルの設定
        sheet.Cells(4, 3).CellType = New FarPoint.Web.Spread.ImageCellType("../images/english.gif")

        ' リストボックス型セルの設定
        Dim lbcell As New FarPoint.Web.Spread.ListBoxCellType()
        lbcell.Items = New [String]() {"赤色", "緑色", "青色"}
        sheet.Cells(5, 3).CellType = lbcell

        ' チェックボックス型セルの設定
        Dim ch As New FarPoint.Web.Spread.CheckBoxCellType()
        ch.AutoPostBack = True
        ch.Text = "AutoPostBack"
        sheet.Cells(6, 3).CellType = ch

        ' ラジオボタンリスト型セルの設定
        sheet.Cells(7, 3).CellType = New FarPoint.Web.Spread.RadioButtonListCellType(New String() {"赤色", "緑色", "青色"}, New String() {"赤色", "緑色", "青色"})

        ' ハイパーリンク型セルの設定
        sheet.Cells(8, 3).CellType = New FarPoint.Web.Spread.HyperLinkCellType("http://www.grapecity.com/tools/")

        ' コンボボックス型セルの設定
        Dim cb As New FarPoint.Web.Spread.ComboBoxCellType(New String() {"赤色", "緑色", "青色"}, New String() {"赤色", "緑色", "青色"})
        cb.ShowButton = True
        sheet.Cells(9, 3).CellType = cb

        ' マルチカラムコンボボックス型セルの設定
        Dim ds As New System.Data.DataSet()
        ds.ReadXml(MapPath("../App_Data/data.xml"))
        Dim mcombo As New FarPoint.Web.Spread.MultiColumnComboBoxCellType()
        mcombo.DataSource = ds
        mcombo.ColumnEditName = "氏名"
        mcombo.DataColumnName = "ID"
        mcombo.ShowButton = True
        mcombo.ListWidth = 500
        mcombo.ListAlignment = FarPoint.Web.Spread.Editor.ListAlignment.Right
        mcombo.ColumnWidths = New Integer() {50, 100, 100, 100, 50, 60, _
         60, 100, 120}
        sheet.Cells(10, 3).CellType = mcombo
        sheet.Cells(10, 3).Font.Size = FontUnit.Point(10)
        mcombo.AutoFilter = New FarPoint.Web.Spread.AutoFilter()
        mcombo.AutoFilter.Enabled = True
        mcombo.AutoFilter.MatchingSource = FarPoint.Web.Spread.FilterMatchingSource.AllColumns
        mcombo.AutoFilter.MinPrefixLength = 1
        mcombo.AutoFilter.MaxFilteredItem = 10

        ' タグクラウド型セルの設定
        Dim tagCloudCellType As New FarPoint.Web.Spread.TagCloudCellType()
        Dim tagCloudItem As New FarPoint.Web.Spread.Renderer.TagCloudItem(".net", 39, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=.net", "39 item(s) tagged")
        tagCloudCellType.TagCloudItems.Add(tagCloudItem)
        tagCloudItem = New FarPoint.Web.Spread.Renderer.TagCloudItem("ajax", 18, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=ajax", "18 item(s) tagged")
        tagCloudCellType.TagCloudItems.Add(tagCloudItem)
        tagCloudItem = New FarPoint.Web.Spread.Renderer.TagCloudItem("asp.net", 45, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=asp.net", "45 item(s) tagged")
        tagCloudCellType.TagCloudItems.Add(tagCloudItem)
        tagCloudItem = New FarPoint.Web.Spread.Renderer.TagCloudItem("c#", 85, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=c%23", "85 item(s) tagged")
        tagCloudCellType.TagCloudItems.Add(tagCloudItem)
        tagCloudItem = New FarPoint.Web.Spread.Renderer.TagCloudItem("css", 26, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=css", "26 item(s) tagged")
        tagCloudCellType.TagCloudItems.Add(tagCloudItem)
        tagCloudItem = New FarPoint.Web.Spread.Renderer.TagCloudItem("dhtml", 42, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=dhtml", "42 item(s) tagged")
        tagCloudCellType.TagCloudItems.Add(tagCloudItem)
        tagCloudItem = New FarPoint.Web.Spread.Renderer.TagCloudItem("excel", 34, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=excel", "34 item(s) tagged")
        tagCloudCellType.TagCloudItems.Add(tagCloudItem)
        tagCloudItem = New FarPoint.Web.Spread.Renderer.TagCloudItem("script", 19, "http://msdn.microsoft.com/en-us/library/Tags-Cloud.aspx?tag=script", "19 item(s) tagged")
        tagCloudCellType.TagCloudItems.Add(tagCloudItem)

        tagCloudCellType.RankingColors = New String() {"black", "cyan", "green", "orange", "pink", "red", _
         "purple"}
        tagCloudCellType.RankingFonts = New String() {"Arial", "Century", "High Tower Text", "Georgia", "Onyx", "Batang", _
         "Times new roman"}
        sheet.Cells(11, 3).CellType = tagCloudCellType

    End Sub
End Class

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

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

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

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <FarPoint:FpSpread ID="FpSpread1" runat="server" BorderColor="#A0A0A0" BorderStyle="Solid"
        BorderWidth="1px">
        <CommandBar BackColor="#F6F6F6" ButtonFaceColor="Control" ButtonHighlightColor="ControlLightLight"
            ButtonShadowColor="ControlDark">
        </CommandBar>
        <Sheets>
            <FarPoint:SheetView SheetName="Sheet1">
            </FarPoint:SheetView>
        </Sheets>
    </FarPoint:FpSpread>
</asp:Content>