Known Issues in Add-in for Excel 365

The Add-in for Excel 365 is updated regularly as issues are fixed.

The following table contains the open issues of the latest release. When an issue is fixed, it will be removed from the table.

Platforms: Excel desktop, Web, and macOS

Platform Description Reported on

Excel desktop

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.

All Excel 365 platforms

TOI-172 Once you enable and use the Add-in for Excel 365, Excel's Undo/Redo features will be disabled, preventing you from undoing or redoing actions on that workbook (including non-Jedox operations). Other workbooks on which the add-in has not been enabled are not affected. This is a Microsoft 365 limitation that does not only affect the Jedox Add-in, and we are evaluating alternatives to alleviate this issue.

All Excel 365 platforms

TOI-392 The Jedox data function PALO.SETDATA_BULK cannot be applied in the Add-in for Excel 365.

All Excel 365 platforms

TOI-439 The “Select all” functionality does not work correctly with global stored Subsets that contain different element levels and are sorted in the flat format.

All Excel 365 platforms

TOI-455 When conducting a search within the POV dimensions that are part of Lists used in rows or columns in the View, the search may return incorrect results. This issue only affects the dimensions included in the Lists.

All Excel 365 platforms

TOI-458 Views created with Dynatables can be pasted with the Add-in 365. However, some features, such as expand/collapse, may not work.

All Excel 365 platforms

TOI-459 The shortcut for clearing cell content (Ctrl/Cmd + Shift + Backspace) will not work if multiple cells are selected. It can only be used when a single cell is selected.

 

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

All Excel 365 platforms

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:
  • Pasting or splashing Views with 10K cells or more
  • Detaching Views with 5k cells or more
Web The add-in cannot be used if third-party cookies are blocked. Adjust the privacy and security settings of your browser.
Web The add-in cannot be used if the option to prevent cross-site tracking is enabled. Adjust the privacy and security settings of your browser.
Web The add-in cannot be used if multiple users log in to Microsoft 365 from the same browser.

Updated September 27, 2024