Spreadsheet or Excel Functions

Retrieve the status in reports. n spreadsheet or Excel, you can go to functions and select XFisFXRateLocked for your rate sheets.

  1. From the Application tab, go to Tools > Spreadsheet.

  2. Click the OneStream tab.

  3. Click the Insert Function button.

  4. In Category, click User Defined.

  5. In Select a function, click XFIsFxRateLocked.

  6. Click OK. The Function Arguments window opens.

  7. Enter a value in FxRateType.

  8. Enter a value in Time.

  9. Click OK. The spreadsheet will populate with the new data.

NOTE: If you change the lock or unlock rate types in the spreadsheet, when you Refresh the application and return to the Rates grid, the data will be updated to reflect your changes in the spreadsheet.