Skip to main content
The spreadsheet is an extension, not part of core Atoti UI. Plugging it adds:
  • the New spreadsheet item of the Insert menu, which creates a spreadsheet page,
  • the Pivot table v2, Table v2 and Tree table v2 widgets.
The extension is published to the atoti-ui-spreadsheet-generic-release repository of our Artifactory. To get access to this repository, contact your account manager.
Authentication to Artifactory is required to follow the link above. Otherwise, it may look broken or unavailable.

​
Download the extension

Log into Artifactory as described in Set up. When you have access to the atoti-ui-spreadsheet-generic-release repository, download the build of the extension from it: atoti-ui-spreadsheet-extension-{atotiUIVersion}.zip. Use the version matching the version of your Atoti UI. The archive contains a single spreadsheet-extension folder, holding the built extension and its entry file, extensionEntry.js.

​
In a Java project

Make sure your project includes the Atoti UI Spring Boot starter.
  1. Extract the archive, and move the spreadsheet-extension folder to resources/static/atoti-ui/extensions/@activeviam/spreadsheet-extension.
  2. Create or edit the file at resources/static/atoti-ui/extensions.json, and add the following entry to it:
  3. Rebuild your project, then run it.
  4. Clear your browser cache and refresh the page, for instance by pressing Ctrl + F5.
The Insert menu of a dashboard now shows New spreadsheet.

​
In a standalone Atoti UI

  1. Extract the archive, and move the spreadsheet-extension folder to extensions/@activeviam/spreadsheet-extension, at the root of your Atoti UI folder.
  2. Open the file named extensions.json at the root of your Atoti UI folder, and add the entry mentioned in the paragraph above to it.
  3. Start your server if it is not already running.
  4. Clear your browser cache and refresh the page.
For more details on plugging an extension into an Atoti UI build, see plug an extension.

​
Order of the extensions

Atoti UI activates the extensions in the order of extensions.json. The v2 table widgets copy the context menu of their standard counterparts when the spreadsheet extension is activated. Register the extensions that add items to the context menu of table widgets, such as your own custom menu items, before the spreadsheet extension. Otherwise, the v2 table widgets do not show these items.

​
Troubleshooting

To check that the extension is registered, open a dashboard and open the Insert menu of the application header. It contains the item New spreadsheet when the extension is registered. If it does not, open the developer tools of your browser:
  • In the Console tab, look for an error about the extension, such as “Could not activate extension “@activeviam/spreadsheet-extension"". This class of errors is caused by the extension failing to register. This may be for instance because the application menu does not contain the Insert submenu, with the key insert-submenu, to which the extension attempts to add New spreadsheet.
  • In the Network tab, reload the page and select the request to extensions.json. Check that its response contains the entry of the spreadsheet extension. If it does not, the extensions.json file of your deployment was probably not updated, or your browser serves a cached version of it. In the latter case, clear your browser cache and reload the page.
  • In the Network tab, check that the request to extensionEntry.js under extensions/@activeviam/spreadsheet-extension succeeds. A failed request means that the folder of the extension is not where extensions.json points.