Language Selection

English French German Italian Portuguese Spanish

Book review - Learn OpenOffice.org Spreadsheet Macros

Filed under
OOo

My name is John Dukovich. I'm with Green Moon Solutions, a small technology company in the Washington, DC, area. I've been working with Microsoft Office applications, basically since they came out, and I'm a heavy user of Excel macros and Visual Basic for Applications language. I do quite a few applications for clients and use macros in ways that a lot of people don't.

Instead of just manipulating spreadsheet information, there's a lot of behind-the-scenes calculations and user GUI interface kinds of things that I do. So I'm quite familiar with Excel macros. I shied away from OpenOffice Calc for quite a while because initially I heard the macro feature wasn't as good as Excel's. And years ago, there wasn't a good conversion between the two.

However, when I got my hands on this book, OpenOffice.org Spreadsheet Macro Programming, I was curious and hoped to find I was wrong, that this would open up new opportunities for clients and organizations that want to get away from Microsoft Office, clients who are already using OpenOffice, so I was really interested to see the level of capability that Calc had in its macro programming.

rest here




More in Tux Machines

digiKam Software Collection 4.3.0 released...

After a long bugs triage, we have worked hard also to close your reported issues.. A long list of the issues closed in digiKam 4.3.0 is available through the KDE Bugtracking System. Read more

Seneca College realizes value of open source

Red Hat has done a lot of work with CDOT, lately specializing in Fedora for ARM processors. Pidora, the Fedora Linux Remix specifically targeted to the Rasberry Pi, was primarily developed at CDOT. Another company that we have been working with lately is Blindside Networks. They do a lot of work with CDOT on the BigBlueButton project, which is a web conferencing tool for online education. NexJ is a Toronto-based software development firm that has worked with CDOT on various aspects of open health tools on the server side and integration of medical devices with smart phones. We have recently started working on the edX platform, where developers around the globe are working to create a next-generation online learning platform. Read more

Today in Techrights

Initial impressions of PCLinuxOS 2014.08

I spend more time looking at the family trees of Linux distributions than I do looking at my own family tree. I find it interesting to see how distributions grow from their parent distribution, either acting as an extra layer of features which regularly re-bases itself or as a separate fork. New distributions usually tend to remain similar in most ways to their parent distro, using the same package manager and maintaining similar philosophies. When I look at the family trees of Linux distributions one project stands out more than others: PCLinuxOS. Read more