Genii Weblog

Civility in critiquing the ideas of others is no vice. Rudeness in defending your own ideas is no virtue.

Thu 22 Mar 2007, 11:58 PM
Another one of my "projects" as part of OpenSesame (see earlier post on Edit view in spreadsheet) is the ability to do an @DbColumn or @DbLookup on an OpenDocument spreadsheet in Notes 8.  This is what I have working tonight::

Colors := @DbColumn("OpenS""c:\\temp\\trial.ods""Sheet1""F4-F999");
Colors := @Implode(@Trim(@Unique(Colors)); ",");
@Prompt([Ok]; "All Colors"; Colors);

gives a result of:

Results of @DbColumn

with the spreadsheet:

Spreadsheet view of data

Copyright 2007 Genii Software Ltd.

Thu 22 Mar 2007, 12:32 PM
Just thought I'd share the fact that the Edit view in spreadsheetdescribed recently has a nice side benefit.  Since I am using revision tracking, you can send a copy of a view to someone else and have them change what they think they should, even someone without Notes using, for example, and when you get the file back, you will see the modified cells.  If you mouse over a modified cell (this is from the Beta 2 Lotus Spreadsheets), you get the following.  You can even pass it to multiple people and see who changed what.

Screen shot of revsion markings on edited view

Copyright 2007 Genii Software Ltd.