After the creation of mytest.xlsx you have to change the fields Source!B2 to for example “Changed value”. This value should now be shown on the worksheet ‘Designer’ within the camera area.
"After the creation of mytest.xlsx you have to change the fields Source!B2 to for example “Changed value”. This value should now be shown on the worksheet ‘Designer’ within the camera area."
If you could open your template “template.xls” file into Ms Excel and do the (change the cell B2 in the Source sheet, you will see that it also changes Designer sheet area(s). So, the re-saved file (by Aspose.Cells) does the same thing.
Now, I can notice the formula “=$L$4:$M$5” is gone for camera area in the “Designer” sheet after re-save (by Aspose.Cells). I have logged it and we will soon look into it.
The open/save issues is fixed, but I have found another issue. If I open the workbook in xls format, copy the worksheet and then save it into xlsx format, the formula for the camera area in worksheet ‘copy’ is gone.
Best regards
Workbook wb = new Workbook(System.IO.Path.Combine(Application.StartupPath, “template.xls”));