Free Support Forum - aspose.com

How to specify number format in words.table.cell?

In word if you insert a table, you can select from the menu Table/Formula/Number Format and specify something like $#,##0.00;($#,##0.00) . Is there an api to access the number format?

@gorser,

Please ZIP and upload your sample input and expected Word documents here for testing. Please create expected document by using MS Word. We will investigate the structure of your expected document and provide you code to achieve the same by using Aspose.Words.

Screen Shot 2018-09-25 at 9.01.57 AM.png (389.6 KB)

In java code, how do I specify number format = $#,##0.00;($#,##0.00) .

numberFormat.zip (23.0 KB)

Example docx document, renamed as .zip

@gorser,

We have logged your requirement in our issue tracking system. The ID of this issue is WORDSNET-17490. We will further look into the details of this problem and will keep you updated on the status of this issue. We apologize for your inconvenience.

@gorser,

Regarding WORDSNET-17490, it is to update you that we have completed the work on this issue and come to a conclusion that we will not be able to implement the fix to this issue. Your issue (WORDSNET-17490) will be closed with ‘Won’t Fix’ resolution.

Please try to unzip numberFormat.docx and check in document.xml how this number format was applied. You will see that it is not related to the table, but it is just simple Field with number format applied. So there is no way to apply Formula Number Format to the table cell.

To insert fields in document, please refer to the following article:
Inserting Fields into a Document