Forum Discussion

SethB's avatar
SethB
New Contributor II
3 years ago

Help UsingScript functions and finding complete Excel Add-in documentation

Hi all, very new to OS and am having some issues using the XFGetCellUsingScript() function and UsingScript functions generally. Specifically, the GetCellUsingScript function can't seem to handle more...
Excel Add In
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

In terms of general tips, have a look at #3 in https://finit.com/blog/top-5-onestream-xf-function-tips-and-tricks/.

Also, if you're having trouble defining POVs, an alternative approach is to build a Quick View, then use the function "Convert to XFGetCells", which will do all the work for you; you can then copypaste that formula where you need it.

Look into https://onestream.thoughtindustries.com under Full Catalog; if you search for Excel, there are a lot of resources including demos. We also cover Excel functions as part of our Application Build for Administrators and Building Basic Reports courses - see the https://onestreamsoftware.com/training/ section of the main site.

If you think functions don't show the expected behaviour, by all means open a case with Support.