Write Range Workbook activity is changing setting of PIVOT table

Feedback Activities
, ,
1

Dear community,
did you encounter the same issue?

End user has pivot table and in the pivot table rows (s)he would like to show comments on the specific business transactions (not the ideal situation, as pivot tables are intended for difference use cases). MS Excel allows you display more than 255 characters, but after using Write Range Workbook, which is inserting data directly through XML structure, it changes pivot table XML definition and after execution of the script and opening file, only first 255 characters are displayed.

In attachment dummy excel file, please, try to use Write Range Workbook.
Issue is not with classic write range or modern write range activity.

TEST.xlsx (17.0 KB)

Thanks.