sgcSpreadsheet Feature Matrix
Everything sgcSpreadsheet does, grouped by task. Every feature is in every sgcSpreadsheet license; there is no Community edition.
Everything sgcSpreadsheet does, grouped by task. Every feature is in every sgcSpreadsheet license; there is no Community edition.
6 features
211 functions
6 features
5 features
5 features
Delphi, C++ Builder and .NET
| Feature | Details |
|---|---|
| Typing as in Excel | A text that starts with = is a formula. Numbers, percentages such as 15%, dates, TRUE and FALSE are converted as Excel does, with the separators of the current locale. Anything else is text. |
| Forced text | A leading apostrophe stores the input as text: '=1+1, '007 and 'TRUE stay texts. The flag is kept through copy and paste, undo and XLSX files. |
| Formula bar and name box | TsgcVCLSpreadsheetFormulaBar and TsgcFMXSpreadsheetFormulaBar show the formula of the active cell. The name box shows the address of the selection and goes to an address such as D20 or Sheet2!A1. |
| Keyboard | F2 edits a cell, Enter, Tab and their Shift variants move, Ctrl+Enter writes and stays, Ctrl+Z and Ctrl+Y undo and redo. |
| Clipboard | Copy writes tab separated text with the formulas, quoted as Excel does, so it pastes into Excel and back. A single value pasted over a selection fills every selected cell. |
| Spreadsheet API | SetCellInput writes a cell as if it was typed, CellText and CellFormula read it, GoToAddress selects a cell or a range. Rows and columns are 0-based. |
211 built in functions with the names and the arguments of Excel.
| Category | Functions |
|---|---|
| Math and trigonometry | 49 |
| Statistical | 40 |
| Financial | 9 |
| Text | 31 |
| Date and time | 25 |
| Lookup and reference, XLOOKUP included | 17 |
| Logical | 11 |
| Information | 15 |
| Dynamic arrays, such as SEQUENCE, SORT, FILTER and UNIQUE | 14 |
| Feature | Details |
|---|---|
| Formula engine | The parser, the evaluator and the functions are part of sgcUICore, so sgcGrid formulas give the same results. |
| Dependency graph | The engine knows which cells read which, and a change recalculates only the cells that depend on it. |
| Dynamic arrays | A formula that returns an array spills into the cells next to it. A blocked spill range gives #SPILL!, and A1# refers to the whole spilled range. |
| Defined names | Names for ranges, constants and formulas, such as =SUM(Sales)*(1+Rate), with workbook or sheet scope. |
| References to other sheets | =Sheet2!A1 and =SUM('Sales 2026'!B:B). A renamed sheet is renamed in every formula that refers to it. |
| Custom functions | Functions registered by your application with sgcCalcRegisterFunction work in every formula like a built in function. |
| Feature | Details |
|---|---|
| Several sheets | Tabs under the grid switch the sheet and the + tab adds one. AddSheet, ActiveSheet and SheetCount from code. |
| Frozen panes | FreezePanes keeps the first rows and columns in place while the rest of the sheet scrolls. UnfreezePanes removes them. |
| XLSX load | LoadFromXLSX reads every sheet of a workbook with its formulas, formats, defined names, dynamic arrays, column widths, frozen panes and charts. |
| XLSX save | SaveToXLSX writes every sheet with values, formulas, cell formats, column widths, frozen panes and charts, in a file that Excel opens. |
| Streams | Load and save XLSX from a file or a stream. |
| Feature | Details |
|---|---|
| Charts from cell ranges | AddChart adds a chart of a range such as 'A1:D10' or 'Sheet1!A1:D10'. The chart reads the computed values of the cells. |
| 7 chart types | Column, bar, line, area, pie, doughnut and scatter, drawn by sgcCharts. |
| Live update | When a cell of the range changes, or a formula of the range gives a new value, the chart is built again. |
| Move and resize | Charts float over the sheet, like charts in Excel, and users move and resize them with the mouse. |
| Charts in XLSX | Charts are saved to XLSX as charts that Excel opens, and loaded back with the workbook. |
| Target | Components | Versions |
|---|---|---|
| VCL | TsgcVCLSpreadsheet, TsgcVCLSpreadsheetFormulaBar | Delphi 7 to 13, C++ Builder 2007 to 13 |
| FireMonkey | TsgcFMXSpreadsheet, TsgcFMXSpreadsheetFormulaBar | Delphi and C++ Builder XE6 and later |
| Charts | TsgcSpreadsheetCharts | VCL and FireMonkey |
| Dependencies | sgcGrid and sgcCharts | Installed with sgcSpreadsheet |
A C# port with the same class and member names. The packages are Registered only and are not published on nuget.org.
| Package | Edition | Contents |
|---|---|---|
esegece.sgcSpreadsheet | Registered | Spreadsheet model, charts and XLSX support. .NET Standard 2.0, .NET Framework 4.7.2, .NET 6, 8, 9 and 10 |
esegece.sgcSpreadsheet.WinForms | Registered | TsgcWinFormsSpreadsheet with its formula bar. .NET Framework 4.7.2, .NET 8, 9 and 10 on Windows |
esegece.sgcSpreadsheet.Wpf | Registered | TsgcWpfSpreadsheet with its formula bar. .NET Framework 4.7.2, .NET 8, 9 and 10 on Windows |
esegece.sgcSpreadsheet.Avalonia | Registered | TsgcAvaloniaSpreadsheet with its formula bar. .NET 8, 9 and 10 |
sgcSpreadsheet is documented in the sgcUI help, with one build for each development environment.
The complete sgcUI help as a PDF file, to read offline or print.
Delphi (PDF) →