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

セル型

標準セル型の他に17種類のセル型を提供しています。 表示データの形式にあわせてセル型を自由に選べます。
 ABCD
1整数123ラベルLabel
2日付時刻2024/11/21ボタン(イメージ)
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>