=SUM(A1:A9)
CellBasics
The Basic Works spreadsheet
What is CellBasics?
CellBasics is a native spreadsheet application for MorphOS. It handles everything from a quick table of numbers to a fully formatted workbook driven by Excel-compatible formulas — and it opens and saves your Excel and LibreOffice files as well as its own .cbx documents.
Features
- Excel-compatible formula engine with 370 functions — math, statistical, financial, engineering, text, date/time, logical and lookup — including LET and SUBTOTAL; see the formula reference
- Defined names and Excel tables with structured references, header and totals rows, banding and Excel's 60 built-in table styles
- Number, date and currency formats and formula separators for 20 locales, with function names in the locale's language as Excel has them
- XLSX workbooks open with the results Excel saved, so large files show at once;
TODAY()and friends still update - Excel number formats: up to four sections, colors, conditions and accounting alignment, with presets on the formatting bar
- Conditional formatting: formula, value, text, date, top/bottom, average and duplicate rules, color scales, data bars and icon sets
- Data validation with dropdown lists, input messages and error alerts
- Pictures over cells or placed in a cell, moved and resized with the mouse
- Hyperlinks and comments on cells
- Fonts, colors, borders, alignment, indent, wrapping, merged cells, and text that overflows into empty neighbors
- Hidden rows and columns, sheet tab colors, a hideable grid and a zoom per sheet
- Multi-column sorting, fill handles for series and formulas, and ranged insert/delete of cells
- Page setup per sheet — fit to page, scale, margins, print titles — with printing and PDF
- Undo and redo throughout the document
- Scriptable through an ARexx port of over 100 commands; see the ARexx reference
File formats
| Format | Open | Save / export |
|---|---|---|
| .cbx | Yes — CellBasics' own format; other .cbx documents can be appended | Yes |
| .xlsx | Yes — Excel workbooks, with styles, tables, conditional formats, validation, pictures, links, comments, names and page setup | Yes, with the same |
| .ods | Yes — LibreOffice and OpenOffice spreadsheets | Yes |
| .csv | Yes | Yes |
| — | Through the print dialog |