Ben Langhinrichs

Photograph of Ben Langhinrichs

E-mail address - Ben Langhinrichs






March, 2007
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 31

Search the weblog





























Genii Weblog


Civility in critiquing the ideas of others is no vice. Rudeness in defending your own ideas is no virtue.


Wed 21 Mar 2007, 09:54 PM
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.

Wed 21 Mar 2007, 07:35 AM
Kathy Sierra has a wonderful post titled Is your app an ass-kisser? 
If your app was an employee, what kind of employee would it be? When it's employee performance review time, how would you rate it? These are just a few of the apps I've worked with recently...
Even aside from the provocative title, this is a clever and concise way to think about your applications... and possibly avoid making your application one of these dudes duds.

Copyright © 2007 Genii Software Ltd.