• 09May
    Categories: Tech Comments: 8

    I was writing a paper today, and was groping for words. So I Alt-Tabbed to my thesaurus (Microsoft Encarta Dictionary) and punched in “thought”. I then Alt-Tabbed back to ooWriter and changed “thought” to “reflection”. On further reflection, I thought, “Surely there’s a thesaurus add-on, plugin, or extension for OpenOffice.” I searched high and low and finally through much Googling and scrounging through OpenOffice’s rather poorly designed site and series of wikis I finally discovered a thesaurus add-on. The download link didn’t work. So I Googled the file name and found a mirror. Then I went to the install instructions which told me to use the Open Office “Install new dictionaries wizard”. I opened this up which re-downloaded the thesaurus (as well as two other dictionaries) and installed them. So, all that to say, if you want a thesaurus in OpenOffice, do this:

    Go to File–>Wizards–>Install New Dictionaries…
    Follow the instructions.

    To use the Thesaurus, put your cursor on a word and hit Ctrl-F7. Or go to Tools–>Language–>Thesaurus. Somehow I prefer Ctrl-F7.

    Memo to OpenOffice team: It probably shouldn’t take a computer programmer an hour to install a thesaurus.

  • 18Mar
    Categories: Tech Comments: 0

    I have had some frustrations in the past trying to import an XLS file into our Access database–I would get a “Too many fields defined” Error 3190. I saw quite plainly that the spreadsheet had only 29 columns (the limit is 127). The problem was, I was using OpenOffice Calc (an excellent, free, spreadsheet program) to edit the XLS file. Whenever Calc saved the file as an XLS, it added a whole ton of extra columns, which it didn’t show. However, MS Excel showed the extra columns fine and I was able to delete them. Someone over at OpenOffice.org needs to squash this bug before it bites more people.