Topic | Description
What is jQuery.sheet? | jQuery.sheet is an intuitive javascript toolkit & jQuery plugin. It provides users with an easy way of making spreadsheets available in their applications.
How are spreadsheets constructed inside jQuery.sheet? | jQuery.sheet uses simple html table objects, they can be grouped together to make a spreadsheet with multiple sheets. Sheets are calculated into a spreadsheet using simple javascript in an efficient manner.
How are formulas calculated? | Formulas are calculated using the "formula" attribute of each html td object.
Can I export or import a spreadsheet into a different format? | Absolutely. Sheet supports xml, json, and html exporting and importing for sheets.
How do I access jQuery.sheet's methods? | On initiation jQuery.sheet creates the sheet object and stores it in jQuery.sheet.instance[] and as well in the jQuery dom object as "sheetInstance".
How can I change the spreadsheet theme? | Head over to jQuery UI ThemeRoller (http://jqueryui.com/themeroller/) and download one, and reference in the header of your webpage.

Option | Description | Default Value | Type | Accepted Values
urlGet | local url, if you want to get a sheet from a url | sheets/enduser.documentation.html | string |
urlSave | local url, for use only with the default save for sheet | save.html | string |
editable | bool, Makes the jSheetControls_formula & jSheetControls_fx appear | true | bool |
urlMenu | local url, for the menu to the right of title | menu.html | string |
NewColumnWidth | the width of new columns or columns that have no width assigned | 120 | int |
title | general title of the sheet group | null | string / object / function |
inlineMenu | menu for editing sheet | null | string / object / function |
buildSheet |  | false | bool / string / object | bool true - build sheet inside of parent bool false - use urlGet from local url string - '{number_of_cols}x{number_of_rows} (like 5x100) object - table
calcOff | turns calculationEngine off (no spreadsheet, just grid) | false | bool |
log | turns some debugging logs on (jS.log('msg')) | false | bool |
lockFormulas | turns the ability to edit any formula off | false | bool |
parent | sheet's parent, DON'T CHANGE | jQuery(this) | object |
colMargin | the height and the width of all bar items, and new rows | 18 | int |
fnBefore | fires just before jQuery.sheet loads | function() {} | function |
fnAfter | fires just after all sheets load | function() {} | function |
fnSave | default save function, more of a proof of concept | function() { jS.saveSheet(); } | function |
fnOpen | by default allows you to paste table html into a javascript prompt for you to see what it looks likes if you where to use sheet | function() { var t = prompt('Paste your table html here'); if (t) { jS.openSheet(t); } } | function |
fnClose | default close function, more of a proof of concept | function() {} | function |
fnAfterCellEdit | fires just after someone edits a cell | function() {} | function |
joinedResizing | this joins the column/row with the resize bar | false | bool |
boxModelCorrection | attempts to correct the differences found in heights and widths of different browsers, if you mess with this, get ready for the must upsetting and delacate js ever | 2 | int |
showErrors | will make cells value an error if spreadsheet function isn't working correctly or is broken | true | bool |
calculations | used to extend the standard formulas that come with sheet | {} | object |
cellSelectModel | Excel sets the first cell onmousedown active, openoffice sets the last, now you can choose how you want it to be ;) | excel | string | excel, oo, gdocs
autoAddCells | Automatically adds new cells if set to true when you press down or tab at the last cell in the row or column | true | bool |
caseInsensitive | Make cells and formulas not sensitive to case, you can use SUM(A1) or sum(a1) | false | bool |

Method | Detail
$.sheet.makeTable.xml(xmlData) | returns table object(s)
$.sheet.makeTable.json(jsonData, makeEval) | returns table object(s)
$.sheet.makeTable.fromSize(size, height, width) | returns table object(s)
$().sheetInstance | After initiation, the sheetInstance is returned for manipulation
$.sheet.instance[] | After initiation, the sheet instance is pushed into this array for manipulation
$().sheetInstance.exportSheet.xml(skipCData) | returns a table as xml
$().sheetInstance.exportSheet.json() | returns a table as json
$().sheetInstance.exportSheet.html() | returns the sheet as an html object
$().sheetInstance.kill() | Removes current sheet from document.
$.sheet.killAll() | Removes all sheets from document.

Hosted By: Visual Interop Development | VisOp-Dev.com
jQuery.sheet | jQuery.sheet - The Web Based Spreadsheet
Version |
Written By | Robert Plummer
Written Using | Notepad++
Compressed Using | YUI Compressor
Compatibility | Firefox 3, IE 7 & 8, Chrome, Safari
Consulting Services | Visual Interop Development
Issues | #VALUE!: undefined
Need a feature or support? | Tell Me
PLEASE DONATE | Buy my a couple gallons of gas :)