03-02-2022 09:45 AM
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:
XFGetCell($A$1, F$10,F$11,F$12,F$13)
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.
03-02-2022 10:25 AM
Hi Marc,
I think you are looking for the @XFGetCellUsingScript formula. See print screen below. My formula is picking up the Cube in B1, the POV from B2, entity in A11 and time in C8.
Peter
03-02-2022 10:25 AM
Hi Marc,
I think you are looking for the @XFGetCellUsingScript formula. See print screen below. My formula is picking up the Cube in B1, the POV from B2, entity in A11 and time in C8.
Peter
03-02-2022 10:40 AM
Hi Peter, that was exactly what i needed! Thanks.
Do you know if there is a performance impact of using this function versus a regular XFGetCell?
03-02-2022 10:44 AM
Sorry Marc!
I do not know what the performance impact are on these 2 different approaches.
Peter
06-29-2022 08:54 AM
06-29-2022 09:01 AM
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.