Friday, February 13, 2009

Visual Basic macros do not work in Office 2008 for Mac

We got a question regarding an XML spreadsheet from a customer using Mac today. The macros didn't work in Microsoft Office 2008 for Mac, which they were upgrading to.

Asked my friend Google, and this is what he found for me: Visual Basic macros do not work in Office 2008 for Mac.

I don't know if Lotus Symphony supports Mac/VBA Macros, but if it did, it would be somewhat amusing.. :D

Trigger onChange immediately for checkboxes, radiobuttons and comboboxes in the Client

This was a new discovery for me. I mostly work on web applications, but the last week, I've been working in the Client exclusively.

When changing a setting on a combobox, I caught sight of the above setting, "Run Exiting/OnChange events after value change". This little gem changes the behavior of comboboxes, checkboxes and radiobuttons, so that the OnChange/Exiting events fires immediately after the user has changed the value, instead of having to wait until the field loses focus.

The setting is a per field setting, so you can mix and match according to your needs.

Thursday, February 5, 2009

Tip: Edit files as UTF-8 in DDE

Most of my CSS/HTML files are UTF-8, due to working with them in Aptana, which is set to UTF-8 by default. When working with the same files in the new editor in Domino Designer 8.5, the default format is Cp1252, which messes up my mystical Norwegian characters, æ, ø and å.

To change this, open Preferences for the designer. Goto General -> Workspace. Set Text file encoding to UTF-8 (or UTF-16 if need be).