Add-in for Excel 365 Release Notes

New features

• Apply Drillthrough in Views
• Insert stored Subset(s) into a View
• Insert Lists into a View
• Create an OLAP Snapshot of the selected sheet or the entire workbook
• Choose between PALO.DATAC, PALO.SETDATA, or PALO.SETDATAIF for the Insert Data Function command
• Enable or disable the automatic Add-in initialization

Made the experimental feature "Click area" GA

Enhanced the search functionality

Optimized the "Edit View" interface

Fixed the Known Issues TOI-427 and TOI-428 and removed them from the article

Fixed bugs and improved performance

Renamed the add-in to "Jedox Add-in" to distinguish it from the (on-prem) Excel Add-in

Synchronized the Jedox Add-in with your Microsoft 365 account, making its configuration settings available across all Excel platforms (desktop, web, macOS)

New features

• Added new connection and login dialog
• Added search functionality for the selection of elements within a dimension
• Improved context menu for the element selection options, e.g. expand all elements, or select only base or consolidated elements of a branch

Replaced the experimental feature "Report buttons" with "Click area"

Fixed bugs and improved performance

New features

• Introducing "Report buttons" as the first experimental feature
• Keep Only

Support for Virtual Dimensions in Views

New ribbon design to support dark mode

Bug fixes and performance improvements

Data update from the In-Memory DB on demand

• Update Workbook (Ctrl/Cmd + Shift + F10)

Bug fixes, performance, interaction, and notification improvements

Custom Report capabilities

• Insert Elements
• Insert Data Function
• Guess arguments

Quick access to your favorite Views

• Pin Stored Views 

Data update from the In-Memory DB on demand

• Update Sheet

New available language

French is now available in the latest version.

Bug fixes and performance improvements

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.