Config
Inheritance: java.lang.Object
public class Config
Represents all the settings for GridJs
Constructors
| Constructor | Description |
|---|---|
| Config() |
Methods
| Method | Description |
|---|---|
| equals(Object arg0) | |
| getAutoOptimizeForLargeCells() | 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. |
| getClass() | |
| getEmptySheetMaxCol() | Gets default max column for an empty worksheet. |
| getEmptySheetMaxRow() | Gets default max row for an empty worksheet. |
| getFileCacheDirectory() | Gets the cache directory for spreadsheet file. |
| getIgnoreEmptyContent() | Gets whether to show the max range which includes data ,style, merged cells and shapes. |
| getIslimitShapeOrImage() | 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. |
| getMaxPdfSaveSeconds() | Gets the max timed out seconds when save to pdf. |
| getMaxShapeOrImageCount() | Gets the total display shape/image count inside the active sheet,it will take affec when IslimitShapes=true. |
| getMaxShapeOrImageWidthOrHeight() | 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. |
| getMaxTotalShapeOrImageCount() | Gets the total display shape/image count inside the whole workbook,it will take affec when IslimitShapes=true. |
| getPageSize() | 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 |
| getPictureCacheDirectory() | Gets the cache directory for pictures. |
| getSameImageDetecting() | Gets whether to check if picture has same source,the default is true the default value is true. |
| getSaveHtmlAsZip() | Gets whether to save html file as zip archive,the default is false. |
| getShowChartSheet() | Gets whether to show chart worksheet. |
| getSkipInvisibleShapes() | Gets whether to skip shpaes that is invisble to UI ,the default value is true. |
| getUsePrintArea() | Gets whether to use PageSetup.PrintArea for the UI display range when the worksheet has PageSetup setting for PrintArea. |
| hashCode() | |
| notify() | |
| notifyAll() | |
| setAutoOptimizeForLargeCells(boolean value) | Sets 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. |
| setEmptySheetMaxCol(int value) | Sets default max column for an empty worksheet. |
| setEmptySheetMaxRow(int value) | Sets default max row for an empty worksheet. |
| setFileCacheDirectory(String value) | Sets the cache directory for spreadsheet file. |
| setFontFolder(String fontFolder, boolean recursive) | Sets the fonts folder |
| setFontFolders(String[] fontFolders, boolean recursive) | Sets the fonts folders |
| setIgnoreEmptyContent(boolean value) | Sets whether to show the max range which includes data ,style, merged cells and shapes. |
| setIslimitShapeOrImage(boolean value) | Sets 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. |
| setMaxPdfSaveSeconds(int value) | Sets the max timed out seconds when save to pdf. |
| setMaxShapeOrImageCount(int value) | Sets the total display shape/image count inside the active sheet,it will take affec when IslimitShapes=true. |
| setMaxShapeOrImageWidthOrHeight(int value) | Sets 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. |
| setMaxTotalShapeOrImageCount(int value) | Sets the total display shape/image count inside the whole workbook,it will take affec when IslimitShapes=true. |
| setPageSize(int value) | 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 |
| setPictureCacheDirectory(String value) | Sets the cache directory for pictures. |
| setSameImageDetecting(boolean value) | Sets whether to check if picture has same source,the default is true the default value is true. |
| setSaveHtmlAsZip(boolean value) | Sets whether to save html file as zip archive,the default is false. |
| setShowChartSheet(boolean value) | Sets whether to show chart worksheet. |
| setSkipInvisibleShapes(boolean value) | Sets whether to skip shpaes that is invisble to UI ,the default value is true. |
| setUsePrintArea(boolean value) | Sets whether to use PageSetup.PrintArea for the UI display range when the worksheet has PageSetup setting for PrintArea. |
| toString() | |
| wait() | |
| wait(long arg0) | |
| wait(long arg0, int arg1) |
Config()
public Config()
equals(Object arg0)
public boolean equals(Object arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | java.lang.Object |
Returns: boolean
getAutoOptimizeForLargeCells()
public static boolean getAutoOptimizeForLargeCells()
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.
Returns: boolean
getClass()
public final native Class<?> getClass()
Returns: java.lang.Class
getEmptySheetMaxCol()
public static int getEmptySheetMaxCol()
Gets default max column for an empty worksheet. the default value is 15.
Returns: int
getEmptySheetMaxRow()
public static int getEmptySheetMaxRow()
Gets default max row for an empty worksheet. the default value is 12.
Returns: int
getFileCacheDirectory()
public static String getFileCacheDirectory()
Gets the cache directory for spreadsheet file. We need to set it to a specific path before we use GridJs.
Returns: java.lang.String
getIgnoreEmptyContent()
public static boolean getIgnoreEmptyContent()
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\u9286?* the default value is true .
Returns: boolean
getIslimitShapeOrImage()
public static boolean getIslimitShapeOrImage()
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.
Returns: boolean
getMaxPdfSaveSeconds()
public static int getMaxPdfSaveSeconds()
Gets the max timed out seconds when save to pdf. the default value is 10.
Returns: int
getMaxShapeOrImageCount()
public static int getMaxShapeOrImageCount()
Gets the total display shape/image count inside the active sheet,it will take affec when IslimitShapes=true. the default value is 100.
Returns: int
getMaxShapeOrImageWidthOrHeight()
public static int getMaxShapeOrImageWidthOrHeight()
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.
Returns: int
getMaxTotalShapeOrImageCount()
public static int getMaxTotalShapeOrImageCount()
Gets the total display shape/image count inside the whole workbook,it will take affec when IslimitShapes=true. the default value is 300.
Returns: int
getPageSize()
public static int getPageSize()
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
Returns: int
getPictureCacheDirectory()
public static String getPictureCacheDirectory()
Gets the cache directory for pictures.(this will take affect when GridJsWorkbook.CacheImp is null) the default path will be “_piccache” inside the FileCacheDirectory.
Returns: java.lang.String
getSameImageDetecting()
public static boolean getSameImageDetecting()
Gets whether to check if picture has same source,the default is true the default value is true.
Returns: boolean
getSaveHtmlAsZip()
public static boolean getSaveHtmlAsZip()
Gets whether to save html file as zip archive,the default is false.
Returns: boolean
getShowChartSheet()
public static boolean getShowChartSheet()
Gets whether to show chart worksheet. the default value is false .
Returns: boolean
getSkipInvisibleShapes()
public static boolean getSkipInvisibleShapes()
Gets whether to skip shpaes that is invisble to UI ,the default value is true.
Returns: boolean
getUsePrintArea()
public static boolean getUsePrintArea()
Gets whether to use PageSetup.PrintArea for the UI display range when the worksheet has PageSetup setting for PrintArea. the default value is false .
Returns: boolean
hashCode()
public native int hashCode()
Returns: int
notify()
public final native void notify()
notifyAll()
public final native void notifyAll()
setAutoOptimizeForLargeCells(boolean value)
public static void setAutoOptimizeForLargeCells(boolean value)
Sets 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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setEmptySheetMaxCol(int value)
public static void setEmptySheetMaxCol(int value)
Sets default max column for an empty worksheet. the default value is 15.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
setEmptySheetMaxRow(int value)
public static void setEmptySheetMaxRow(int value)
Sets default max row for an empty worksheet. the default value is 12.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
setFileCacheDirectory(String value)
public static void setFileCacheDirectory(String value)
Sets the cache directory for spreadsheet file. We need to set it to a specific path before we use GridJs.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | java.lang.String |
setFontFolder(String fontFolder, boolean recursive)
public static void setFontFolder(String fontFolder, boolean recursive)
Sets the fonts folder
Parameters:
| Parameter | Type | Description |
|---|---|---|
| fontFolder | java.lang.String | The folder that contains TrueType fonts. |
| recursive | boolean | Determines whether or not to scan subfolders. |
setFontFolders(String[] fontFolders, boolean recursive)
public static void setFontFolders(String[] fontFolders, boolean recursive)
Sets the fonts folders
Parameters:
| Parameter | Type | Description |
|---|---|---|
| fontFolders | java.lang.String[] | The folders that contains TrueType fonts. |
| recursive | boolean | Determines whether or not to scan subfolders. |
setIgnoreEmptyContent(boolean value)
public static void setIgnoreEmptyContent(boolean value)
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\u9286?* the default value is true .
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setIslimitShapeOrImage(boolean value)
public static void setIslimitShapeOrImage(boolean value)
Sets 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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setMaxPdfSaveSeconds(int value)
public static void setMaxPdfSaveSeconds(int value)
Sets the max timed out seconds when save to pdf. the default value is 10.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
setMaxShapeOrImageCount(int value)
public static void setMaxShapeOrImageCount(int value)
Sets the total display shape/image count inside the active sheet,it will take affec when IslimitShapes=true. the default value is 100.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
setMaxShapeOrImageWidthOrHeight(int value)
public static void setMaxShapeOrImageWidthOrHeight(int value)
Sets 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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
setMaxTotalShapeOrImageCount(int value)
public static void setMaxTotalShapeOrImageCount(int value)
Sets the total display shape/image count inside the whole workbook,it will take affec when IslimitShapes=true. the default value is 300.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
setPageSize(int value)
public static void setPageSize(int value)
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
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
setPictureCacheDirectory(String value)
public static void setPictureCacheDirectory(String value)
Sets the cache directory for pictures.(this will take affect when GridJsWorkbook.CacheImp is null) the default path will be “_piccache” inside the FileCacheDirectory.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | java.lang.String |
setSameImageDetecting(boolean value)
public static void setSameImageDetecting(boolean value)
Sets whether to check if picture has same source,the default is true the default value is true.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setSaveHtmlAsZip(boolean value)
public static void setSaveHtmlAsZip(boolean value)
Sets whether to save html file as zip archive,the default is false.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setShowChartSheet(boolean value)
public static void setShowChartSheet(boolean value)
Sets whether to show chart worksheet. the default value is false .
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setSkipInvisibleShapes(boolean value)
public static void setSkipInvisibleShapes(boolean value)
Sets whether to skip shpaes that is invisble to UI ,the default value is true.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setUsePrintArea(boolean value)
public static void setUsePrintArea(boolean value)
Sets whether to use PageSetup.PrintArea for the UI display range when the worksheet has PageSetup setting for PrintArea. the default value is false .
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
toString()
public String toString()
Returns: java.lang.String
wait()
public final void wait()
wait(long arg0)
public final native void wait(long arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long |
wait(long arg0, int arg1)
public final void wait(long arg0, int arg1)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long | |
| arg1 | int |