StructureSheet is a structured spreadsheet application backed by a strongly-typed SQLite database.
StructreSheet is not a database editor, rather it is intended to replace spreadsheets such as MS Excel in applications where users might not be careful with datatypes. For people who are aware of the pitfalls of MS Excel and meticulous about configuring it properly, StructreSheet provides no additional benefits.
I like KSP's naming scheme.
- Supports single tab - That's a single table with an arbitrary name "tab1" not exposed to the user.
- Display table contents
- Create INT columns with names
- Create new rows, from blank pseudo-row
- Add TEXT and VARCHAR columns
- Edit cell
- Delete row
- Add remaining column types
- Drag selection, cut/copy, paste to self
- Sort
- Filter
- Excel Export. No import! This is a deliberate feature for now, to be reconsidered after the 1.0 release.
- CSV import and export. The simpler CSV format can help ensure that there is no dataloss at the input stage, it is up to the user to ensure that the CSV contains all the data they wish to import.
- Column type "Richtext" with configurable parsing rules: Markdown, HTML, etc. Markdown is the default. Backed by TEXT, useful for e.g. a Notes column.
- Foreign keys
- Raw SQL queries
- Spell Check
- Pivot
- Support basic formulae, must be explicitely enabled on the cell. SUM, COUNT, IF (-then)
- Executable export. Export a database with the entire program to run it.
- Plots
- Import and sync databases
- More formulae
- Consider Excel import
- Drag selection, cut/copy, paste to [plain text,Excel,etc.]
- Python script support
- Plugins