PrintTitleColumns/PrintTitleRows and isPaginated

Aspose.Cells Product Family
1

SheetToImage only render the PrintArea when isPaginated is true. PrintTitleColumns and PrintTitleRows are ignored.
Attached :
- [4.8.2.1]area_1_isPaginated=false.png : PrintTitle OK
- [4.8.2.1]area_1_isPaginated=true.png : PrintTitle KO
- area.xls : the template file

Regards,

2

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our internal issue tracking system with issue id CELLSNET-13717.

Thank You & Best Regards,

3

Hi,


Well, we think printing repeated rows/columns is not necessary in case of converting whole sheet to an image file. This type of setting (printing repeated rows/columns) has a purpose to make the repeated rows/columns appear on every page in multiple pages. We think for converting whole sheet to an image in one page, you can set the print area to A1:B5 for your requirement.



Thank you.

4

Hello,

We use Aspose.Cells to convert XLS received by mail. As a result, we can have variable document and even if the PrintArea exclude the first line/column in my example it could be different in XLS we receive

According to us, the “isPaginated = false” should work as if the worksheet is small enough to fit the page size. Therefore, the PrintTitleColumns and PrintTitleRows should appear at least once.

An “IncludePrintTitle” boolean option when isPaginated is false might to the trick.

Regards,

5

Hi,

Thanks for your suggestion.

Well, we need to check its feasibility (for including your proposed parameter) first. We will check it and get back to you soon.

Thank you.

6

Hi,

<span style=“font-family: “Arial”,“sans-serif”;”>After further analysis, we can
consider the print row/column titles in case of converting the whole
worksheet. But It is not the same as
printing worksheet page by page.<o:p></o:p>

The row/column titles will always be printed at first and they will be printed too when the print area includes them. Does it meet your need? Kindly confirm us.

Thank you.


7

Hi,

Please try the attached version.

We have fixed your issue.

Thank you.

8

It works!

Thanks,

9

The issues you have found earlier (filed as 13717) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.