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; }Gets/Sets whether to automatically optimize the load performance for worksheet with large cells. it will ignore some style /borders to reduce the load time. the default value is true.
static EmptySheetMaxCol { get; set; }Gets/Sets default max column for an empty worksheet. the default value is 15.
static EmptySheetMaxRow { get; set; }Gets/Sets default max row for an empty worksheet. the default value is 12.
static FileCacheDirectory { get; set; }Gets/Sets the cache directory for storing spreadsheet file. We need to set it to a specific path before we use GridJs.
static IgnoreEmptyContent { get; set; }Gets/Sets 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; }Gets/Sets whether to limit the total display shape/image count in one worksheet ,if set to true, GridJs will limit the total count of the display shapes or images in one worksheet to MaxShapeOrImageCount the default value is true.
static LazyLoading { get; set; }Gets/Sets whether to load active worksheet only,the default is false.
static MaxPdfSaveSeconds { get; set; }Gets/Sets the max timed out seconds when save to PDF. the default value is 10.
static MaxShapeOrImageCount { get; set; }Gets/Sets the total count of the display shapes or images in the active sheet,it takes effect when IslimitShapeOrImage=true. the default value is 100.
static MaxShapeOrImageWidthOrHeight { get; set; }Gets/Sets the max width or height for a shape or an image ,GridJs will ignore the shape or image with the width or height larger than this, it takes effect when IslimitShapeOrImage=true. the default value is 10000.
static MaxTotalShapeOrImageCount { get; set; }Gets/Sets the total count of the display shapes or images in the workbook,it takes effect when IslimitShapeOrImage=true. the default value is 300.
static PageSize { get; set; }Gets/Sets 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; }Gets/Sets the cache directory for pictures.(this takes effect when GridJsWorkbook.CacheImp is null) the default path will be “_piccache” inside the FileCacheDirectory.
static SameImageDetecting { get; set; }Gets/Sets whether to check if images have same source,the default is true the default value is true.
static SaveHtmlAsZip { get; set; }Gets/Sets whether to save html file as zip archive,the default is false.
static ShowChartSheet { get; set; }Gets/Sets whether to show chart worksheet. the default value is false .
static SkipInvisibleShapes { get; set; }Gets/Sets whether to skip shapes that are invisble to UI ,the default value is true.
static UsePrintArea { get; set; }Gets/Sets 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