Page margin settings in Excel Sheets

Aspose.Cells Product Family
1
Hi -

Does Aspose.Cells for Reporting Services allow creation of Excel spreadsheets with specific margins regardles of excel verion (xls or xlsx)?

I am specifically looking for individual report setting not Global setting of the page margins in excel. I have an excel report with 4 tabs with one of the tabs not displaying the report in 1 page while other 3 tabs do.

Any help would be greatly appreciated.

Thank you
2

Hi,

Thanks for your posting and considering Aspose.Cells for Reporting Services.

Now, Aspose.Cells for Reporting Services does not support this feature.

We will develop the feature ASAP.

This issue has been logged as

  • SSRS-40235 - Page margin settings in Excel Sheets

3

Hi,

Thanks for considering Aspose.Cells for Reporting Services.

We have added new feature for setting page margin.

Please try the fixed version: Aspose.Cells for Reporting Services (SSRS2008R2) v2.4.0.10.

Please copy Aspose.Cells.ReportingServices.dll into following folder:

${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin

And add the following configuration in Aspose.Cells.ReportingServices.xml.


……






……


PageSetup configuration has following 6 kind of attributes:

  • LeftMargin
  • RightMargin
  • BottomMargin
  • TopMargin
  • HeaderMargin
  • FooterMargin.

The name attribute is report name for which we are to set page margin.

The index attribute is work sheet index for which we are to set page margin.

Please let us know your run results.

4

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.