Fri 3 Sep 2021
When Notes table data doesn't play nicely with others
Mon 21 Jun 2021
Custom Domino Extensions presentation
Thu 10 Jun 2021
Notes 12 without all the blue
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: