Limitations and restrictions

General

Office.js API behavior does not fully support working with multiple workbooks. When you, for example, switch between workbooks, you might experience some unexpected side-effects due to event handling. Also, if you use worksheets with names that contain spaces or special characters, some functions might not work as expected.

We recommend that you download Microsoft Office updates from the Monthly Enterprise Channel. If you update from the Semi-Annual Enterprise Channel, then you are unlikely to download the latest version and will not have access to the latest functionality of Excel Integration.

Do not use Excel Integration with another Office add-in installed. Additional Office add-ins can cause unexpected issues.

Writeback

These features and operations are not supported:

  • Using multiple-cell copy or paste operations for writeback.
  • Dragging values over cells that contain formulas with the INFOR.GET.VALUE function.
  • Writing back values in multiple non-contiguous cells.
  • Splashing undo.
  • Writeback that uses an MDX expression instead of the element unique name except for DefaultMember.
Note:  Especially when working with larger reports, you may experience small delays. To avoid errors, adjust the speed at which you enter data accordingly.

The JSON string that is used in the WritebackBehavior custom setting to enable or disable writeback mode is limited to 255 characters. You can compress JSON strings that contain more characters with JSON Minifier.

See https://codebeautify.org/jsonminifier.

Ad-hoc report

To enable all ad-hoc features to work correctly, you must use an Office version that supports Office.js API 1.12 or later. With older versions of Office, these limitations apply:

  • You can edit an ad-hoc report only if the report's top left cell (spillParent cell) with the INFOR.READ.SLICE function is selected, and if dynamic arrays are available.
  • If dynamic arrays are not available, only a single value is displayed. There is no spill of values over the cells in a report.
  • Expanding and collapsing do not work within a worksheet.
  • Dynamic selections do not work with Microsoft Analysis Services and with the Office Integration versions that are older than the 12.0.17 version.

If you update an ad-hoc report's structure but do not click Update report, then, if you cut and paste the report, your changes are lost.

Caution: 
If you convert an ad-hoc slice report that shows a #SPILL error, to a cell-based report, then the report's content is overwritten.

A cell-based ad-hoc report cannot contain more than 1.5 million cells. If this number is reached, you cannot convert the report from a slice to cell-based. You must adjust the report to do the conversion.

After you convert a report from a slice to cell-based, the slice formula is removed. You cannot undo this action.

Custom Functions

INFOR.WRITE.VALUE does not support Multidimensional Expressions (MDX) except for DefaultMember.

If writeback mode is disabled and you modify the INFOR.WRITE.VALUE function, a #VALUE! error is displayed.

Calculations from Application Studio in Self-Service report definitions

Self-Service report definitions that contain calculations imported from Application Studio are currently not supported in Excel Integration.

VBA limitations

If you use Office Integration custom functions in Excel VBA, be aware that custom functions are asynchronous and are calculated outside Excel. Therefore, some timing discrepancies can occur.

Some Excel VBA functions work only in Excel-native functions. For example, Application.Evaluate.

This list contains suggestions for using custom formulas in VBA:

  • When programming, ensure that custom functions have finished calculating.
  • Use the Application.CalculateFullRebuild function rather than the Application.Calculate function. Application.CalculateFullRebuild marks all cells that contain formulas as not calculated and triggers the rebuilding and recalculation of all dependencies. The calculation process can be longer than expected because it rebuilds dependencies and then calculates all workbooks.
  • Insert custom formulas into =IF statements in an Excel workbook and reference a cell with a TRUE or FALSE function. This is an alternative to using the Application.CalculateFullRebuild function and enables you to select which custom function to calculate at a specific time. This results in a faster calculation process.