Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I have a spreadsheet writting in MS Excel, an .xls document, which contains macros. I'm having a problem finding a program what will allow me to open the document and the macros work.

I tried opening the document in LibreOffice and the macros won't work even though I went to Tools -> Options -> Load/Save -> VBA Properties -> and made sure Load Basic Code and Executable Code were both checked. I even went to Tools -> Options -> Security -> Macro Security -> and set it to Low. I converted the .xls document to a LibreOffice document and LibreOffice still won't run the macros.

I tried Gnumeric. Some of the macros seemed to work in Gnumeric but most of them didn't.

I installed Calligra and tried opening it with Sheets, but Calligra just freezes and I have to force quit out of it.

I do not have Windows, I do not own MS Office and have no means or desire to buy either one.

So, what other options are there left for me? I have been searching around Google/Bing but haven't found a solution yet. any thoughts or ideas? i'm running Xubuntu 12.04 64-bit. Thank you.

share|improve this question

1 Answer 1

This is not an Ubuntu question per se, but might be something new users may struggle with. In principle Excel macros only run in Excel, the language was not conceived to be portable. Here's what, for instance, the LibreOffice help says about it:

With a few exceptions, Microsoft Office and LibreOffice cannot run the same macro code. Microsoft Office uses VBA (Visual Basic for Applications) code, and LibreOffice uses Basic code based on the LibreOffice API (Application Program Interface) environment. Although the programming language is the same, the objects and methods are different.

In essence if you want a portable programme you should program on a portable platform. I'd say you have two options:

  1. Ask the author of the code to provide it to you on another language or support (I assume you are not the author since you don't own Excel).
  2. Purchase Excel and run it on Wine or PlayOnLinux
share|improve this answer
1  
TL;DR you can't make it run, you have to either use Excel on Wine/PlayOnLinux, or ask the macro author to recode it for LibreOffice's API. –  Thomas W. Sep 13 '13 at 18:08
    
Sorry for posting a TL;DR version in the comments, but... yeah some people just want the shortest answer. –  Thomas W. Sep 13 '13 at 18:10
    
What's a TL;DR? –  Luís de Sousa Sep 14 '13 at 13:47
    
TL;DR = "Too Long, Didn't Read". Basically the shortest possible summary point. For people that don't want to read all the details. –  Thomas W. Sep 14 '13 at 15:29
    
My answer contains 150 words. Perhaps you are mistaking AskUbuntu for Twitter? –  Luís de Sousa Sep 16 '13 at 7:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.