Dynamic content in Workbook not visible to print?

[gmerideth]

I’m taking a clients template Excel sheet (with formatting/logo) and importing that into Aspose then adding dynamic data and a chart. When I send the Excel document to the user they can open it and view the data just fine (attachment one) but when you go to print the document, only the data that is in the template shows up to print (attachment two). You can edit the data and formulas work and the chart updates, you just can’t print any of it.

Using version 8.2.2.0.

Sheet

http://i.imgur.com/TI4UVFY.jpg

Trying to print

http://i.imgur.com/qbW1jRc.jpg

[babar.raza]

Hi Greg,

Thank you for contacting Aspose support.

In order to properly evaluate your presented scenario, we need your input and output spreadsheets along with the source code lines to manipulate the spreadsheet using Aspose.Cells API. We would request you to please provide this information for thorough investigation.

Anyway, one of the possible reason for the said behavior could be that the input spreadsheet has predefined print area set. While manipulating the spreadsheet, you are not probably extending the print area so when you set the resultant spreadsheet for printing, only previously defined area gets printed. You may confirm this by viewing the spreadsheet in Page Layout view of Excel application.