OpenSesame: @DbColumn on a spreadsheet
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:

with the spreadsheet:
Copyright © 2007 Genii Software Ltd.
|