Jedox Add-in for Excel 365 Release Notes
What's New
Optimizing Views interaction
- Option to enable Live changes when editing the View, eliminating the need for previews and displaying changes instantly
- Instant update of the View as soon as you click the Apply button
- Adding multiple dimensions from the source to the View sections (POV, rows, and columns) via the Select / Deselect visible elements option
Navigation improvements
- Centralized access to all features via the task pane
- Access the content of the POV dimensions directly from the worksheet with just one click
- Quick access to available Keyboard Shortcuts available in the Discover section
Bug fixes and performance improvements
Customizing Views in Excel 365
- Create New Views
- Edit Stored Views
- Save & Save as
Accessibility improvements
- Spreadsheet contrast improvements
- Add-in integration to the Excel keyboard navigation
- New keyboard shortcut Alt + Shift + E to expand / collapse when selecting a parent element cell within the View
Redesign of the Add-in Ribbon
Default integration of the https:// prefix to facilitate connection establishment
When creating or editing a connection, the prefix https:// is now added by default to all manually entered or copied Jedox server addresses.
Bug fixes and performance improvements
Static Views
Allows pasting Views on spreadsheets without PALO functions while preserving their known manipulation capabilities such as Splashing (data entry), expand / collapse, Zero Suppression, etc.
Expand / Collapse on rows and columns
By clicking on the dimension, the dimensions on rows or columns can be expanded / collapsed to show / hide underlying child elements. Note that this feature has been adapted to work with a single click, as the Office-JS add-in does not support double-click events.
View manipulations
- Zero Suppression
- Detach / Rebuild
Notifications
The "Notify" messages in the notification section of the task pane will provide user feedback on the spreadsheet interactions. For example, error messages appear when entering invalid splashing commands, formula modifications with invalid syntax, etc.
New available language
German is now available in the latest version.
Clearing cell content
Using keyboard shortcuts, a static View cell or a cell with a PALO.DATA formula can be replaced by the value "0" (zero) in a numeric cell or an empty string within a string cell, without deleting the existing formula.
Log in with SAML SSO
Once SAML has been enabled on your Jedox Cloud, users can now choose to log in to the Jedox Add-in for Excel 365 via SAML SSO.
Edit the POV (Point of View) Elements - Deprecated in version 2.3.0
You can manually edit the View's header dimensions, if you know the labels of the existing elements (string or number) within that dimension. The View automatically recognizes the element and retrieves the stored data according to the structure of the new View.
Known Issues for Jedox Add-in for Excel 365
New Jedox Add-in versions are regularly released through seamless updates as issues are fixed.
Platforms: Excel desktop, Web, and macOS
Platform | Description | Reported on |
|
54801 | Large Views with more than 5k cells might generate an error when detaching them, as the number of requests exceeds current JS API resources. Cell content shows #VALUE error. |
|
TOA-168 | Stored Views created with Jedox version 19.4 and earlier must be opened and saved in Jedox Web version 20.1 or later before they can be edited with the Jedox Add-in for Excel 365. |
|
TOI-220 | In Excel for desktop, all element names in Views that are interpreted as a number display a warning that a number is formatted as text. This warning has no effect and can be ignored. This is an issue from Microsoft and not from the Jedox Add-in. |
Known Issues for Office JS Add-ins
The following table contains the documented issues that have been reported to the Microsoft Office team, as they are not related to the Add-in but affect its functionality.
Platform | Description |
Excel Web | 5 MB limitation. The script requests on Excel Web (browser) are limited to 5 MB, which directly affects high resources request from the Add-in like:
|
Updated August 28, 2023