SharpCell.Grid

API reference

Every public type of the SharpCell.Grid packages. Each page lists the type's members with their C# declarations.

SharpCell.Grid

Type Summary
BorderEdges Which edges of an area's cells a border goes on, as in Excel's Borders menu.
CellArea A rectangle of cells, from its top-left to its bottom-right cell; rows and columns from 1.
CellPosition A cell of the sheet by 1-based row and column, such as the active cell.
FormulaPointing Picking references with the mouse while a formula is typed, as in Excel: where the caret takes one, and how a picked cell or range is written.
GridClipboard What copying cells puts on the clipboard, in the forms Excel reads when it pastes, and the cells of text pasted from it.
GridColor An opaque or translucent sRGB colour.
GridDash The dash pattern of a line, after Excel's border styles.
GridEdit A change made through a GridEditor.
GridEditor Changes a workbook as people change it in Excel: typing into cells, Delete, pasting text copied from Excel, copying and moving cells, the fill handle, inserting and deleting rows and columns, column widths and row heights.
GridFont A font to draw text with; the size is in pixels, not points.
GridHit What is under a point of the grid.
GridNavigation How the active cell moves on a sheet, as in Excel: a merged area counts as one cell.
GridPainter Paints a worksheet the way Excel shows it: column and row headers, gridlines, each cell's Cell.Text in its style (font, fill, borders, alignment, wrapping, indent), merged areas as one cell, and the active cell.
GridPart The parts of a grid a point can fall on.
GridRect A rectangle in device-independent pixels.
GridSelection The selected cells, as in Excel: a rectangle of cells and the active cell inside it.
GridTextAlignment Where text sits across its bounds.
GridTheme The colours of a grid.
GridVerticalAlignment Where text sits from top to bottom of its bounds.
GridViewport What part of the sheet a grid shows: the scroll offset into the sheet and the size of the whole grid on screen, headers included.
IGridCanvas What GridPainter paints on.
SheetLayout Where the cells of a sheet are, in device-independent pixels from the top-left corner of cell A1: column widths, row heights, their offsets, the cell under a point and the cells inside a viewport.

SharpCell.Grid.Avalonia

Type Summary
FormulaBar Excel's formula bar for a SpreadsheetView: the name box with the active cell's address, and the active cell's formula or value as Excel shows it to edit.
SheetTabs Excel's sheet tabs for a SpreadsheetView: a tab for each sheet of the view's workbook, the shown one highlighted.
SpreadsheetView Shows a SharpCell worksheet as Excel does: headers, gridlines, each cell's text as Excel formats it in the cell's style, the sheet's column widths, row heights, merged cells, frozen panes and gridlines.

SharpCell.Grid.Wpf

Type Summary
FormulaBar Excel's formula bar for a SpreadsheetView: the name box with the active cell's address, and the active cell's formula or value as Excel shows it to edit.
SheetTabs Excel's sheet tabs for a SpreadsheetView: a tab for each sheet of the view's workbook, the shown one highlighted.
SpreadsheetView Shows a SharpCell worksheet as Excel does: headers, gridlines, each cell's text as Excel formats it in the cell's style, the sheet's column widths, row heights, merged cells, frozen panes and gridlines.