I am still in the process of evaluating Aspose.cells for reporting services and trying to build some proof of concepts to make a purchase decision.
I noticed that in many cases the HTML output in Reporting Services is close to the Original Excel template but some formatting settings are not written in the XML.
While I can finish the formatting in MS SQL Report Builder it then means I cannot go back to the original Excel Template if I wish to make some changes.
It would be great to be able to use Aspose.Cells in Excel as a templating tool to also generate online reports in SSRS.
I noticed the following quirks:
Text position formatting is not carried over:
XML generated by aspose does not contain:
Middle for a paragraph
Center for text
General Number formatting is not carried over:
In Excel I can have specific number formatting to % or just numbers but nothing is inserted. Doing the same in SQL Report Builder adds the following code to the XML
Is this something that could be added in order to make viewing reports online more agreeable?