Be the first to post a text review of Objectsheet. Rate and review a project by clicking thumbs up or thumbs down in the right column.

• Code committed

  rknopman committed revision 50 to the Objectsheet SVN repository, changing 12 files

  posted by rknopman 89 days ago

• Objectsheet V0.6.3 Released

  The Objectsheet is a spreadsheet-like tool that organizes rows of cells into Javascript objects and organizes formulas, formats, styles, event handlers, etc. into "Templates". Benefits include analytical capabilities beyond the spreadsheet, better maintainability of models, and strong database-like analysis capabilities. Documentation is at http://richk.net/objectsheet In this release, TableSections now have .preHTML and .postHTML values that, when set, cause html content to be placed immediately below the section's titlebar and above the lower resize bar, respectively. Easiest way to set this is in the misc cell. This release also fixes minor bug.

  posted by rknopman 287 days ago

• File released: /objectsheet/0.6.3/objectsheet0.6.3.zip

  posted 288 days ago

• objectsheet 0.6.3 file released: objectsheet0.6.3.zip

  Tables: >>TableSections now have .preHTML and .postHTML values that, when set, cause html content to be placed immediately below the section's titlebar and above the lower resize bar, respectively. Easiest way to set this is in the misc cell. >> Fixed bug in ::focus() to correctly grab the focus when there are hidden rows. >> Fixed bug where keyboard shortcuts bomb with undefined property objects. >> Fixed bug in Tables where sorting was done on incorrect columns (was using regex matching instead of equality testing, thus matching subsets of column name). Other: >> toDate() prep function: Fixed design error where a single mask letter would translate to attribute without leading zero-- single letter mask would easily collide with other text in the mask string. Fixed logic so 2 letter mask maps to attribute without leading zero and preceeding 2 letter mask with a zero maps to attribute with leading zero. >> Improved peformance of File.ie.save() >> Added "view source" file menu option. In sections menu, clicking on section name brings that section into view. Fixed bug where loading .csv files would change File.currentFile-- it's just supposed to instead merge the file in. Made csv import smarter.

  posted 288 days ago

• Objectsheet V0.6.2 Released

  The Objectsheet is a spreadsheet-like application where cells reflect an object-oriented data structure and that helps organize formulas, formatting, styles using "templates", and input/output forms and code. The Objectsheet documentation is at http://richk.net/objectsheet This release includes a great many minor updates to improve stability and improve analaysis functionality.

  posted by rknopman 449 days ago

• File released: /objectsheet/0.6.2/Objectsheet0.6.2.zip

  posted 449 days ago

• objectsheet 0.6.2 file released: Objectsheet0.6.2.zip

  Tables >> Fixed bug in toggleButton display function where where action was not triggering correctly for single value parameter (supposed to trigger action formula only instead of cycling among values). >> Changed table name cell delimiter for "alternate name" from ">" to ":". Only the alternate name is shown when the template is locked.\n >> Added database-like select() (array) and where() (table) methods. >> Tables: forcePrep behavior-- prefixing "*" to a prep formula forces one-time application of formula to all values in that column). If there are formulas in the column, forcePrep converts it to be a simple value and applys the prep formula to that value. >> Tables:Changed table name cell delimiter for title (where table shows title instead of column name) _when_ lockTemplate == 1 from ":" to ">". >> Setting a Table column to name individual cells in another column ("=" prefix or postfix) now does bounds checking to ensure "=" points to an existing column. >> Enabled hiding of table columns by setting style cell in template to "display:none". This hides the column when the property template is hidden. >> Added "export HTML" feature (see File menu) >> Added "pasteNames" option (see Edit menu); if checked, copy objects and paste objects include column names. Other >> created HTMLSection::focusName and HTMLSection::selectName to allow automatic selection and focus of named html input elements. >> sum() function is now more flexible: accepts inputs as any mix of arguments, arrays, and objects. Sums all numbers found in all arguments. >> String::toArray() now accepts any regular expression as a delimiter >> Added database-like select() (array) and where() (table) methods. >> Fixed bug in .histogram where keys passed in as array. >> Fixed bug in histogram() (code actually in valrange()) where non-numeric keys get converted to numbers). >> Removed forced conversion to number in valrange() to allow non-numeric categories to form part of histogram. >> Array::collect now has a flag indicating that null values are to be kept (default is that they are removed). >> Fixed bug in Math.engu(). >> toDate() now parses masks for time as well as date >> In function Math.zfill(n,p), fixed bug where n == 0 was returning one character "0" for any p (number of decimal places) instead of p 0's. >> Added toTime(n) and prepTime(str) to allow a column's values to be a relative time. Input and out format is hh:mm:ss; value stored internally is the number of milliseconds. e.g., prepTime("0:01") = 1000. >> Added optional delim parameter to String.protoype.toArray(). This forces the delimiter to be delim. Also added item to edit menu to allow user to specify delim. >> In HTML sections, can set <select> values with option text only (no longer require value="...") >> Fixed security permissions problem of erroneously requesting \UniversalXPConnect and \UniversalBrowserRead. >> toggleButton() display formula, when used with a single argument, toggles that value on-off. >> corrected topic rollovers bug in osRef.html. >> fixed bug in menu item File > Save Packaged didn't work correctly for mozilla/mac >> Fixed bug in Array::min and Array::max (empty array case) >> Objectsheet saves all variables that happen to be in the namespace of HTMLSections and ScratchSections. >> Renamed user-redefinable parameters Panel.DEFAULT_VIEW_LEFT and Panel.DEFAULT_VIEW_TOP to Panel.MARGIN_LEFT and Panel.MARGIN_TOP respectively.

  posted 449 days ago

• Objectsheet V0.6.1 Released

  In this release, the Objectsheet is now a single standalone html file that can be directly saved from the browser. Objectsheet applications can also be saved within the source content (a la tiddlywiki) and distributed as a single file. The basic Objectsheet functionality also works with the Safari browser. Load/save functionality for Safari is planned.

  posted by rknopman 724 days ago

• File released: /objectsheet/0.6.1/Objectsheet_V0.6.1.zip

  posted 726 days ago

• objectsheet 0.6.1 file released: Objectsheet_V0.6.1.zip

  core.js: separated CONSTRAIN_STYLE and HILITE_STYLE out of respective functions. Changed Calc_prep documentation topic labels to Table_prep. Removed Math.fraction and prepFraction. These are not really core-- maybe include these as part of an importable js file. Removed hist()-not used. os_mgr: removed image preloading at top of file-- looks like no value. Removed keyboard shortcut for "paste data as new table". Added back in copyObjects() and pasteObjects() tableSection: removed Tablesection.setObjectCount() . us.length=... works just as well. Fixed bug in updateNoUndo(): needed parenthesis to invert "instanceof Array" test. table: removed prevs() method-- not being used. Fixed typo ("pName") in pasteValue(). tableCell: changed onOffArray parameter to include buttonCSS instead of separator (since it was never used). forced textarea() default cols to be 1 so that table doesn't grow temporarily wide in Moz. tableSection: changed DEFAULT_DISPLAY to be actual text() function, not string version to be eval()'d. In updatePanel, fixed cell not readonly bug for Moz. when lockTemplate. Cleaned up error reporting in updateDisplay(). osRef.html: corrected css path.

  posted 726 days ago