I'd like to have a more sophisticated version of the "comment" facility in excel (the ability to tag a note to a particular cell, which when hovered over, is displayed on the screen). What I would like to be able to do is select a cell or cell region, and insert a comment on that region that is actually a function() applied to those cells.
An example would be being able to hover over 5 cells and the comment has a "sum()" function in it, so the sum of them is displayed. This would be for information used only intermittently on the spreadsheet that is not worthy of an on-screen tally.
To keep it simpler, the values in those comments couldn't be referenced by anything else, otherwise you get this weird three dimensional spreadsheet.
Posted by Nils Blutig at September 30, 2002 10:21 PM | TrackBack