Ben Langhinrichs

Photograph of Ben Langhinrichs

E-mail address - Ben Langhinrichs







Recent posts

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


June, 2022
SMTWTFS
   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: What kind of extension is "Edit View in Spreadsheet" anyway?

Wed 21 Mar 2007, 09:54 PM



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.

What has been said:

No documents found