Excel Add-in for IPT

INFINFO() function

This function will be extended in the future by other functionalities.

For now, this function allows to:

  • retrieve the current version of used.

  • test if the user has the proper entitlement for a given feed.

Function syntax

INFINFO(option_to_test, feed_to_test)

Test  version

=INFINFO("AddinVersion")

Using the id "AddinVersion", this function will display the version number of the current used and all it's components.

InfInfo_AddinVersion.png

Test feed entitlement

=INFINFO("FeedPermission","LSE")

Using the id "FeedPermission" completed with a given feed to test, this function will return if the user has the proper entitlement to use it or not.

InfInfo_Permission.png

You can also extends this function by using cell references.

InfInfo_Permission_Table.png