I need to change the cells formulas to target a new internal worksheet.
I´ve tried to get a substring from the original formula and set it up in the cell (because the source worksheets have the same name) but the excel file turns in a corrupted file.
Is there a correct ways to do this?
Regards
PS: The source is on a network folder and need to be updated many times. We will copy it to a internal worksheet on the excel files to be able to update values on the sources without need to open the excel files to update the links.
We need to evaluate your code and template file. Please create a simple console application (runnable), zip the project and post us here to show the issue, we will check it soon.
PS. please zip the project/file(s) prior attaching.
Well, you are using some older version which might have this issue. I have tested using our latest version/fix and it works fine and I do not find any issue with the output file. Please upgrade to latest version of the product and try our latest version/fix (e.g Aspose.Cells for Java v19.11.5) aspose-cells-19.11.5.zip (6.7 MB)