OpenOffice.org Templates
More help from the folks at the OpenOffice blog, this time on templates. Good article.
More help from the folks at the OpenOffice blog, this time on templates. Good article.
I ran into a problem with the formatting in cells today for sorting. I was trying to sort a number of dates, and they kept sorting as strings. I set the format of the cells to the appropriate date format, made sure all the cells were showing up that way, and tried the sort again….
In using OpenOffice Writer for preliminary work on manuscripts I often need to replace large amounts of formatting, mainly eliminating areas in which writers have used character formatting and replacing them with consistent use of styles. The native search/replace is not very good for this. There is an excellent solution, readily available: The AltSearch addon. …
In a previous post I provided code for a simple macro I wrote to export text from an Office Writer document that was suitable to paste in the non-visual WordPress editor. The reason I wrote this was to produce the minimal HTML necessary without cluttering the resulting document. Occasionally I write in Writer and then…
I’ve uploaded a new version of the 6×9 booklet template (previously here) set up for table of contents, index, and various headers and footers. I’ve used more variables to reduce the amount of user input. You should plan to edit this as a template first, as it contains my publishing information (Energion Publications set currently…
On a spreadsheet I needed to enter a formula in one cell and then fill down with that formula over a range. My first thought was that, as in VBA, I would record a macro and get the commands. I sometimes do that when I just can’t remember and am too lazy to look everything…
There’s a good article on this at OpenOffice.org Training, Tips, and Ideas. It’s probably just my style, but I find the entry editor harder to use than creating macros, so I like to find these good point by point directions.