A curious friend wrote and asked, "What kind of extension is that 'Edit view in spreadsheet' anyway?" It is a good question, but has a non-obvious answer. Right now, it is callable in three ways. It can be called as part of a larger LSX, in which case the call I use is something like:
Sub Initialize
Dim ws
As New NotesUIWorkspace
Dim session
As New NotesSession
Dim db
As NotesDatabase
Dim sheet
As New OpenSesameSpreadsheet
Set db
= session.CurrentDatabase
If ws.CurrentView
Is Nothing Then Exit Sub Call sheet.GenerateView
(db.Server
, db.FilePath
, ws.CurrentView.ViewName
, "c:\temp\trial.ods"
)End Sub or it can be called as part of a formula language extension, in which case you could have a smart icon like this:
@DbCommand(
"OSODF":
"NoCache";
"EditViewInSpreadsheet";
@DbName;
@ViewTitle;
"c:\\temp\\trial.ods");
or it can be in a menu addin so that the
Action menu simply has an entry called "
Edit View in Spreadsheet". My guess is that I will sell it with the latter two choices, so that you can either add it to your Action menu or add it to a smart icon, but you could also call it from the web or from Java or from LotusScript or anywhere else a formula can be evaluated. That would be the most flexible.
Copyright © 2007 Genii Software Ltd.