01-12-2022 03:53 PM - last edited on 05-23-2023 10:42 AM by JackLacava
SOURCE: ONESTREAM CHAMPIONS
Hi Team,
I wish to know few features are possible in the Spreadsheet or not while using the Table View functionality.
there are some Enumerated fields stored in the table, say for example 0 or 1 (stored in the table) but I want the user to save it Yes / No in the spreadsheet - not sure how to achieve it?
Also to make sure that some other junk value should not get updated here, an Error Message should be popped up if the value is not per standard or some color code change.
How to make the cell - color filled for specific header columns - blue or so, indicating read-only cell.
How to format the numbers to 2 decimals.
Color Code change if the cell is dirty ( the same way it works for cube View )
Referred 1 document from OneStream Table View reference guide, which enabled to help to fetch the data in Spreadsheet using table view… but questions to above queries are not yet clear.
Hope team members here can share your experience, which we can re-use
Regards
Darpan Bhansali
01-12-2022 03:56 PM
Answers as numbered.
01-12-2022 03:56 PM
As relates to formatting, OneStream XF version 6.4.0 now has two new table view possibilities:
HeaderFormat
ColumnFormat
There are further details in the OneStream Academy video “Table Views Simplified Data Sources and Formatting”
01-12-2022 03:57 PM
Table Views Simplified Data Sources
unable to see it on one stream library…, please guide.
01-12-2022 03:58 PM
Table Views Simplified
Hello Darpan, please try the word search “Release Details”, can you see the section for the new release 6.4.0?
Another place to check is page 19 of the “Table Views User Guide.pdf” in the documentation package from the OneStream Marketplace (or within the full package)
01-12-2022 03:59 PM
Got it, thanks
we can close this loop as well.
Best Regards and Thanks
Darpan Bhansali
01-12-2022 03:57 PM
I believe on the 6.4 upgrade presentation the statement was videos would be posted by March 31, 2021.