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 File → Model 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)