We are using an old version of aspose cell 4.9.1.0. We are actually opening an excel file (xlsx) as template from a web url. The template already contains the pivot tables in its 2 nd and 3rd worksheets. We are inserting data to the first worksheet. The data is getting inserted properly but on downloading the new document the formatting is done to the pivot table is removed. for ex. legends are getting overlapped to the graph, border width is getting reduced.
we are not making any changes on 2nd or 3rd sheets. Please guide me what could be the reason for the issue.
Hi,
Thanks for providing us some details.
Well, it looks like a bug (although we are not entirely certain about it) in your older version (v4.9.1.0) that you are using. I am afraid, we cannot evaluate or fix any issue in the older version, we can only recommend you to kindly upgrade to and use latest version of the product. Also, if you use latest version of Aspose.Cells APIs and still you find the issue with it (e.g v16.11.x (latest)), kindly do provide a simple sample project (runnable) with template files, you may zip it prior attaching it, we will check and figure out your issue soon.
Thank you.