Spread WPF 14
Spread WPF Documentation / Developer's Guide / Customizing the Appearance / Allowing Cell Overflow
In This Topic
    Allowing Cell Overflow
    In This Topic

    You can determine how the contents of a cell overflows into adjoining cells. If you allow cell contents to overflow:

    Data only overflows if the adjacent cell is empty. Merged cells do not display the overflow.

    Spreadsheet showing cell overlflow to the left, left and right, and to the right.

    Using Code

    The following example allows text to overflow to the left, left and right, and to the right with the CanCellOverflow property.

    Copy Code
    gcSpreadSheet1.CanCellOverflow = true;
    gcSpreadSheet1.Sheets[0].Cells[1, 2].Value = "Data overflows to the left";
    gcSpreadSheet1.Sheets[0].Cells[1, 2].HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Right;
    gcSpreadSheet1.Sheets[0].Cells[2, 2].Value = "Data overflows to the left and right";
    gcSpreadSheet1.Sheets[0].Cells[2, 2].HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Center;
    gcSpreadSheet1.Sheets[0].Cells[3, 2].Value = "Data overflows to the right";
    gcSpreadSheet1.Sheets[0].Cells[3, 2].HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Left;
    Copy Code
    GcSpreadSheet1.CanCellOverflow = True
    GcSpreadSheet1.Sheets(0).Cells(1, 2).Value = "Data overflows to the left"
    GcSpreadSheet1.Sheets(0).Cells(1, 2).HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Right
    GcSpreadSheet1.Sheets(0).Cells(2, 2).Value = "Data overflows to the left and right"
    GcSpreadSheet1.Sheets(0).Cells(2, 2).HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Center
    GcSpreadSheet1.Sheets(0).Cells(3, 2).Value = "Data overflows to the right"
    GcSpreadSheet1.Sheets(0).Cells(3, 2).HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Left
    See Also