Skip to main content

Support for multiple print areas - Community / GemBox.Spreadsheet Feature Request - GemBox Support Center

Request for adding support for multiple print areas.   GemBox.Spreadsheet offers an API for setting a print area on each worksheet, with a SetPrintArea method: https://www.gemboxsoftware.com/spreadsheet/help/html/M_GemBox_Spreadsheet_NamedRangeCollection_SetPrintArea.htm

On the following link there is a sample which demonstrates how to set worksheet's print area:

https://www.gemboxsoftware.com/spreadsheet/examples/excel-print-title-area/104

Currently this method supports setting only a single cell range as a print area.

Comment (1)

Mario - GemBox
Hi,

GemBox.Spreadsheet introduced a support for this, it is accomplished by using "SetPrintArea(IEnumerable<CellRange> ranges)" overload method:
https://www.gemboxsoftware.com/spreadsheet/help/html/M_GemBox_Spreadsheet_NamedRangeCollection_SetPrintArea_2.htm

Regards,

Mario
GemBox d.o.o.