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.]