OpenSesame: What kind of extension is "Edit View in Spreadsheet" anyway?

Wed 21 Mar 2007, 09:54 PM

Tweet

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