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.
A person with a toolkit generally spends a bit of time learning to use the tools in it, otherwise he or she will get limited benefit from the tools available. It’s important to have the right tools, and it’s also important to learn how to use them effectively. This post applies in that general sense…
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….
Update: Please see my next try at this. If you mess up the count of instances of “scripture index” in the rather unhandy way I found the scripture index you could get some nasty results. The new one fixes that. I have finally gotten the first draft of the little routine I mentioned earlier for…
The formulas for this, which will work in LibreOffice (or OpenOffice) Calc, are to be found at User Offline: How to write a spreadsheet formula for ISBN-10 to ISBN-13 and ASIN. Considering that post is dated in 2008, I thought it worthwhile to add another link. I wanted to do this, but to ISBNs with…
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…
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…
(Note: Page author Henry Neufeld is compensated for sales made through links on this page.)