The PivotTable Field Settings were not handled correctly in certain constellations. As a result, the Excel workbook was corrupted and the following message appeared when opening the workbook:
We found a problem with some content in '...xlsx'. Do you want us to try to recover as much as we can?
Version 24.2.5.0
as of Business Central 24 2024/06/26
Improvements
The action Translate all Excel Functions has been added to the Excel Report Builder Setup page.
The action can be used to translate the Excel Function names in the Formulas of all evaluations into English Excel Function names after upgrading the old NC Cube version to Business Central.
For more information, see Setup, Excel Report Builder Setup.
Any control characters in the data are now automatically replaced by spaces.
User related filters are no longer deleted when a superordinated table is added.
Corrections
When executing an evaluation with several data sheets, the filters from the different data sheets were not grouped correctly.
For more information, see Execute Evaluations, Evaluation Filters.
Version 21.2.2.0
as of Business Central 21 2024/02/02
Improvements
Fields of type DateTime are now also formatted as DateTime in Excel if automatic formatting is selected for the field. The DateTime Accuracy field can be used to set whether only the minutes or also the seconds should be transferred to Excel.
For more information, see Edit Evaluations, Data Sheets, Field Settings.
The Create Notifications option in the Archive Excel Evaluation action caused an error if multiple users had added the evaluation to the My Excel Evaluations list and the action was scheduled.
For more information, see Execute Evaluations, Archive Excel Evaluation.
The behavior of some pages and changing some field values has been optimized.
Version 21.1.11.0
as of Business Central 21 2023/03/23
Improvements
Since there were several requests regarding the PivotTable option Classical PivotTable Layout, the option has been included in the NCE Excel Builder. The option can be set in the Sheet Settings of the PivotTable. Die Option kann in den Blatteinstellungen der PivotTable gesetzt werden.
For more information, see Edit Evaluations, PivotTable Sheets, PivotTable.
The input area for the formulas has been enlarged. The smaller input area can optionally be activated via the Small Formula Input Area field in the NCE Excel Evaluation Setup.
For more information, see Setup, Excel Report Builder Setup.
When changing a Formula ID in a datasheet, all formulas in which the ID is used as a :COL or :ROW Formula ID are now also changed or updated.
The NCE Excel Evaluation Card page and the NCE Execute Excel Evaluation and NCE Archive Excel Evaluation actions now additionally display the first comment line if there are comments for the evaluation.
Modifications
The Comment field in the Evaluation Archive has been renamed to Archive Comment.
Version 21.1.10.1
as of Business Central 21 2023/02/24
Modifications
The behavior of some pages and changing some field values has been optimized.
1:n relationships did not produce results in certain constellations.
Scheduling an evaluation aborted with the following error message:
"The permission settings of the evaluation do not allow you to execute the evaluation."
The Field Settings page has been revised.
In addition, the Fill Color and the Font Color can now be specified here for each field.
For more information, see Edit Evaluations, Data Sheets, Field Settings.
The Text Settings page has been revised.
In addition, the Fill Color and the Font Color can now be specified here for each field.
For more information, see Edit Evaluations, Data Sheets, Text Settings.
NCE Excel Evaluations can now be very easily integrated or called from other extensions via the NCE Connector codeunit.
For more information, see Information for Developers, Connector.
as of Business Central 21Important Update 2022/11/17
Modifications
The NCE Excel Builder engine has been optimized based on the Excel row no. check added in version NCE 21.1.6.0.
Version 21.1.7.1
as of Business Central 21 2022/11/02
Quality of Life Update
Improvements
On the Formula page in the Datasheet, the Formula Help action has been added.
The action displays an overview of all Excel Functions and Formula IDs used in the current formula.
The caption of the PivotTable Field Settings page now displays the name of the field.
Version 21.1.6.0
as of Business Central 21Important Update 2022/10/24
Important
For On-Premises an update of the License or the following granules is required:
70171825 Excel Report Builder by NAVAX
1010860 Extension Base by NAVAX
Business Central Update
Improvements
In order to ensure that only Codeunits that were also created for the NCE Excel Builder can be executed via the Codeunit to Run setting, they must now be additionally included or unlocked via an EventSubscriber.
For more information, see Information for Developers, Runnable Codeunits.
In the Data Sheet, Temporary Data Codeunits can now be added.
With the help of temporary data codeunits, evaluations can be extended with functions that temporarily calculate certain data of the evaluation during execution.
For more information, see Edit Evaluations, Data Sheets, Table Settings.
A Filter ID can now be specified for the filter in the Filters and Relations area of the Table Settings.
This ID can then be used to reference or access the filter value in other filters.
For more information, see Edit Evaluations, Data Sheets, Table Settings.
If a connection between Business Central and OneDrive exists, the actions Open in OneDrive and Share are now additionally available for the evaluations.
For more information, see Execute Evaluations, Execute Excel Evaluation.
The input of date filters has been improved.
Data Sheets can now be copied into themselves.
The options of the Add action in the Data Sheet have been optimized for long table names.
When deleting an Excel Evaluation, an additional confirmation dialog is now displayed if archive entries exist for the evaluation.
When executing the evaluation, the record counter now displays the total number of records in addition to the number of top records already passed.
Modifications
PivotTable value fields which are not based on a numeric field are now formatted as Default.
The Excel row no. was not determined correctly in certain constellations or was assigned twice. As a result, the Excel workbook was corrupted and the following message appeared when opening the workbook:
We found a problem with some content in '...xlsx'. Do you want us to try to recover as much as we can?
The error has been fixed and the row no. is now additionally checked when the evaluation is executed.
as of Business Central 20Important Update 2022/07/12
Improvements
When creating a new evaluation, a Data Sheet is now also automatically suggested.
When adding fields to a table, they are now inserted before any child tables.
If the same table is subordinated to the table once again (e.g.: Customer > Customer), this is suggested as a 1:1 relationship with the primary key fields as a filter.
When selecting the "Related fields between table and parent table" option of the Suggest Filter and Relations action in the Table Settings, you can now select for which parent table the related fields should be suggested, if there are several parent tables.
New Formula IDs[TOTALVALUE] - Will be replaced by the sum of the field values of all records in the case of a numeric (Decimal, Integer, BigInteger) field.
[TOTALRECORDS] - Will be replaced by the number of all records.
[RECORDNO] - Will be replaced by a sequential number for the current record.
For more information, see Edit Evaluations, Data Sheets, Formulas.
If no evaluations have been created yet, you will be asked whether the Download Area should be opened when you open the evaluation overview.
The NCE Excel Builder now uses Business Central's Partial Records technology for a further performance boost.
Modifications
The Preview with sample data option is now set to No by default for all calls.
Corrections
For the fields of a field relation (Field 🞥) data from the previous record was displayed for records without a field value.
The action Translate Formula did not work correctly in certain constellations. ROUND became ROAND, for example.
The Translate Formula action now also recognizes function names written in lowercase letters.
Added Codeunit to Run setting to the NCE Excel Evaluation Card page.
Here you can specify a codeunit to run when the evaluation is executed.
For more information, see Edit Evaluations, General, Edit Excel Evaluation.
Adding additional filter fields in the NCE Excel Evaluation Filters page when running an evaluation was not possible under certain constellations.
Version 19.1.1.0
as of Business Central 19 2022/03/28
Improvements
New Formula IDs[PERIOD_TEXT] - Will be replaced by the current period (e.g. 2022/03 March) of a (parent) Date Loop.
[PERIOD_DATE] - Will be replaced by the current period (e.g. 03/01/22..03/31/22) of a (parent) Date Loop.
For more information, see Edit Evaluations, Data Sheets, Formulas.
The Preview in the Download Area is now no longer opened in a separate browser window, but directly in Business Central.
Corrections
When date fields were added to an evaluation, an error message occurred when the evaluation was executed for records with empty date values.
Version 19.1.0.0
as of Business Central 19 2022/03/08
Improvements
The default value is now suggested again in the default style fields of the Excel Evaluation Setup if the value is deleted.
For more information, see Setup, Excel Report Builder Setup.
When changing a Formula ID in a datasheet, all formulas in which the ID is used can now optionally be changed or updated as well.
For more information, see Edit Evaluations, Data Sheets, Formulas.
Improvements & Modifications compared to previous NAV versions
The name of the extension has been changed from NC Cube to NCE Excel Builder.
To execute an evaluation or create an Excel workbook, Excel is no longer required and therefore does not need to be installed.
However, in order for a user to open and view a created Excel workbook, a corresponding program must be installed.
Recommended is Excel 2016 or a newer version.
Alternatively, you can use Excel 2013, Excel 2010, Excel 2007, OpenOffice, Office on an Android device, or Office on an iPhone or iPad.
It is now possible to have several data sources in an evaluation.
Excel Evaluations can now also be scheduled.
When the Excel workbook is ready, a message appears in the Report Inbox from where the Excel workbook can be opened.
The archiving of an Excel Evaluation can now also be scheduled.
When archiving has been performed, a message appears in the Report Inbox.
The archived evaluation can then be opened directly via the Report Inbox or via the NCE Excel Evaluation Archive.
It is now possible to format the data independent of the visualization and therefore also independent of language, region and country settings.
When a user opens the workbook, the data is automatically displayed in the format he or she has set.
Instead of the term Object, the term Sheet is now used.
Instead of the term JOIN, terms like Parent / Child Table and Related with are now used.
Parallel tree structures are now possible.
Tables can be related to each other over several levels.
FlowFilter loops became obsolete with the new relation capabilities.
A field can now be added more than once as a PivotTable value field.
Excel Templates are no longer supported.
Charts are no longer supported.
Cell Comments, Link/Page Link and "Output only if" (Data Sheet) are also no longer supported.
Note
It is possible to import old NC Cube files (file name extension .nccx) via the import action.
For more information, see Appendix, Import old NC Cube files.
Release Notes
