Wisdom is the prime thing

I’ve been very happy with the OpenOffice macro for dumping documents. However, recently I wanted to be able to dump Excel spreadsheets to tab-delimited text files, and not comma-delimited CSV files. In addition, I don’t want to have the apostrophes delimiting the fields. I had to do some research in the developer’s guide, but I put together a solution.

» Read the rest of this entry

Here is a simple macro to show all cells on the document with the identical text as this cell. I use it in OpenOffice Calc when I’m making the school schedule and I want to visually check that no one has parts too close. I have this macro configured to use F3, so I can just use the arrow keys to move through the schedule, and press F3 on each name. Pretty handy.

» Read the rest of this entry

Here is a beautiful macro in scheme, along with some test code at the bottom. This is a good example of the power of macros (not to be confused with C/C++ macros, which share neither beauty nor power with scheme macros).

» Read the rest of this entry

Here is a handy setup to automate dumping OpenDocument files to other formats. I’ve had to set this up on a few computers, and I tired of having to look up on the Internet how to do it each time.

» Read the rest of this entry