@curmas,
Thanks for the template file and sample code segment.
When you update some shape’s referenced value, you got to use ShapeCollection.updateSelectedValue() method to refresh the shapes values. See the following sample code that works fine as I tested (you may adjust the code in your custom classes, e.g “AsposeCalcWorkbook” accordingly):
e.g
Sample code:
Workbook workbook = new Workbook("f:\\files\\TextField.xls");
Worksheet worksheet = workbook.getWorksheets().get(0);
Cell cell = worksheet.getCells().get(0, 7); // Cell H1
cell.setValue(1);
workbook.calculateFormula();
worksheet.getShapes().updateSelectedValue();
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions(com.aspose.cells.SaveFormat.PDF);
pdfSaveOptions.setAllColumnsInOnePagePerSheet(true);
pdfSaveOptions.setPrintingPageType(PrintingPageType.IGNORE_BLANK);
pdfSaveOptions.setCompliance(PdfCompliance.NONE);
workbook.save("f:\\files\\out1.pdf", pdfSaveOptions);
Hope, this helps a bit.