Built-in Cell Types

Cells in ReoGrid can hold cell body, cell body is an interface that shows customized content in cell, interacts with user input. Customized cell body class must inherited from CellBody or implemented from ICellBody interface. For more about cell body, see Custom Cell.

The following built-in types of cell body are available:

Class Name	Sample	Description
ButtonCell		General button.
HyperlinkCell		Hyperlink that can navigate to specified URL automatically.
CheckBoxCell		Check box that toggles the cell data between .NET Boolean value true and false.
RadioButtonCell		Radio button that toggles the cell data between true and false, radio buttons in same group can toggle each other.
DropDownListCell		Drop-down cell that provides a candidates list and makes user choose a single item as cell data.
ProgressCell		Progress cell that displays a progress bar in cell according to the cell data 0~1.
NegativeProgressCell		Negative progress cell that can display positive and negative progress bar according to the cell data 0~1.
Image		Image cell that displays an image in cell.
ImageButton		Image button that displays an image on button in cell.
DatePickerCell		Date picker cell that allow user choose date from a drop-down calendar.

To use built-in cell types, the below namespace is necessary.

using unvell.ReoGrid.CellTypes;

Button

Class ButtonCell represents a button control on worksheet.

sheet[1,2] = new ButtonCell("Hello");

Cell body always uses cell’s data as its label, following code also works:

sheet[1,2] = new ButtonCell();
sheet[1,2] = "Hello";

var button = new ButtonCell("Hello");
button.Click += (s, e) => MessageBox.Show("Button clicked");

Perform Click

It is possible to use method PerformClick to simulate a click event, for example:

button.PerformClick();

Change Button Text Color

By changing the cell style it is possible to change the color of button label, for example, the following code changes button label to blue.

var cell = sheet.Cells["C3"];
cell.Style.TextColor = Color.Blue;

var button = new ButtonCell("Hello");
cell.Body = button;

Result:

Hyperlink

Hyperlink uses cell’s data as its navigate URL.

sheet[1,2] = new HyperlinkCell("http://www.google.com");

or

sheet[1,2] = new HyperlinkCell();
sheet[1,2] = "http://www.google.com";

sheet[1,2] = new HyperlinkCell("http://www.google.com/", true);

var link = new HyperlinkCell("http://myurl.com", false);
link.Click += (s, e) => { doMyEventHandler(); };

link.PerformClick();

Check Box

CheckBoxCell class represents a check box on worksheet, but it doesn’t provide the label to be displayed on worksheet. Usually it is necessary to put the label before or after the check box cell, like the following image:

CheckBoxCell checkboxCell;

// add check box and a text label
sheet["C1"] = new object[] { checkboxCell = new CheckBoxCell(), "Auto destroy after 5 minutes." };

Get and Set Check Status

Directly set the cell’s data using boolean value to check and uncheck the check box, or using the property IsChecked to get the check status.

// check
sheet[1, 2] = true;

// uncheck
sheet[1, 2] = false;

// get check status from worksheet
bool isChecked = (sheet["C1"] as bool?) ?? false;

// get or set check status from check box
bool isChecked = checkboxCell.IsChecked;

Click and CheckChanged event

Click event raised when user clicked on check box. Click event don’t fire when user pressed Space key inside cell.

checkboxCell.Click += (s, e) => { doEventHandler(); };

CheckChanged event raised when user changed the check-box status by mouse or keyboard.

checkboxCell.CheckChanged += (s, e) => { doEventHandler(); };

CellDataChanged event

Since check box cell updates cell’s data as bool value. When the check-box status changed, CellDataChanged event will also be raised.

sheet.CellDataChanged += (s, e) =>
{
  if (e.Cell.Position == new CellPosition("C1"))
  {
    MessageBox.Show("Check box status changed: " + e.Cell.Data);
  }
};

Custom Drawing for Check box

To customize the appearance instead of the built-in one for check box cell, override the OnContentPaint method, the following code draws the check box using checked and unchecked images.

class MyCheckBox : CheckBoxCell {
  Image checkedImage, uncheckedImage;

  public MyCheckBox() {
    checkedImage = Image.FromFile(@"...");
    uncheckedImage = Image.FromFile(@"...");
  }

  protected override void OnContentPaint(CellDrawingContext dc) {
    if (this.IsChecked) {
      dc.Graphics.DrawImage(checkedImage, this.ContentBounds);
    } else {
      dc.Graphics.DrawImage(uncheckedImage, this.ContentBounds);
    }
  }
}

Result:

Radio

Class RadioButtonCell represents radio button on worksheet, it inherits from CheckBoxCell class, so that the usage of radio button cell almost same as the check box.

To add a radio button, use following code:

var radio = new RadioButtonCell();
sheet["C3"] = radio;

Radio Group

RadioButtonCell added into RadioGroup or specified by using its RadioGroup property will make radio buttons in the same group toggle each other automatically.

var radioGroup = new RadioButtonGroup();
sheet[10, 2] = new object[,] {
  {new RadioButtonCell() { RadioGroup = radioGroup }, "Apple"},
  {new RadioButtonCell() { RadioGroup = radioGroup }, "Orange"},
  {new RadioButtonCell() { RadioGroup = radioGroup }, "Banana"}
};

radio.Click += (s, e) => doEventHandler();

radioGroup.RadioButtons.ForEach(rb => rb.CheckChanged += (s, e) =>
  ShowText(sheet, "Radio button selected: " + sheet[rb.Cell.Row, rb.Cell.Column + 1]));

Drop-down List

Drop-down list cell represented by class DropdownListCell.

Code to add a drop-down list cell on worksheet:

var dropdown = new DropdownListCell(
  "Apple", "Orange", "Banana", "Pear", 
  "Pumpkin", "Cherry", "Coconut"
);
sheet["B2"] = dropdown;

Event of drop-down list cell

The event SelectedItemChanged of drop-down list cell used to get selected item from drop-down panel.

dropdown.SelectedItemChanged += (s, e) => { ... };

Same as check box cell, drop-down list cell also updates data of cell, it is possible to get selected item by handling CellDataChanged event:

sheet.CellDataChanged += (s, e) => { ... };

Custom Drop-down

From v0.8.8, the drop-down cell could be customize, it is possible to put Windows Form-compatible controls into the drop-down panel.

See how to create custom drop-down cell.

Image

Code to add image cell:

var image = Image.FromFile("...");
sheet[2, 6] = new ImageCell(image);

View Mode of Image Cell

ImageCell has property named ViewMode which is used to decided how to show the image inside a cell:

// create ImageCell by specifying the view-mode
var imgCell = new ImageCell(img, ImageCellViewMode.Zoom);
sheet["F6"] = imgCell;

// or change the property directly
imgCell.ViewMode = ImageCellViewMode.Clip;

Alignments

Horizontal and vertical alignment style of cell can be used to decide where to show the image:

var cell = sheet.Cells["F6"];
cell.Style.HAlign = ReoGridHorAlign.Center;
cell.Style.VAlign = ReoGridVerAlign.Middle;

 From 0.8.9 version, ReoGrid supports floating image on worksheet like Excel, learn more about Floating Image.

Image Button Cell

Code to create an image button at cell C3:

sheet["C3"] = new ImageButtonCell(Image.FromFile(@"C:\Users\dujid\Downloads\Save-32.png"));

Result:

Date Picker

Some advanced built-in cell types are provided by ReoGrid Pro-edition, such as Date Picker Cell.

To create an own date picker cell using free-edition ReoGrid, see how to create date picker cell.

Adjusting size for cell body

The size of cell body is decided by its parent cell with a padding style value, it is also possible to make cell larger by merging multiple cells.

Windows Form and WPF edition

From version 1.2, ReoGrid supports a part of cell types in WPF edition as the following.

Demo project for built-in cell types

Windows From edition (version 0.9):

WPF edition (version 1.2):

Demo Project

The demo projects of both Windows Form and WPF edition contained in the download release package. Download the package and extract the demo project archives for getting source code and executable files of demo projects.

See Also

• Custom Cell
  • Cells type for entire column
• Drop-down List Cell
• Floating Objects
  • Floating Image
• Walkthrough
  • Create Custom Drop-down Cell
  • Create Date Picker Cell