Thu 7 May 2020
Can we get a huzzah for updated Domino Limits?
Wed 29 Apr 2020
A bigger boat: when in Rome
Mon 27 Apr 2020
HCL Notes 11 - Quick Intro to features and enhancements
OpenSesame: What kind of extension is "Edit View in Spreadsheet" anyway?
Wed 21 Mar 2007, 09:54 PMTweet
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:
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")
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.
What has been said: