Language Selection

English French German Italian Portuguese Spanish

OpenOffice.org Calc adds support for Excel VBA

Filed under
OOo

As an Excel user, you may have looked at OpenOffice.org and found that it doesn't support Visual Basic for Applications (VBA), the Microsoft Office macro language. If you've spent years building hundreds of Excel macros, the fear of losing them all could keep you locked in to Office. If so, it's time to look again; Novell has taken OpenOffice.org's source code and create a version of its own that supports Excel VBA.

Novell's Noel Power is the developer in charge of introducing Excel VBA interoperability into OpenOffice.org Calc. He says that the interoperability is achieved by:

* allowing Excel VBA macros to run natively within OpenOffice.org;
* providing a compatibility object model;
* continuously improving the compatibility model by identifying and implementing the most useful and widely used APIs;
* extending the symbols available to ooo-basic to include the compatibility API; and
* modifying the core ooo-basic runtime to handle Excel VBA syntax.

Noel says, "Novell is pushing this to the wider community. The source code is freely available from the OpenOffice.org Hackers Pages, and instructions on how to build it are on the OpenOffice.org build page. Additionally, we are pleased to say that we are also shipping the VBA interoperability feature with Novell's branded OpenOffice.org versions for Windows.

Full Story.

More in Tux Machines

Another great experience in Fedora bug reporting: Wine font fix solves my web-browsing problem

Fedora‘s motto is “Freedom. Friends. Features. First.” I’m here to tell you Fedora lives up to that billing. Why do I say this now? I’ve just had another positive experience with Fedora, this time in finding a bug in my system, adding my information to an existing bug report and now seeing updated packages pushed to the Fedora 20 stable repositories and onto my system, where the problem has been fixed. Read more

GNU hackers discover HACIENDA government surveillance and give us a way to fight back

GNU community members and collaborators have discovered threatening details about a five-country government surveillance program codenamed HACIENDA. The good news? Those same hackers have already worked out a free software countermeasure to thwart the program. Read more

The top 14 hidden features in Windows, iOS, and Android

You may think you're a high-tech power user who knows all the nooks and crannies of Windows, iOS, and Android, but let's be realistic: There could be at least a few undocumented (or poorly documented) commands, control panels, and apps that have slipped by you—maybe more than a few. We've dived deep into each OS to uncover the best hidden tips and tricks that can make you more productive—or make common tasks easier. Got a favorite undocumented tip to share with readers? Add them in the comments section at the end of the article. Read more

Android-on-ARM mini-PC draws less than 7W

The DSA2LS runs a pre-installed Android 4.2.2 (Jelly Bean) with integrated online or offline update functionality on a dual-core, 1GHz Freescale i.MX6 DualLite system-on-chip. The SoC has a Vivante GC880 GPU that’s not as powerful as the Vivante GC2000 GPU found on the Dual and Quad i.MX6 models, but it still plays back 1080p video and offers 3D graphics acceleration. The power-sipping DualLite enables the fanless computer to run at a modest 6.26W active and 1.42W standby, according to Shuttle’s AnTuTu benchmarks. Read more