My favorites | Sign in
Project Logo
                
Search
for
Updated Aug 04, 2007 by steve.yen
TrimSpreadsheet  

TrimSpreadsheet

{ TrimSpreadsheet home -- download | community }

'''TrimSpreadsheet''' is a lightweight open-source JavaScript spreadsheet engine. It let's you work with spreadsheet data right in your web browser. As with all TrimPath components, the '''TrimSpreadsheet''' engine is written as 100% standards-based JavaScript and CSS. Spreadsheets are stored as HTML <table> markup, so it's easy to understand and embed into your own web pages. Merely assign a class of "spreadsheet" to your <table>, and the TrimSpreadsheet engine will do the rest. Anyone familiar with CSS can also easily create their own spreadsheet themes.

Demos

Want to see TrimSpreadsheet in action? Here's some demos...

Note: these demos run the latest, most featureful development code. Please see the download page if you want a stable prior release.

Features

  • Formulas.
    • SUM, COUNT, AVERAGE, MIN, MAX.
    • Math operators /+-, parenthesis.
    • Any JavaScript expression.
  • Styling And Fonts.
    • CSS styling fully supported.
    • Bold, italic, underline, left/center/right, etc.
  • Recalculation Engine Features.
    • Automated recalculations (by default).
    • API-controllable recalculations, for firing off big recalculations just when you want.
    • Cycle detection, so no infinite loops during recalculation.
    • The recalculation engine is '''cooperative''', so you can optionally programmatically split a large recalculation into multiple phases. If you expect users to have huge spreadsheets, this can help ensure that the engine does not lock up the browser UI.
    • The recalculation engine is a separate sub-component that can be used without the UI component.
  • Simple
    • TrimSpreadsheet follows unobtrusive JavaScript design principles, so a spreadsheet is as simple as an HTML <table>.
    • TrimSpreadsheet markup is human readable, highly semantic and search indexer friendly.
    • The TrimSpreadsheet engine is smaller than most Excel spreadsheets.
  • Hypertext Cell Contents.
    • HTML fragments are supported in your spreadsheet cells.
  • Cross-browser.
  • Configurable.
    • Scrollbars, row/column header bars, and formula controls are all controllable thru simple HTML markup.
  • Cool Only In A Browser
    • Only those who've programmed against DHTML/DOM would think this is neat, but regular spreadsheet users will yawn...
      • Header Row & Column Bars that (try) to stay put during scrolling.
      • Resizable Rows & Columns through mouse dragging.

More information

{ TrimSpreadsheet home -- download | community }


Comment by ashishwave, Aug 25, 2007

this is an excellent library. thanks:

1) Is there some say to make some cells uneditable. For example: i would like to make my ROW 1 (which will contain headings for a data entry app spreadsheet) as READ-ONLY.

2) If i want to select multiple cells and then copy by pressing Ctrl+C and then paste into other cells by pressing Ctrl+V (this feature is present in google spreadsheet)

3) is there any plan for arrow key navigation support in cells (this feature is present in google spreadsheet)

i may be asking for too much. But is there any roadmap to include some/all of these features.

bye :-) Ashish Ranjan ashishwave@yahoo.com

Comment by johncurtisgunther, Aug 06, 2007

Great initial tutorial, couldn't be clearer. Thanks!

Hosted by Google Code