Maintain/Define value formatting in rollforward chain
已回答Hi team,
I am using chains to rollforward historical data. Below is the screenshot of my chain.
The rollforward works fine but I am facing issue with the formatting of the text. It seems the Write Sheet command sets the formatting to ones. Is there any way to avoid this or any other additional steps I can add to my chain to define the format of the cells to millions or date (year)
Snapshot of the Spreadsheet data after rollforward.
-
Hello Krishma Gupta,
As mentioned in other posts related to Spreadsheets the formatting is not an option when copying data between spreadsheets currently. The Write Sheet Data only stores the data not the format of the data.
At the time of writing this response the ability of formatted values is being reviewed currently as an enhancement to better support this type of workflow.
0请先登录再写评论。
评论
1 条评论