What are the supported Excel functions in offline forms?


How do I know which Excel functions are supported in TRIRIGA offline forms? TRIRIGA offline forms have a dependency on underlying software to do the following: (1) Read from Excel, in the case of incoming offline forms and the “Distill” workflow task, (2) Write to Excel, in the case of outgoing offline forms and the “Populate” workflow task. Prior to TRIRIGA 3.2.x, the JXL (JExcelApi) library was used. Starting in TRIRIGA 3.2.x, the Apache POI library began being used.

To see which Excel functions are supported, or not supported, or need to be utilized in alternate ways in order for Apache POI and TRIRIGA to understand them in supported versions of TRIRIGA, refer to the following wiki page: IBM TRIRIGA Offlining Supported Excel Functions.

[Admin: This post is related to the 06.28.16 post about requiring Excel, the 12.03.15 post about supported Excel functions, and the 09.16.15 post about the distill process failing with certain Excel functions.]

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s