Re-thinking the online spreadsheet

Close your eyes and picture a standard set of Office productivity applications for PCs that have turned into Web applications.



Word processors turn naturally into Web-based word processors in which the browser can edit words as well as display them. Fine.



Presentation packages turn naturally into Web-based presentation packages in which web pages become slides. Fine.



Databases turn naturally into Web-based CRUD[1] applications in which Web-based forms are used to create/update data and web pages are used for reports and database browsing. Fine.



Spreadsheets turn into...what? The obvious thing to do would be to take a spreadsheet from an office suite and transplant its functionality into a browser. This can certainly work and various initiatives are under way doing exactly this. However, I cannot help feeling that there might be an opportunity to do something a little more interesting than just "functionality transplantation" in this case.



What is a spreadsheet really? At heart it is a collection of cells of information. Some of these cells are static, containing words, numbers, pictures and so on. Some of these cells are dynamic containing calculations. The calculations use information from other cells to compute interesting things. The cells that calculations use can themselves be calculations...and there you have it. Everything else about a spreadsheet is secondary.



Cells in a spreadsheet are not like paragraphs in a word-processor or slides in a presentation in one very critical aspect. Cells have addresses. Cells can be uniquely referenced by means of their row and column numbers. Cells can also be referenced by friendly names allocated to cells such as "gross profit" or "unit cost" and so on.



In a classical PC-based spreadsheet, all the cells referenced in a spreadsheet are local - mostly all contained within the same spreadsheet. Once Web-enabled, the "reach" of the spreadsheet in terms of the cells it could reference in calculations, explodes.



Time to close your eyes again. Picture a web-enabled spreadsheet in which cells can be referenced as URLs. Something like http://www.example.com/sheets/costings?R10C12



This says (roughly) "give me the cell at row 10, column 12 of the costings spreadsheet on example.com".



What does this look like underneath? It looks like an HTTP GET - the quark of the Web universe. Trivially implemented both by producer and consumer.

Sign up for ITworld's Daily newsletter
Follow ITworld on Twitter @IT_world

• Email
• Print
• Share
  • Slashdot
  • Digg
  • Stumble
  • Reddit
  • Newsvine