Word to PDF generation formulas with table cells fails

i have a word file which has formulas with table cell references in it:



this works fine in word itself:


when generating this word file to pdf through syncfusion with a code like:



i get errors in the generated PDF as the formulas do not work with table references:




how can i get this working?

see attached demo project.



Attachment: syncfusionwordfail_d49d17c_39d9f9fe.zip

3 Replies

LB Lokesh Baskar Syncfusion Team October 27, 2021 11:01 AM UTC

Hi Pascal,

Thank you for contacting Syncfusion support.

On further analyzing with the given Word document, we found that you have used formula field for adding the cell values. Currently DocIO doesn’t support formula field manipulations with in table (LEFT and RIGHT, SUM, AVG, ABOVE and BELOW, PRODUCT calculations, etc., inside the table). We have already logged this as a feature request in our database and we don’t have any immediate plans to implement this feature. At the planning stage for every release cycle, we review all open features. We will let you know when this feature is implemented.

You can track the status of this feature from the below link:
https://www.syncfusion.com/feedback/3052/update-formula-field-that-evaluate-a-column-or-row-of-numbers-in-a-table

Please lets us know if you have any other questions.

Regards,
Lokesh B 



PS Pascal Seifert October 27, 2021 11:08 AM UTC

thanks lokesh. i understand that aggregation functions are not supported right now.


how can i add two cells together in a formula without aggregations?

as you can see i did this in the following formula, but it does also not work:




LB Lokesh Baskar Syncfusion Team October 27, 2021 11:59 AM UTC

Hi Pascal,

Thank you for your update.

As mentioned earlier, currently DocIO doesn’t support for adding the cell values(in a table) together in a formula field(formula with aggregations function  and without aggregations). We have already logged this as a feature request in our database and we don’t have any immediate plans to implement this feature. At the planning stage for every release cycle, we review all open features. We will let you know when this feature is implemented. 


You can track the status of this feature from the below link:
https://www.syncfusion.com/feedback/3052/update-formula-field-that-evaluate-a-column-or-row-of-numbers-in-a-table 

Please lets us know if you have any other questions.

Regards,
Lokesh B 
 


Loader.
Up arrow icon