Ben Langhinrichs

Photograph of Ben Langhinrichs

E-mail address - Ben Langhinrichs






March, 2007
SMTWTFS
    01 02 03
04 05 06 07 08 09 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31

Search the weblog





























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 OpenOffice.org, 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.