Many people write far more now that they are constantly online than in the pre-Internet age. Most of this activity is limited to Web or office-style publishing. People either write something that will only appear inside some Web browser or a traditional “document”, that is a single file, more or less nicely formatted for printing. Very often, however, they don’t do it in the most efficient way.
DB2 pureXML is IBM software for management of XML data that eliminates much of the work typically involved in the management of XML data.The OpenDocument Format (ODF) is an open international standard for office texts, presentations and spreadsheets that is very simple to process or generate automatically. This page is a short synthesis of an article published in September 2010 by N. Subrahmanyam, Using DB2 pureXML and ODF Spreadsheets, to give an idea (see my comments at the end) of how flexible ODF scripting is. Please read the original full article to know how to actually generate ODF documents from DB2 pureXML files.
- Tell me and I may write about it Computers and software should make life easier and help us to save time (and money), not waste it. Many commercial programs are (or look) much more polished, complete and user friendly because they let you do the simplest things very quickly and easily, just clicking around in a graphical interface. The downside of all this simplicity is that it is can be very hard or time consuming to do anything above that first level of usage.
- How to support Free Software tips and tricks at Zona-M (or any other website!) Keeping up and running a good website, regularly adding original, useful and easy to use content, is a difficult task that requires a lot of time and effort. As you can read on my online business card, over the years I have accumulated lots of experience and information about how Free Software works. With this website I intend to provide a useful service, for free, to all users of Free Software, by reformatting and publishing all those informations in a really usable way.
Slideshows are extremely popular as presentation and educational tools, but have a couple of serious problems. The first is readability: let’s admit it, many slideshows are almost unusable. One of the secrets to useful slideshows is terseness. Each slide should contain only a few short points or pictures which summarize the key concepts you want to transmit to the audience with that part of your talk.
Sooner or later, many of us need to process some numeric data in plain text format, be they system logs or sales totals, and to generate reports and charts out of those data. Scripts and utilities like gnuplot could be very useful in such cases, except when the results needs to be a normal spreadsheets with charts and formulas, which is both editable and compatible with people who only know how to deal with spreadsheets in office suites.
How do you quickly create a spreadsheet where, for example, every other line has a background of a different color? Here are a couple of methods.
The first one is faster (and works even in controlled environments where you can’t install extensions) if you want white rows alternated with colored ones: define a cell style and apply it only to cells in even (or odd) rows. Here is the detailed procedure: