Column & Row Sum

Hi,

I am having one table in the document (attached pic). I wanted to have total of col1,col2and col3 and row1 & row2.How to do it using expose java word api? Because when i try it using MS word formula (=Sum(Left)) than until i press F9 it doesn’t show me the result automatically. Moreover it adds the header value also if it is numeric.

Col1 Col2 Col3 Total
Row1 20 20 20 ?
Row2 10 10 10 ?
Total ? ? ? ?

Thanks & Regards
Prakhar Paharia

Hi

Thanks for your request. Aspose.Words for Java does not support cell references, like LEFT and ABOVE at the moment. This feature is already supported in .NET version. Once filed evaluation engine is ported from .NET to Java, this feature will be also available in Java version of Aspose.Words. Hopefully, it will be supported in a month or two. You will be notified.
Best regards.

You can also try creating your own method to update such fields. For instance, see the following link:
https://forum.aspose.com/t/79601
Best regards.

We are happy to inform you that the first auto-ported version of Aspose.Words for Java is ready. This version supports updating fields. You can get it from here.

Best regards,
Aspose.Words team

(13)