Skip to content
SumOfficeSumOfficeSumOffice

SumSheet version history

What was added, changed, and fixed in SumSheet from version to version.

Each line below is a change visible in the product itself. Versions run from newest to oldest.

The top entry can be ahead of what’s actually deployed: the changelog grows as the release comes together, and deployment is a separate step. Which version is available right now is shown in the release catalog, linked from the installation page.

The version number is made up of the year, the quarter, and the patch number within the quarter: in 2026.3.4, that’s the fourth patch to the third-quarter 2026 release. The patch count restarts every quarter, so 2026.3.19 is followed by 2026.4.0, not 2026.3.20.

Downloadable filenames add one more part to the number — a running build number, for example 2026.3.4.25. It doesn’t affect version comparison and exists to distinguish files of the same version built at different times. Release candidates and test builds carry a suffix: 2026.4.0-rc1, 2026.4.0-beta1.

The application checks the installed version against what the update channel offers, and prompts you to update when a newer one comes out. You can check manually with the “Check for Updates…” menu item.

Total releases: 61, counted from the 2023.2 quarter.

Added

  • A bridge to external applications: passing and returning arrays, including multidimensional and byte arrays; addressing an already-running application, a file, and an object by name; a full error code table; an empty reference as an argument.
  • Real-time data: a refresh cycle and a source manager that keeps a pool of servers by name and hands out topic subscriptions. Works only on Windows: the source connects through the system’s own mechanism, and it isn’t installed at all in the macOS and Linux builds. There, the RTD formula returns #N/A — the same as on Windows with no source server running.
  • A long operation now announces itself to the person in the status bar.
  • Macros: the sheet type is now reported accurately, and named ranges are read both by number and by name.

Changed

  • Grid sharpness no longer depends on zoom.
  • The “General” format is now limited to fifteen significant digits, as in Excel.

Fixed

  • The protected view banner now pushes the ribbon down instead of covering the content.
  • Template workbooks now carry the declared style table.
  • Old workbooks are now read more tolerantly of damaged sections.

Added

  • Objects embedded in the workbook: parsing, extracting content, the packaged file’s original name, and returning attachment edits back into the workbook.

Fixed

  • A duplicated object no longer disappears on save.
  • “Format Painter” and the sort dialog now respond to Escape.
  • The ribbon menu now hands off control to the “Format Cells” dialog.

Added

  • Parsing macro user forms: control labels and values, radio button groups, and the hierarchy of frames and multi-page controls.
  • Carrying formats over from the clipboard through the core.
  • Dynamic arrays: spill range boundaries are now closed.

Fixed

  • Canvas gestures are now measured from the canvas, not from the window frame.
  • The first readable frame no longer passes itself off as the finished grid.
  • The “d-mmm” date format is back in the format list.

Added

  • The workbook now opens in two steps: the visible part first, then the rest.

Changed

  • The workbook’s date system is honored during calculation, on open, and on save; sheet functions compute using the workbook’s own date system.
  • Macros: the formatting function was rewritten piece by piece — parentheses, fractional parts, the scaling comma.

Fixed

  • Data validation rules in tables are now saved in the workbook.
  • The crash recovery dialog now belongs to its own document.

Added

  • Macros: selecting a subset of an array, building an array from values, and looping through an array element by element.
  • The computation core now ships as part of the same release in two builds: a regular one and a browser one.

Changed

  • The string comparison mode declared in a module now affects comparisons.
  • Macros that Excel wouldn’t compile no longer run.

Fixed

  • In lookup functions, a mode given by a cell reference no longer gets overridden.
  • An ascending search now compares text case-insensitively, as in Excel.
  • The Linux package no longer conflicts with SumDoc on the same machine.

Added

  • Macros: Excel’s enumerations are now wired up in full — over two thousand named constants.
  • Password-protecting a sheet, “interface-only” mode, and the list of allowed actions.
  • Navigating to an address with positional arguments.

Changed

  • Sorting large amounts of text now computes faster.
  • Reading a boolean value no longer allocates a string on every access.

Fixed

  • Comparing a string with a boolean value from a cell no longer produces a type error.

Added

  • Macros: class modules — declaring the type, public fields as members, creating an object; line numbers; external procedure declarations and events; the pattern-comparison operator; date and time functions.
  • Sheet functions are now available to macros from a shared list — 366 names.

Fixed

  • The table filter is back to matching Excel’s behavior.
  • The formula builder opens again.
  • The canvas image is now stable when zooming.

Added

  • Macros: splitting and joining strings, extracting from the left, right, and middle, trimming spaces, finding a substring, replacing, and converting a number to text.
  • The message box now actually shows up.
  • Running a macro from the product now opens an execution session; a running macro can be stopped, rolled back, and queried for status.
  • Writing to a multi-area range now reaches every area.

Changed

  • Scrolling large workbooks now reuses projections that are already built.

Fixed

  • The threshold for switching to exponential number notation now matches Excel.
  • The square root of a negative number now gives the same error as Excel.
  • The used range now accounts for any formatted empty cell.

Added

  • The data analysis package: smoothing, rank and percentile, Fourier transform, random number generation, sampling.
  • Scenarios: loading and merging data that lives outside the sheet.
  • Macros: a preview shows what a macro will change in the workbook before it runs; a macro’s result can be committed to the file; a macro doesn’t reach beyond the workbook without a declared permission.

Fixed

  • Saving a workbook to bytes no longer locks it out of a later save.
  • Sorting again now keeps the undo and redo order intact.

Added

  • The build number next to the version number.

Added

  • The portable Windows archive is back under a clear name.

Changed

  • Release notes are now just a human summary in Russian.

Fixed

  • The “Data Tools” and “Text to Columns” buttons are now available the same way as in Excel.
  • A malformed formula is now refused instead of accepted silently.
  • A failure while building the release notes no longer stops the release itself.

Added

  • Advanced filter.
  • Removing duplicates and data validation moved into the core; the table’s total row and calculated columns now match Excel’s behavior.
  • Creating graphic objects in an open workbook.
  • The package signature is now verified on the target system before installation; the macOS package for centralized deployment is notarized on par with the disk image.

Fixed

  • The advanced filter no longer turns on the autofilter arrows.
  • The filter popup now addresses its own column.
  • The filter range now covers the whole data area, not just one column.
  • “Reapply” stays available for as long as the filter is in effect.
  • The theme catalog now ships in the package and loads in the installed application.
  • Internal translation keys are no longer shown to the person.

Added

  • Macros: sheet functions and match lookups now respond through a shared source; reading sheet properties through a typed variable.

Changed

  • The version shown inside the application no longer carries a candidate tag.

Fixed

  • “Clear Filter” stays active as long as the list has unchecked boxes.
  • One gesture in the value list now performs one action.
  • Interacting with pivot tables is back to matching Excel’s behavior.
  • The update installer now launches through the system’s own tools.
  • The “Formulas” tab: visual glitches and focus-transition bugs are fixed.

Added

  • The “Check for Updates…” menu item now responds to the person.
  • Macros: inserting cells, rows, and columns with a shift.

Fixed

  • The filter value list no longer closes after every checkbox and after toggling auto-apply.
  • The filter menu now has one shared chevron instead of three different ones.
  • The “About” dialog now names the system accurately.
  • The filter arrow in the header is now a thin chevron.

Added

  • Automatic updates on Windows and Linux.
  • The update storage address is now set by a setting; on failure, the download retries, with loop protection and a minimum-version threshold.

Fixed

  • Applying a filter no longer removes the arrows from other columns.
  • Auto-apply has moved next to the buttons and no longer looks like a filter value.
  • The advanced filter button no longer spills past its group’s boundary.

Added

  • The sort dialog now matches Excel: headers, buttons, “oldest to newest” options for dates, and sorting left to right.
  • The product’s windows now have their own frame with real buttons, including maximize to full screen.

Changed

  • The “Data” tab now matches the design.

Fixed

  • Sorting left to right now actually reorders the columns.
  • The sort dialog now shows the column that’s selected in it, and offers the correct order options for dates.
  • The sort warning no longer appears on a column with formulas.
  • The alphabet letters on the sort icons are now translated.
  • A dragged window now stays on screen.
  • The “Filter” button now draws arrows in the headers.
  • Macros: an invalid font size is now refused as a value; combining ranges is now accepted; a multi-area selection now acts on every area.

Added

  • Rolling back an update if the new version failed to start.

Fixed

  • The application no longer writes inside its own package — that used to break the signature.

Changed

  • The line’s first service update.

The first release of the line. Below is what the product entered it with.

Added

  • Opening and saving XLSX workbooks.
  • The computation core: dependency-based recalculation, and partial recalculation of only what changed.
  • The formula language: arithmetic, references, and ranges; sums, averages, counts, minimum and maximum; date and time; text functions — length, extraction, search, replace, concatenation, case; value type checking; powers, roots, rounding, logarithms, trigonometry; statistics; looking up values in a table.
  • Processing and aggregating data with a query.
  • Working with data: sorting, filtering, data validation, removing duplicates, text to columns, pivot tables.
  • The function library, the formula builder, and formula auditing.
  • Macros: a dedicated engine runs procedures, class modules, custom types, enumerations, conditional compilation, and jumps; the workbook, sheet, and range object model; sheet and workbook protection; the clipboard; named ranges; selecting whole rows and columns; deleting rows with a shift; the print area.
  • Automatic application updates on macOS.

Changed

  • The workbook is held in memory sparsely: empty areas of the sheet take up no space, and a file with hundreds of thousands of rows opens without unfolding the whole grid.

Fixed

  • Scrolling to the far edge of the sheet no longer recalculates the whole sheet.

Added

  • Assessing a workbook’s compatibility before opening: which of the file’s features are fully supported, and which only partially.

Changed

  • Recalculation now touches only dependent cells, not the whole sheet.

Added

  • Sheet and workbook protection: locked cells now refuse an edit with a clear refusal.

Added

  • Automation as a transaction: a sequence of operations applies as a whole, or not at all.

Added

  • Parsing VBA macros and reporting which constructs are supported.

Changed

  • External data connections never run without the host’s explicit permission.

Fixed

  • Undo and redo for range operations now record as a single history entry, not per cell.

Added

  • A WebAssembly build: the same formula computation in the browser, with no separate JavaScript engine.

Added

  • Service mode: processing workbooks on the server, headless.

Changed

  • The boundary between the host and the core is described by a single typed operations contract.

Added

  • Data window: only the sheet’s visible part is returned to the host, not the whole workbook.

Added

  • A persistent workbook session: the state lives between calls.

Added

  • An undo-and-redo history on the core’s side, shared across every way of editing.

Changed

  • A sheet is now addressed by a stable key, not a name: renaming a sheet no longer breaks references.

Fixed

  • Saving a workbook no longer loses computed formula values for programs that read them without recalculating.

Added

  • Pivot tables: building, refreshing, and saving.

Added

  • Charts: reading from the workbook, displaying, and writing back.

Fixed

  • A chart’s range now survives inserting and deleting rows.

Added

  • Conditional formatting by value and by formula.

Added

  • Sorting and filters by column, including filtering by color.

Added

  • Named ranges and using them in formulas.

Changed

  • Formula errors now return as an error code, not an empty value.

Fixed

  • A reference to another sheet no longer breaks when a formula is copied.

Added

  • Number formats: dates, percentages, currency, thousands separators.

Added

  • Merging cells, wrapping text, and cell alignment.

Fixed

  • Column width and row height are now saved exactly, not rounded.

Fixed

  • Repeated spaces inside a cell no longer collapse.

Added

  • Writing XLSX: the assembled workbook opens in third-party programs.

Changed

  • Parts of the workbook the editor doesn’t understand are preserved unchanged and written back to the file.

Changed

  • The workbook is written to a temporary file and replaces the original in a single action.

Added

  • Cell editing: entering values, text, and formulas.

Added

  • Selecting a range with the mouse and keyboard.

Fixed

  • Entering a number with a comma is recognized based on the interface language.

Added

  • Computing formulas with references to cells and ranges, and detecting circular references.

Added

  • The first set of built-in functions: arithmetic, sums, conditionals.

Added

  • Displaying the grid with row and column headers, scrolling through a large sheet.

Changed

  • Cell values are stored with types: number, text, date, boolean, error.

Added

  • Reading several sheets of one workbook and switching between them.

Added

  • Displaying the workbook’s content while preserving the sheet structure.

Changed

  • Parsing the workbook is now moved into the Rust core.

Added

  • Reading XLSX: package parts, shared strings, cell values.

The earliest builds shipped under a different kind of number and went out as alpha — for demonstration, not for production use. There’s no separate changelog for them: back then, the product changed faster than versions were released.

Documentation assistant

Answers are assembled from the documentation and may be inaccurate — check the sources.