Version History
Changes and fixes across CellBasics and PageBasics releases. Both ship together in the Basic Works archive.
CellBasics
-
1.0
Basic Works
- UI cosmetics and touchups
-
0.61
- XLSX import shows the results Excel saved in the file instead of recalculating everything on open; TODAY() and friends still update
- An .xlsx, .ods or .csv file given as the document to open is imported rather than reported as corrupt
- Document > Open... opens CBX, XLSX, ODS and CSV files, and so do Recent Files; the Import submenu is gone
- Select menu: Table, Row and Column
- XLSX import keeps styled empty cells, row and column styles, error cells, shared formulas and escaped characters
- Imports show a progress window, and import errors are reported
- Opening and saving a CBX document shows its progress too; saving runs in the background, and the document window waits while a document opens
- CSV, XLSX and ODS exports show their progress, can be cancelled, and report errors
- Large workbooks import about twice as fast, recalculate in a single pass and use a third of the memory they used to
- Implemented LET, SUBTOTAL, unary + and @ in formulas, and Excel's xlfn. function prefixes on import and export
- Implemented Excel tables: structured references, header and totals rows, banding, Excel's 60 built-in table styles and a workbook's own, kept as tables in CBX and XLSX
- Table menu: Format as Table, Table Properties... (name, style chooser with a preview, header and totals row, banding, first and last column, resize to selection) and Convert Table to Range
- Implemented Excel number formats: up to four sections, colors, conditions, accounting alignment and text sections
- The formatting bar offers Excel's number format presets or takes a typed format code
- Text overflows into empty neighboring cells, also while typing. Cells no longer wrap by default; documents saved with older versions keep their wrapping
- Implemented indent (toolbar buttons and cell context menu)
- Implemented hidden rows and columns: Table > Hide Rows, Hide Columns and Unhide Rows and Columns
- A sheet can hide its grid (Table > Show Grid)
- Row heights set in Excel are kept exactly
- Sheet tab colors; Sheet > Properties... sets the name and the tab color
- A workbook opens on the sheet it was left on, and each sheet keeps its zoom
- Implemented conditional formatting: formula, cell value, text, date, top/bottom, above/below average, duplicate and unique rules, color scales, data bars and icon sets. Table > Conditional Formatting... makes and manages rules
- Implemented data validation: dropdown lists, input messages and error alerts. Table > Data Validation... and Clear Validation
- Pictures: shown from XLSX, added with Insert > Picture..., moved and resized with the mouse, deleted with Delete; the context menu sets how they move with cells, Lock Aspect Ratio and Alternative Text
- Implemented Excel's Place in Cell pictures, from the picture's context menu and back with Place Image Over Cells
- Hyperlinks and comments: a red marker on commented cells, a box beside the active cell, a click on a link's text follows it. Edit > Link and Comment... and Remove Link and Comment
- Right-clicking a comment or input message box opens a menu to edit it
- Implemented defined names in formulas, conditional formats and validation lists. Table > Names... manages them
- Page setup is kept per sheet: fit to page, scale, margins, paper, print titles and centering. Print dialog changes can be undone
- XLSX export writes cell styles, number formats, merges, hidden rows and columns, column widths, tab colors, tables, conditional formats, data validation, pictures, links, comments, names and page setup
- Conditional formats, validations, names, tables, print titles and pictures move with inserted and deleted rows, columns and cells
- Unknown functions and names show #NAME? as in Excel
- Links to other workbooks keep the value saved in the file
- A formula's text result stays text, even when it looks like a number
- Inserting or deleting rows and columns moves $-anchored references too
- Fixed SUMIF(S), COUNTIF(S) and AVERAGEIF(S) criteria, ranges on other sheets and blank cells
- Fixed LARGE, SMALL, PERCENTILE, QUARTILE, RANK and about 20 other functions reading only the first cell of their range
- Fixed R16 being read as row 16 rather than a cell in column R
- Fixed SUM and AVERAGE counting text in referenced cells
- Fixed a one pixel line left on screen when a large object was removed
- Fixed CBX documents losing their cell fonts, and all but one side of their cell borders, when opened
- Fixed Save in the "Save changes before proceeding?" requester not saving a document that had never been saved
- Table Properties and Convert Table to Range work with a range selected
- ODS import and export keep number formats, borders, comments, links, names, hidden rows and columns, and the results saved in the file; text stays text, and LibreOffice reads our formulas' sheets, LET and names
- Fixed a crash importing an ODS sheet of more than 1000 cells, and one exporting CSV from a sheet of more than 250 cells
- The EXPORT rexx command writes .xlsx, .ods or .csv by the file's extension
- Added following rexx commands: EXPORT, FORMULA, INDENT, SETINDENT, GETINDENT, HIDEROWS, HIDECOLUMNS, UNHIDE, SHOWGRID, GETGRID, GETROWHEIGHT, GETCOLUMNWIDTH, NUMBERFORMAT, GETNUMBERFORMAT, SHEETCOLOR, GETSHEETCOLOR, SETNAME, DELETENAME, GETNAME, SETLINK, SETCOMMENT, CLEARNOTE, GETLINK, GETCOMMENT, SETVALIDATION, CLEARVALIDATION, GETVALIDATION, SETRULE, DELETERULE, MOVERULE, CLEARRULES, GETRULES, GETCONDITIONAL, PAGESETUP, GETPAGESETUP, FORMATASTABLE, SETTABLE, GETTABLE, CONVERTTABLE, INSERTPICTURE, DELETEPICTURE, MOVEPICTURE, SETPICTUREANCHOR, GETPICTURES, PLACEINCELL, PLACEOVERCELLS, GETCELLPICTURE
-
0.60
- ODS import and export
- Implemented document append functionality (CBX only)
- Fixed frame colors popup menu
- Added links to online documentation to the menu
- Fixed inter-sheet references not working after some operations/load
- Optimized loading of documents with multiple sheets
-
0.59
- Printing and PDF support
- Deduplicates formula objects to improve performance and reduce ram use
- Improved ram usage when importing very large documents
- Worked around an issue that'd sometimes save broken CBX files
- Improved XLSX import and export
-
0.58
- Fixed incorrectly computed selection bounds in the right-top to left-bottom selection case
- Fixed built-in color selection
-
0.57
Initial release
- First public release
PageBasics
-
1.0
Basic Works
- UI cosmetics and touchups
- RTF support
-
0.51
First release
- Spun off CellBasics's Text Editor
- Uses DOCX as its default storage format