Skip to main content
S
suresh_klarna
December 15, 2025
Solved

XFGetCell() + XFGetCell() gives incorrect result

  • December 15, 2025
  • 1 reply
  • 0 views

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

    Best answer by suresh_klarna

    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

    S
    suresh_klarnaAuthorAnswer
    December 16, 2025

    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. 

    Terms & ConditionsAccessibility statement