The XFGetCell function has 20 arguments, when you have a large sheet (e.g. for data validation) there can be many of these functions increasing the size of the excel file.
In SmartView it was possible to create 1 cell with commonly used arguments and reference that cell at once. In OneStream i'm not able to do so.
Off course i cannot imagine that SmartView has a feature that OneStream doesn't so i probably need to change my syntax a bit. Hope you guys can help.
So instead of:
=XFGetCell(TRUE, "Finance",$A274, "",F$4,F$14,F$5,F$2,$C274,$D274,F$3,$B274,F$6,F$7,F$8,F$9,F$10,F$11,F$12,F$13)
I want to create a cell (lets say A1) that has the content:
TRUE, "Finance",$A274, "",F$4,F$14,F$5,F$2,$C274,$D274,F$3,$B274,F$6,F$7,F$8,F$9,
So my formula would look like:
Unfortunately the function put double quotes around the cell so i get the whole string as my DisplayNoDataAsZero parameter and the next few down, missing many parameters (see picture below).
Solved! Go to Solution.
Hi Manish, we did not compare it 1 to 1 but have quite a large sheet which performs well so my current assumption is that there is no performance issue using this approach. Let me know if you find out differently.