We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Any chance of getting =CHAR() supported from CalculateFormulas?


I’m doing some work with Smart Markers and very successfully importing a variety of data into an Excel workbook. One of the values that I’m importing has HTML “
” tags sprinkled throughout, and I’d like to use a formula like =SUBSTITUTE( N1, “
”, CHAR(10)).

When I import the data directly into Excel, of course this formula works fine, but I’m really out to convert the workbook to PDF, so it’s necessary for Cells to calculate the formula.

So I’m wondering if the CHAR() function is on the future feature list, or if you have another suggestion. Many thanks guys!



Thanks for considering Aspose.

We will support CHAR() function soon for your need.

Thanks for being patient!

Please try this attached version. It’s supported now.

Thank you so much for the fast turn-around on this. Your support efforts are greatly appreciated.