The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

suresh_klarna's avatar
suresh_klarna
New Contributor III
6 months ago
Solved

XFGetCell() + XFGetCell() gives incorrect result

statement 1: gives zero which is correct

=VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "F99", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))

statement 2 : gives value which is correct

=VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "FNONE", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))

statement 3: gives incorrect value

=VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "F99", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))+VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "FNONE", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))

This works correctly in 8.4, but not after upgrading to 9.1

Excel Add In
  • suresh_klarna's avatar
    suresh_klarna
    6 months ago

    OneStream confirms that it is a bug in version 9.1 and it is resolved in version 9.2 
    The issue is with spreadsheeet within OneStream. 

1 Reply

  • suresh_klarna's avatar
    suresh_klarna
    New Contributor III
    6 months ago

    OneStream confirms that it is a bug in version 9.1 and it is resolved in version 9.2 
    The issue is with spreadsheeet within OneStream.