Ben Langhinrichs

Photograph of Ben Langhinrichs

IBM Champion logo

E-mail address - Ben Langhinrichs

Recent posts

Tue 12 Jun 2018

Presenting at Collabsphere 2018 - hope to see you there

Tue 12 Jun 2018

CKEditor #5 - Powering plugins with other extensions

Mon 11 Jun 2018

CKEditor #4 - Use Domino design elements in plugin

June, 2018
     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

Search the weblog

Genii Weblog

OpenSesame: @DbColumn on a spreadsheet

Thu 22 Mar 2007, 11:58 PM

by Ben Langhinrichs
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.

What has been said:

586.1. Tim Tripcony
(03/22/2007 10:43 PM)

Whoa. Now that's cool. Just curious, are you anticipating that UNC paths will be supported for the file location?

586.2. Ben Langhinrichs
(03/23/2007 03:31 AM)

Certainly. They work now. I just tried

@DbColumn("OpenS"; "\\\\hamster\\cdrive\\share\\trial.ods"; "Sheet1"; "F4-F999");

and it works fine (\\hamster being a shared network drive here where I copied the file). Watch for the parameters possible for @DbLookup, as I think they are very cool (Rocky Oliver helped me think them up).

586.3. Ben Langhinrichs
(03/23/2007 04:41 AM)

I should also point out that when this ships, it should also work with an attached ODS file, probably with the syntax:

@DbColumn("OpenS"; @DbName; @DocumentUniqueID; "MyInvoice.ods"; "Sheet1"; "F4-F999");

and there may be other variations. It is just likely people would want to act on an attached spreadsheet.