You can load Spread.Sheets sub-libraries to use certain features without loading all the libraries.
Features |
Required Libraries |
Core |
gc.spread.common...***..min.jsgc.spread.sheets.core...***..min.js |
Calc Engine |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.jsgc.spread.sheets.core...***..min.js |
Basic Functions |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.js gc.spread.calcengine.basicfunctions...***..min.jsgc.spread.sheets.core...***..min.js |
Advanced Functions |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.jsgc.spread.calcengine.advancedfunctions...***..min.jsgc.spread.sheets.core...***..min.js |
Data Binding |
gc.spread.common...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.bindings...***..min.js |
Drag Fill |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.fill...***..min.js |
Filter |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.conditionalformatting...***..min.jsgc.spread.sheets.filter...***..min.js |
Formula Textbox |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.formulatextbox...***..min.js |
Floating Object |
gc.spread.common...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.floatingobjects...***..min.js |
Outline |
gc.spread.common...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.outlines...***..min.js |
Touch |
gc.spread.common...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.touch...***..min.js |
gc.spread.common...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.print...***..min.js |
|
Cell Type |
gc.spread.common...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.celltypes...***..min.js |
Comment |
gc.spread.common...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.comments...***..min.js |
Conditional Formatting |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.conditionalformatting...***..min.js |
Data Validation |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.conditionalformatting...***..min.jsgc.spread.sheets.datavalidation...***..min.js |
Search |
gc.spread.common...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.search...***..min.js |
Sparkline |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.jsgc.spread.calcengine.basicfunctions...***..min.jsgc.spread.calcengine.advancedfunctions...***..min.js gc.spread.sheets.core...***..min.jsgc.spread.sheets.sparklines...***..min.js |
Table |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.js (optional, for formulas and filters)gc.spread.sheets.core...***..min.jsgc.spread.sheets.bindings...***..min.js (optional, for data-binding)gc.spread.sheets.conditionalformatting...***..min.js (optional, for filtering)gc.spread.sheets.filter...***..min.js (optional, for filtering)gc.spread.sheets.tables...***..min.js |
Slicer |
|
Slicer Component |
gc.spread.common...***..min.js |
Slicer |
gc.spread.common...***..min.jsgc.spread.calcengine...***..min.jsgc.spread.sheets.core...***..min.jsgc.spread.sheets.conditionalformatting...***..min.jsgc.spread.sheets.filter...***..min.jsgc.spread.sheets.tables...***..min.jsgc.spread.sheets.floatingobjects...***..min.jsgc.spread.sheets.slicers...***..min.js |
The core js must always be loaded. The calcengine js must be loaded first in order to use functions. Many features use the calcengine js so you may wish to load it first. If you use a function from a js file that has not been loaded, the function does not take effect.
The js files are located in the pluggable folder under the main Spread.Sheets scripts folder.
Using Code
This example uses basic Spread.Sheets functions.
JavaScript |
Copy Code |
<!DOCTYPE html> Spread.Sheets Pluggable Sample Spread.Sheets Pluggable Sample Spread.Sheets Pluggable Sample Spread.Sheets Pluggable Sample Spread.Sheets Pluggable Sample Spread.Sheets Pluggable Sample Spread.Sheets Pluggable Sample |