In the attached docx file, there are two tables, each containing a SUM(above) formula in the bottom right cell. In the first table, the sum is incorrectly updated to zero and in the second table the sum works correctly. The attached pdf shows the results; the code is below.
public static Stream DocToPdfStream(Document doc)
{
Document doc = new Document(fileIn);
doc.AcceptAllRevisions();
doc.UpdateFields();
doc.UpdatePageLayout();
Stream fileOut = new MemoryStream();
Aspose.Words.Saving.PdfSaveOptions pdfOptions = new Aspose.Words.Saving.PdfSaveOptions();
pdfOptions.HeadingsOutlineLevels = 1;
pdfOptions.ExpandedOutlineLevels = 1;
pdfOptions.BookmarksOutlineLevel = 1; //max allowed value is 9
pdfOptions.JpegQuality = JpegQuality;
pdfOptions.TextCompression = Aspose.Words.Saving.PdfTextCompression.Flate; //zip compression
doc.Save(fileOut, pdfOptions);
return fileOut;
}
thank you,
Ken