Changelog


v2.0.7 - 17.11.2023

  • feature: added VBA functions API
  • feature: update to .NET 8.0

v2.0.5 - 06.11.2023

  • fix: bugs fixed

v2.0.4 - 01.11.2023

  • fix: bugs fixed

v2.0.1 - 30.10.2023

  • breaking change: CubeWeaver 2 has a new Worksheet concept. Cubes (multidimensional arrays) and Worksheets (2D view on the cubes) have been separated into two different concepts. Access rights are granted on worksheets instead of cubes now. All cube shares will be lost after upgrade. Former view objects will be automatically converted to new worksheets. Please make a backup of your model before upgrading to CubeWeaver 2.
  • breaking change: The slow ad-hoc aggregation feature has been removed. The same effect can be achieved by combining multiple cubes in a worksheet.
  • breaking change: The system does not enforce a single measure dimension any more. Measure filter dialog has been removed. A list of measures displayed in a worksheet can be controlled via the "Items" field of the corresponding worksheet axis.
  • feature: A brand new Worksheet concept. Worksheets are 2D views on multidimensional cubes. A single worksheet can combine data from multiple cubes.
  • feature: Cell styles: cell appearence (color, font, alignment, borders, width) can be customized using style rules and worksheet style settings.
  • feature: A new navigation concept to support models with lots of objects. List, cubes and worksheets are displayed in a tree view on the left side of the screen.

v1.8.10 - 10.04.2023

  • feature: Added fixed range list item references (like 'List A':(33:57))
  • fix: bugs fixed

v1.8.6 - 04.12.2022

  • feature: update to .NET 7.0
  • fix: fixed minor bugs

v1.8.5 - 10.08.2022

  • feature: added the import_denorm function to import denormalized data
  • feature: adjusted denormalized export format to make it reimportable
  • fix: fixed minor bugs

v1.8.2 - 28.04.2022

  • feature: CubeWeaver is free for small teams as long as you use it inside your organization
  • fix: fixed minor ui bugs

v1.7.5 - 22.11.2021

  • feature: update to .NET 6.0 and Angular 12.
  • feature: export_items and export_values functions.
  • feature: simplified formatbutton syntax.

v1.7.4 - 08.11.2021

  • feature: two computation algorithms are now available to choose from (via FileModel settings):
    • Spreadsheet (topological sorting) is the new algorithm which is very fast for small models. It will be used by default for new models.
    • Multidimensional (brute force) is the original algorithm which is best suited for large models. Models created before v1.7.4 will use this algorithm by default.

v1.7.3 - 16.10.2021

  • feature: a new data import system: support for direct data import from Excel and CSV files, relational databases (with an ADO.NET driver), REST services and any other sources via custom functions.
  • feature: scriptable import jobs based on formulas and buttons.
  • breaking change: the old buggy import dialog was removed in favor of the formula-based import functionality.

v1.7.2 - 21.08.2021

  • feature: automatic conversion of list item values to numbers and texts in formulas (no need to use the value('List A') syntax any more).
  • feature: added support for DML operations via buttons and some basic DML functions like list_build_relation and list_set_attr.

v1.7.1 - 15.08.2021

  • feature: improved support for string (text) values inside formulas. Formulas can now produce text results.
  • feature: cell data type (number, date, text, ...) is now stored along with the value. Data type is preserved when cells are copied using formulas.
  • breaking change: this version applies a backward incompatible update to the database schema. Please backup your local repository before upgrading.
  • fix: fixed multiple bugs

v1.6.10 - 16.07.2021

  • feature: optional delete flag column for CSV import
  • fix: fixed CSV import for desktop installation
  • fix: fixes for saved views

v1.6.4 - 21.03.2021

  • feature: removed the Worksheet > Measures menu item. Measures can now be activated/deactivated from the measures list screen directly.
  • fix: performance improvements for slow connections

v1.6.1 - 05.03.2021

  • breaking change: seq_* and each_* functions were removed. Please use the new map, filter and zip functions instead.
  • feature: new functions for working with ranges: map_cells, map_values, filter_cells, filter_values, filter_by_range, zip_values
  • feature: redesigned the list screen
  • feature: a new "cross join" list item auto-generation option
  • feature: customizable appearance for the cell buttons
  • feature: improved docs
  • fix: performance improvements for models with large (10k+ items) dimensions

v1.5.1 - 11.02.2021

  • breaking change: the software version number semantic has been changed. The first digit has been dropped. The last digit is the build number. v1.5.1.xxx corresponds to v1.1.5.1 from the previous sequence.
  • breaking change: this version applies a backward incompatible update to the database schema. The .CWA export files are still backward compatible. You can go back by exporting your model if you have to.
  • feature: trace precedents & dependents via the context menu
  • feature: desktop edition final release with a signed installer

v1.1.3.1 - 02.01.2021

  • feature: improved formula validation: formulas which become inactive (f.e. when a measure is removed) will be marked invalid. A formula error report will list invalid formulas (if any).
  • feature: redesigned the model sharing screen
  • feature: desktop edition (experimental)

v1.1.2.1 - 22.12.2020

  • feature: worksheet views can be saved (Worksheet → Save current view as...) and opened in a popup window
  • feature: added the 'Syncronize filters between worksheets' option to lists
  • fix: performance improvements

v1.1.1.5 - 15.12.2020

  • feature: improved .XLSX export

v1.1.1.1 - 11.12.2020

  • breaking change: removed destinction between IDs and captions from worksheets and lists. Both object types have only IDs now. Worksheet and list IDs are not case-sensitive and can contain any symbols. Ids with spaces and other special symbols must be quoted in formulas (f.e. 'Sheet 3'.['List A':10]). Existing repositories will be upgraded automatically (the caption will become the new id). This change has been introduced to improve formula readability.
  • feature: improved .XLSX export

v1.1.0.1 - 03.12.2020

  • breaking change: switched to Excel number formatting syntax. Please update your custom cell formatting.
  • breaking change: removed automatic sum computation (Excel compatibility). Use sum([A:all()]) instead of [A:all()]. The latter one will produce an error if more than one cell is returned.
  • feature: export of the whole model including the formulas and formatting to an .XLSX file (still beta)

v1.0.4.3 - 13.11.2020

  • feature: SSL support for Windows

v1.0.4.1 - 12.11.2020

  • feature: update to .NET 5.0
  • feature: less files in the app folder
  • feature: executable renamed to CubeWeaver.exe

v1.0.3.1 - 29.10.2020

  • feature: look and feel update with new icons and other UI improvements
  • feature: cell colors (foreground and background)
  • feature: formula comments with /**/
  • feature: optimized .cwa export format for smaller size (backward compatible)
  • fix: fixed bugs with non updating cell visibility states and incorrect dropdown behavior

v1.0.2.4 - 18.10.2020

  • feature: added lots of standard financial and mathematical spreadsheet functions

v1.0.2.3 - 16.10.2020

  • fix: fixed dependency resolution for user defined functions

v1.0.2.1 - 11.10.2020

  • feature: added the 'offset' cell reference function
  • feature: improved formula error validation
  • fix: computation engine optimizations

v1.0.1.6 - 09.10.2020

  • feature: comments for user defined functions
  • fix: last open worksheet is now saved properly
  • fix: several minor bugs fixed

v1.0.1.4 - 07.10.2020

  • feature: user defined functions
  • fix: bugs fixed

v1.0.1.3 - 27.08.2020

  • feature: HTML as a new export format (accessible from Excel)
  • feature: improved worksheet export/import API
  • fix: fixed several import/export bugs

v1.0.0.8 - 03.08.2020

  • feature: worksheet export/import API
  • fix: minor bug fixed

v1.0.0.7 - 26.07.2020

  • fix: bugs fixed

v1.0.0.6 - 16.07.2020

  • feature: downloadable on-premise version released
  • fix: improved error messages
  • fix: bugs fixed

v1.0.0.5 - 11.06.2020

  • fix: bugs fixed

v1.0.0.4 - 04.06.2020

  • fix: bugs fixed

v1.0.0.3 - 30.05.2020

  • fix: tree UI fixed
  • fix: bugs fixed

v1.0.0.2 - 20.05.2020

  • feature: improved CSV import
  • fix: bugs fixed

v1.0.0.1 - 04.05.2020

  • feature: initial public release