Limitations

Below are certain limitations that are applicable while using Google Sheets: 

• Google Sheets does not allow ribbon creation.
• Side pane and modal/modeless dialog are only allowed. The side pane will have a fixed width limit of 300px.
• The side pane allows you to view and select the tree for member selection. Only a flat list of member hierarchy and a single member selection from the dropdown list are supported while using cell-based member selection. 
• Drag and drop is not allowed from one cell to another.
• In Planful Spotlight, you can only open and view one report at a time in Google Sheets. The integration does not allow multiple Spotlight reports and views to be open simultaneously.
• When you refresh a workbook, only one Spotlight report will update with live data. The other reports will remain as static snapshots, displaying data from their initial generation.
• By default, the worksheet is named Report. If you change the worksheet name and reopen the same report, the changes will not be reflected. To ensure proper data refresh, the active tab where live data is displayed must be labeled as Report according to the naming convention.
• You cannot view or modify any formulas in the Report section on Google Sheets.