Forum Discussion

tkrekeler's avatar
tkrekeler
New Contributor III
2 years ago

XFGetCell pulling random number for blank excel rows when dragging formula

When trying to format the report and create a space between sections users are seeing random numbers pulled from the formula. The XFGetCell is referencing blank cells, but somehow is still pulling in...
Excel Add In
aricgresko's avatar
aricgresko
Contributor III
2 years ago

What's happening here is for any blank dimension in your XFGetCell string, OneStream will then reference your Cube POV for those missing dimensions.  Assuming one of those columns in your screen shot refers to the Entity or Account dimensions, you could put "None" as your Entity or Account member and it should return no data.