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

Red Hat Financial News

Leftovers: OSS and Sharing

  • What does it mean to change company culture?
    Tools are specific concrete things that a culture has decided is a way to improve a process. Buckminster Fuller has a great quote about tools and thinking: "If you want to teach people a new way of thinking, don't bother trying to teach them. Instead, give them a tool, the use of which will lead to new ways of thinking." In particular, DevOps tools can provide folks new ways to look at things—like delivering code into a production environment, for example. But there's lots of examples where a new tool doesn't influence the thinking of the people who use it, so things don't change.
  • Why Open Beats Closed
  • Google Improves Image Recognition; Releases Project as Open Source Software
    Google says its algorithm can correctly caption a photograph with nearly 94 percent accuracy. The company says the improvements come in the third version of its system named Inception, with the score coming from a standardized auto-caption test named ImageNet. It reports the first version scored 89.6 percent, the second 91.8 percent and the new one 93.9 percent.
  • Contributing to Open Source Projects Not Just For the Experts
    XDA has long been a proponent of open source development, and we’ve seen it flourish over the years. In fact, it’s one of the main reasons our community has grown as fast as it has over these past 13 years, with Android’s core being the driving force. Many people desire to be part of open source and contribute but often don’t know how they can, whether because they think they lack the skills or they just don’t have the time.
  • Firefox Reader Mode is Finally Getting a Keyboard Shortcut
    Among the changes which arrived in the September release of Firefox 49 were an enhanced set of Reader Mode features, including spoken narration and line-width spacing options. All very welcome. But the improvements aren’t stopping there. Firefox 50, which is due next month, will add another sorely needed feature: a keyboard shortcut for Reader Mode. Y
  • Introduction to OpenStack by Rich Bowen
    In this talk, Rich, the OpenStack Community Liaison at Red Hat, will walk you through what OpenStack is, as a project, as a Foundation, and as a community of organizations.
  • How Microsoft Measures Open Source Success [Ed: Wim Coekaerts got a bigger salary offer from Microsoft than from Oracle so now he’s propagandist/EEE in chief]
  • Public licenses and data: So what to do instead?
    Why you still need a (permissive) license Norms aren’t enough if the underlying legal system might allow an early contributor to later wield the law as a threat. That’s why the best practice in the data space is to use something like the Creative Commons public domain grant (CC-Zero) to set a clear, reliable, permissive baseline, and then use norms to add flexible requirements on top of that. This uses law to provide reliability and predictability, and then uses norms to address concerns about fairness, free-riding, and effectiveness. CC-Zero still isn’t perfect; most notably it has to try to be both a grant and a license to deal with different international rules around grants.
  • NIST Releases New 'Family' of Standardized Genomes
    With the addition of four new reference materials (RMs) to a growing collection of “measuring sticks” for gene sequencing, the National Institute of Standards and Technology (NIST) can now provide laboratories with even more capability to accurately “map” DNA for genetic testing, medical diagnoses and future customized drug therapies. The new tools feature sequenced genes from individuals in two genetically diverse groups, Asians and Ashkenazic Jews; a father-mother-child trio set from Ashkenazic Jews; and four microbes commonly used in research. NIST issued the world’s first genome reference material (NIST RM 8398)—detailing the genetic makeup for a woman with European ancestry—in May 2015. Together, all five RMs serve as a collection of well-characterized, whole genome standards that can tell a laboratory how well its DNA sequencing processes are working by measuring the performance of the equipment, chemistry and data analysis involved.
  • ANSI Seeks Organizations Interested in Serving as U.S. TAG Administrator for ISO Technical Committee on Blockchain and Electronic Distributed Ledger
  • Industrial IoT leaders work towards interoperability and open source collaboration

LLVM News

  • Pairing LLVM JIT With PostgreSQL Can Speed Up Database Performance
    Using the LLVM JIT with PostgreSQL can vastly speed up the query execution performance and shows off much potential but it hasn't been mainlined yet. Dmitry Melnik presented at this month's LLVM Cauldron over speeding up the query execution performance of PostgreSQL by using LLVM. Particularly with complex queries, the CPU becomes the bottleneck for PostgreSQL rather than the disk. LLVM JIT is used for just-in-time compilation of queries.
  • LLVM Cauldron 2016 Videos, Slides Published
    The inaugural LLVM Cauldron conference happened earlier this month ahead of the GNU Tools Cauldron in Hebden Bridge, UK. All of the slides and videos from this latest LLVM conference are now available.

A quick introduction to Audacity for teachers

School's back in session, and kids love the creative arts. One of my favorite open source creative tools is Audacity, the open source audio recorder and editor. Students love manipulating digital sound with Audacity: making podcasts, learning languages, recording interviews, and recording and mixing music. I use it to record podcasts for students to provide instructions about classroom procedures and tests. Foreign language students use Audacity to record and play back their lessons. Students can download music and other types of audio tracks for sharing and re-use from Creative Commons and Wikimedia, and dub their own voices onto music tracks, the sounds of birds chirping, whales and dolphins in their natural habitats, and more. Read more