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