Skip to main content

Forms Library

Forms Library

The "Forms Library" feature allows the export and import of .json files to facilitate the management of grids connected to Essbase. It consists of two main parts:

1. File Import​

The export function allows you to save a grid connected to Essbase in .json format. Follow these steps :

    • Select a sheet containing a grid connected to Essbase.
    • Click on the "Download Form" button.
    • A .json file will then be downloaded locally to your device.

2. File Import​

The import function allows you to restore a grid, its formatting, and its connection to Essbase from a .json file. Follow these steps :

  1. Click on the "Upload and Import JSON" button.

  2. A window will open, allowing you to select a .json file from your device.

  3. Once the file is selected :

    • A new sheet is created in your workbook.
    • The data and formatting are automatically applied to the new sheet.
    • Merged cells are also recognized and applied to the new grid.
    • A refresh is performed to establish the connection with Essbase on the new grid.

Supported Formatting Details​

The exported and imported .json file retains the following elements :

  • Background : Cell background color.

  • Font color : Text color.

  • Font size : Text size.

  • Font styles : Text styles (e.g., italic, normal).

  • Font weights : Text weight (e.g., bold, normal).

  • Number formats : Number formatting.

  • Formulas : Cell formulas.

  • Merged cells : Configuration of merged cells in the grid.

Details of unsupported formatting​

  • Borders (thickness, color, and style of cell borders).

  • Text alignment (horizontal, vertical, indentation, text orientation).

  • Gradient fill (background color gradients).

  • Data validation (rules or restrictions applied to cells).

  • Hyperlinks (links inserted in cells).

  • Comments/Notes (annotations added to cells).

  • Cell protection (locking or hiding of cells).

  • Conditional formatting (formatting changes based on specific rules).

  • Inserted images or objects (graphics, shapes, icons in the sheet).

  • Column width and row height (custom dimensions).

  • ustom page breaks.

  • Specific date/time formats (differing from standard supported formats).

Key Points :​

  • The .json format preserves data, formatting settings, merged cells, and connection information.

  • The import function ensures an accurate restoration of the exported data.

  • Compatible with both Microsoft and Google environments.

This feature simplifies the management and sharing of connected grids while ensuring consistency of data, formulas, merged cells, and formatting.