PaginatedSaveOptions
PaginatedSaveOptions class
Represents the options for pagination.
Methods
| Name | Description |
|---|---|
| getAllColumnsInOnePagePerSheet() | If AllColumnsInOnePagePerSheet is true , all column content of one sheet will output to only one page in result. The wid |
| getCachedFileFolder() | The cached file folder is used to store some large data. |
| getCheckExcelRestriction() | |
| getCheckFontCompatibility() | Indicates whether to check font compatibility for every character in text. The default value is true. Disable this prope |
| getCheckWorkbookDefaultFont() | When characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf |
| getClearData() | Make the workbook empty after saving the file. |
| getCreateDirectory() | If true and the directory does not exist, the directory will be automatically created before saving the file. The defaul |
| getCustomRenderSettings() | |
| getDefaultEditLanguage() | Gets or sets default edit language. The value of the property is DefaultEditLanguage integer constant. It may display/re |
| getDefaultFont() | When characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf |
| getDrawObjectEventHandler() | Implements this interface to get DrawObject and Bound when rendering. |
| getEmfRenderSetting() | Setting for rendering Emf metafile. The value of the property is EmfRenderSetting integer constant. EMF metafiles identi |
| getEncryptDocumentProperties() | |
| getGridlineColor() | |
| getGridlineType() | Gets or sets gridline type. The value of the property is GridlineType integer constant. Default is Dotted type. |
| getIgnoreError() | Indicates if you need to hide the error while rendering. The error can be error in shape, image, chart rendering, etc. |
| getMergeAreas() | Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is |
| getOnePagePerSheet() | If OnePagePerSheet is true , all content of one sheet will output to only one page in result. The paper size of pagesetu |
| getOutputBlankPageWhenNothingToPrint() | Indicates whether to output a blank page when there is nothing to print. Default is true. |
| getPageCount() | Gets or sets the number of pages to save. Default is System.Int32.MaxValue which means all pages will be rendered.. |
| getPageIndex() | Gets or sets the 0-based index of the first page to save. Default is 0. |
| getPageSavingCallback() | Control/Indicate progress of page saving process. |
| getPrintingPageType() | Indicates which pages will not be printed. The value of the property is PrintingPageType integer constant. If content in |
| getRefreshChartCache() | Indicates whether refreshing chart cache data |
| getSaveFormat() | Gets the save file format. The value of the property is SaveFormat integer constant. |
| getSheetSet() | Gets or sets the sheets to render. Default is all visible sheets in the workbook: SheetSet.Visible. |
| getSortExternalNames() | Indicates whether sorting external defined names before saving file. |
| getSortNames() | Indicates whether sorting defined names before saving file. |
| getTextCrossType() | Gets or sets displaying text type when the text width is larger than cell width. The value of the property is TextCrossT |
| getUpdateSmartArt() | Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSm |
| getValidateMergedAreas() | Indicates whether validate merged cells before saving the file. The default value is false. |
| getWarningCallback() | Gets or sets warning callback. |
| isFontSubstitutionCharGranularity() | Indicates whether to only substitute the font of character when the cell font is not compatibility for it. Default is fa |
| setAllColumnsInOnePagePerSheet() | If AllColumnsInOnePagePerSheet is true , all column content of one sheet will output to only one page in result. The wid |
| setCachedFileFolder() | The cached file folder is used to store some large data. |
| setCheckExcelRestriction() | |
| setCheckFontCompatibility() | Indicates whether to check font compatibility for every character in text. The default value is true. Disable this prope |
| setCheckWorkbookDefaultFont() | When characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf |
| setClearData() | Make the workbook empty after saving the file. |
| setCreateDirectory() | If true and the directory does not exist, the directory will be automatically created before saving the file. The defaul |
| setCustomRenderSettings() | |
| setDefaultEditLanguage() | Gets or sets default edit language. The value of the property is DefaultEditLanguage integer constant. It may display/re |
| setDefaultFont() | When characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf |
| setDrawObjectEventHandler() | Implements this interface to get DrawObject and Bound when rendering. |
| setEmfRenderSetting() | Setting for rendering Emf metafile. The value of the property is EmfRenderSetting integer constant. EMF metafiles identi |
| setEncryptDocumentProperties() | |
| setFontSubstitutionCharGranularity() | Indicates whether to only substitute the font of character when the cell font is not compatibility for it. Default is fa |
| setGridlineColor() | |
| setGridlineType() | Gets or sets gridline type. The value of the property is GridlineType integer constant. Default is Dotted type. |
| setIgnoreError() | Indicates if you need to hide the error while rendering. The error can be error in shape, image, chart rendering, etc. |
| setMergeAreas() | Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is |
| setOnePagePerSheet() | If OnePagePerSheet is true , all content of one sheet will output to only one page in result. The paper size of pagesetu |
| setOutputBlankPageWhenNothingToPrint() | Indicates whether to output a blank page when there is nothing to print. Default is true. |
| setPageCount() | Gets or sets the number of pages to save. Default is System.Int32.MaxValue which means all pages will be rendered.. |
| setPageIndex() | Gets or sets the 0-based index of the first page to save. Default is 0. |
| setPageSavingCallback() | Control/Indicate progress of page saving process. |
| setPrintingPageType() | Indicates which pages will not be printed. The value of the property is PrintingPageType integer constant. If content in |
| setRefreshChartCache() | Indicates whether refreshing chart cache data |
| setSheetSet() | Gets or sets the sheets to render. Default is all visible sheets in the workbook: SheetSet.Visible. |
| setSortExternalNames() | Indicates whether sorting external defined names before saving file. |
| setSortNames() | Indicates whether sorting defined names before saving file. |
| setTextCrossType() | Gets or sets displaying text type when the text width is larger than cell width. The value of the property is TextCrossT |
| setUpdateSmartArt() | Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSm |
| setValidateMergedAreas() | Indicates whether validate merged cells before saving the file. The default value is false. |
| setWarningCallback() | Gets or sets warning callback. |
getAllColumnsInOnePagePerSheet()
If AllColumnsInOnePagePerSheet is true , all column content of one sheet will output to only one page in result. The width of paper size of pagesetup will be ignored, and the other settings of pagesetup will still take effect.
getCachedFileFolder()
The cached file folder is used to store some large data.
getCheckExcelRestriction()
getCheckFontCompatibility()
Indicates whether to check font compatibility for every character in text. The default value is true. Disable this property may give better performance. But when the default or specified font of text/character cannot be used to render it, unreadable characters(such as block) maybe occur in the generated pdf. For such situation user should keep this property as true so that alternative font can be searched and used to render the text instead;
getCheckWorkbookDefaultFont()
When characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf,image. Set this to true to try to use workbook’s default font to show these characters first. Default is true.
getClearData()
Make the workbook empty after saving the file.
getCreateDirectory()
If true and the directory does not exist, the directory will be automatically created before saving the file. The default value is false.
getCustomRenderSettings()
getDefaultEditLanguage()
Gets or sets default edit language. The value of the property is DefaultEditLanguage integer constant. It may display/render different layouts for text paragraph when different edit languages is set. Default is DefaultEditLanguage.AUTO.
getDefaultFont()
When characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf,image. Set the DefaultFont such as MingLiu or MS Gothic to show these characters. If this property is not set, Aspose.Cells will use system default font to show these unicode characters.
getDrawObjectEventHandler()
Implements this interface to get DrawObject and Bound when rendering.
getEmfRenderSetting()
Setting for rendering Emf metafile. The value of the property is EmfRenderSetting integer constant. EMF metafiles identified as “EMF+ Dual” can contain both EMF+ records and EMF records. Either type of record can be used to render the image, only EMF+ records, or only EMF records. When EmfRenderSetting.EMF_PLUS_PREFER is set, then EMF+ records will be parsed while rendering to page, otherwise only EMF records will be parsed. Default value is EmfRenderSetting.EMF_ONLY.
getEncryptDocumentProperties()
getGridlineColor()
getGridlineType()
Gets or sets gridline type. The value of the property is GridlineType integer constant. Default is Dotted type.
getIgnoreError()
Indicates if you need to hide the error while rendering. The error can be error in shape, image, chart rendering, etc.
getMergeAreas()
Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is false.
getOnePagePerSheet()
If OnePagePerSheet is true , all content of one sheet will output to only one page in result. The paper size of pagesetup will be invalid, and the other settings of pagesetup will still take effect.
getOutputBlankPageWhenNothingToPrint()
Indicates whether to output a blank page when there is nothing to print. Default is true.
getPageCount()
Gets or sets the number of pages to save. Default is System.Int32.MaxValue which means all pages will be rendered..
getPageIndex()
Gets or sets the 0-based index of the first page to save. Default is 0.
getPageSavingCallback()
Control/Indicate progress of page saving process.
getPrintingPageType()
Indicates which pages will not be printed. The value of the property is PrintingPageType integer constant. If content in the sheet is sparse, there will be some pages are totally blank in the output pdf file. If you don’t want these blank pages, you can use this option to omit them.
getRefreshChartCache()
Indicates whether refreshing chart cache data
getSaveFormat()
Gets the save file format. The value of the property is SaveFormat integer constant.
getSheetSet()
Gets or sets the sheets to render. Default is all visible sheets in the workbook: SheetSet.Visible.
getSortExternalNames()
Indicates whether sorting external defined names before saving file.
getSortNames()
Indicates whether sorting defined names before saving file.
getTextCrossType()
Gets or sets displaying text type when the text width is larger than cell width. The value of the property is TextCrossType integer constant.
getUpdateSmartArt()
Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSmartArt() method and the cached shapes exist in the template file.
getValidateMergedAreas()
Indicates whether validate merged cells before saving the file. The default value is false.
getWarningCallback()
Gets or sets warning callback.
isFontSubstitutionCharGranularity()
Indicates whether to only substitute the font of character when the cell font is not compatibility for it. Default is false. We will try default font of Workbook and PdfSaveOption/system for cell font first.
setAllColumnsInOnePagePerSheet()
If AllColumnsInOnePagePerSheet is true , all column content of one sheet will output to only one page in result. The width of paper size of pagesetup will be ignored, and the other settings of pagesetup will still take effect.
setCachedFileFolder()
The cached file folder is used to store some large data.
setCheckExcelRestriction()
setCheckFontCompatibility()
Indicates whether to check font compatibility for every character in text. The default value is true. Disable this property may give better performance. But when the default or specified font of text/character cannot be used to render it, unreadable characters(such as block) maybe occur in the generated pdf. For such situation user should keep this property as true so that alternative font can be searched and used to render the text instead;
setCheckWorkbookDefaultFont()
When characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf,image. Set this to true to try to use workbook’s default font to show these characters first. Default is true.
setClearData()
Make the workbook empty after saving the file.
setCreateDirectory()
If true and the directory does not exist, the directory will be automatically created before saving the file. The default value is false.
setCustomRenderSettings()
setDefaultEditLanguage()
Gets or sets default edit language. The value of the property is DefaultEditLanguage integer constant. It may display/render different layouts for text paragraph when different edit languages is set. Default is DefaultEditLanguage.AUTO.
setDefaultFont()
When characters in the Excel are Unicode and not be set with correct font in cell style, They may appear as block in pdf,image. Set the DefaultFont such as MingLiu or MS Gothic to show these characters. If this property is not set, Aspose.Cells will use system default font to show these unicode characters.
setDrawObjectEventHandler()
Implements this interface to get DrawObject and Bound when rendering.
setEmfRenderSetting()
Setting for rendering Emf metafile. The value of the property is EmfRenderSetting integer constant. EMF metafiles identified as “EMF+ Dual” can contain both EMF+ records and EMF records. Either type of record can be used to render the image, only EMF+ records, or only EMF records. When EmfRenderSetting.EMF_PLUS_PREFER is set, then EMF+ records will be parsed while rendering to page, otherwise only EMF records will be parsed. Default value is EmfRenderSetting.EMF_ONLY.
setEncryptDocumentProperties()
setFontSubstitutionCharGranularity()
Indicates whether to only substitute the font of character when the cell font is not compatibility for it. Default is false. We will try default font of Workbook and PdfSaveOption/system for cell font first.
setGridlineColor()
setGridlineType()
Gets or sets gridline type. The value of the property is GridlineType integer constant. Default is Dotted type.
setIgnoreError()
Indicates if you need to hide the error while rendering. The error can be error in shape, image, chart rendering, etc.
setMergeAreas()
Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is false.
setOnePagePerSheet()
If OnePagePerSheet is true , all content of one sheet will output to only one page in result. The paper size of pagesetup will be invalid, and the other settings of pagesetup will still take effect.
setOutputBlankPageWhenNothingToPrint()
Indicates whether to output a blank page when there is nothing to print. Default is true.
setPageCount()
Gets or sets the number of pages to save. Default is System.Int32.MaxValue which means all pages will be rendered..
setPageIndex()
Gets or sets the 0-based index of the first page to save. Default is 0.
setPageSavingCallback()
Control/Indicate progress of page saving process.
setPrintingPageType()
Indicates which pages will not be printed. The value of the property is PrintingPageType integer constant. If content in the sheet is sparse, there will be some pages are totally blank in the output pdf file. If you don’t want these blank pages, you can use this option to omit them.
setRefreshChartCache()
Indicates whether refreshing chart cache data
setSheetSet()
Gets or sets the sheets to render. Default is all visible sheets in the workbook: SheetSet.Visible.
setSortExternalNames()
Indicates whether sorting external defined names before saving file.
setSortNames()
Indicates whether sorting defined names before saving file.
setTextCrossType()
Gets or sets displaying text type when the text width is larger than cell width. The value of the property is TextCrossType integer constant.
setUpdateSmartArt()
Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSmartArt() method and the cached shapes exist in the template file.
setValidateMergedAreas()
Indicates whether validate merged cells before saving the file. The default value is false.
setWarningCallback()
Gets or sets warning callback.