DataPilots are OpenOffice.org Calc's equivalent of what MS Excel and other spreadsheets call pivot tables. Under any name, they are a tool for extracting and summarizing the information contained in ...
The features in question have been around in the app for quite some time, but if you’re new to it, then chances are you’ve never heard of it before, and that’s fine. The features we will cover are: ...
If you're coming fresh from Microsoft Excel, you might wonder where the Pivot tables are in OpenOffice.org Calc. The problem is, they're masquerading under the name of DataPilots. But, under any name, ...
Making the switch from Microsoft Office to OpenOffice can save you a lot of money on licensing fees, and it isn’t difficult &#151 most people get used to the changes quickly. But if you’ve been using ...
Note: This book review was conducted as an audio interview of macros expert John Dukovich, by Phil Shapiro, using Audacity, the free sound recording and editing software. The review is available in ...
I usually defend Excel come hell or high water. However, when it comes to regular expressions (regexes), even I admit that open-source LibreOffice Calc is superior: it treats them as native search ...