Class Config

Config class

Represents all the settings for GridJs

public class Config

Constructors

NameDescription
Config()The default constructor.

Properties

NameDescription
static AutoOptimizeForLargeCells { get; set; }Sets/Gets whether to automatically optimize the load performance for worksheet with large cells ignore some style /borders to reduce the load time the default value is true.
static EmptySheetMaxCol { get; set; }Sets/Gets default max column for an empty worksheet. the default value is 15.
static EmptySheetMaxRow { get; set; }Sets/Gets default max row for an empty worksheet. the default value is 12.
static FileCacheDirectory { get; set; }Sets/Gets the cache directory for spreadsheet file. We need to set it to a specific path before we use GridJs.
static IgnoreEmptyContent { get; set; }Sets/Gets whether to show the max range which includes data ,style, merged cells and shapes. if the last row or column contains cells with no value and formula but has custom style then we will not show this row/column when this vlaue is true。 the default value is true .
static IslimitShapeOrImage { get; set; }Sets/Gets whether to limit the total display shape/image count inside one worksheet ,if set to true, GridJs will limit the total display shape/image size inside one worksheet to MaxShapeOrImageCount the default value is true.
static MaxPdfSaveSeconds { get; set; }Sets/Gets the max timed out seconds when save to pdf. the default value is 10.
static MaxShapeOrImageCount { get; set; }Sets/Gets the total display shape/image count inside the active sheet,it will take affec when IslimitShapes=true. the default value is 100.
static MaxShapeOrImageWidthOrHeight { get; set; }Sets/Gets the max width or height for a shape/image ,GridJs will ignore the shape/image with the width or height larger than this, it will take affec when IslimitShapes=true. the default value is 10000.
static MaxTotalShapeOrImageCount { get; set; }Sets/Gets the total display shape/image count inside the whole workbook,it will take affec when IslimitShapes=true. the default value is 300.
static PageSize { get; set; }Sets/Gets whether to do pagination GridJs will limit the row size based on the PageSize,if PageSize is -1,it will not do pagination the default value is -1
static PictureCacheDirectory { get; set; }Sets/Gets the cache directory for pictures.(this will take affect when GridJsWorkbook.CacheImp is null) the default path will be “_piccache” inside the FileCacheDirectory.
static SameImageDetecting { get; set; }Sets/Gets whether to check if picture has same source,the default is true the default value is true.
static SaveHtmlAsZip { get; set; }Sets/Gets whether to save html file as zip archive,the default is false.
static ShowChartSheet { get; set; }Sets/Gets whether to show chart worksheet. the default value is false .
static UsePrintArea { get; set; }Sets/Gets whether to use PageSetup.PrintArea for the UI display range when the worksheet has PageSetup setting for PrintArea. the default value is false .

Methods

NameDescription
static SetFontFolder(string, bool)Sets the fonts folder
static SetFontFolders(string[], bool)Sets the fonts folders

See Also