I am trying to develop an Excel-to-Word converter, which should also work with decimal tab stop functionality. In Excel, I add a Custom Format pattern to each table cell, which sould be decimal tabbed. This pattern is as following:
When I convert the custom formatted Excel range to a Word document, I use the Word-specific Decimal Tab Stop for number alignment in those table cells containing the Custom Format pattern in Excel file.
Now the problem is: How can I calculate the correct position of the tab stop in the word table cell paragraph so that numbers are aligned correctly and are also as close as possible aligned to the right cell border in the Word document? Can you please give me a coding example how to get a Word result that looks nearly 100% like the Excel source? Please find an example Excel source file attached to this post.
Thanks for your support!