Running Excel on Ubuntu: Solver & Macro crashes
first of all I would like to say that I am a total noob at linux / ubuntu.
I have just migrated from Windows 7 and so far I feel quite satisfied with the change.
I've tried using LibreOffice but VBA Macros there don't run quite well. So I downloaded PlayOnLinux and installed Office 2010, but when I try to run a Macro or use the Solver Add-In, Excel crashes.
Is there a way this problem could be fixed? Or how do i make LibreOffice to run my macro without errors?
Thanks in advance
libreoffice playonlinux
asked Aug 5 '13 at 18:37
lbochittlbochitt
1615
add a comment |
first of all I would like to say that I am a total noob at linux / ubuntu.
I have just migrated from Windows 7 and so far I feel quite satisfied with the change.
I've tried using LibreOffice but VBA Macros there don't run quite well. So I downloaded PlayOnLinux and installed Office 2010, but when I try to run a Macro or use the Solver Add-In, Excel crashes.
Is there a way this problem could be fixed? Or how do i make LibreOffice to run my macro without errors?
Thanks in advance
libreoffice playonlinux
asked Aug 5 '13 at 18:37
lbochittlbochitt
1615
add a comment |
first of all I would like to say that I am a total noob at linux / ubuntu.
I have just migrated from Windows 7 and so far I feel quite satisfied with the change.
I've tried using LibreOffice but VBA Macros there don't run quite well. So I downloaded PlayOnLinux and installed Office 2010, but when I try to run a Macro or use the Solver Add-In, Excel crashes.
Is there a way this problem could be fixed? Or how do i make LibreOffice to run my macro without errors?
Thanks in advance
libreoffice playonlinux
asked Aug 5 '13 at 18:37
lbochittlbochitt
1615
first of all I would like to say that I am a total noob at linux / ubuntu.
I have just migrated from Windows 7 and so far I feel quite satisfied with the change.
I've tried using LibreOffice but VBA Macros there don't run quite well. So I downloaded PlayOnLinux and installed Office 2010, but when I try to run a Macro or use the Solver Add-In, Excel crashes.
Is there a way this problem could be fixed? Or how do i make LibreOffice to run my macro without errors?
Thanks in advance
libreoffice playonlinux
libreoffice playonlinux
asked Aug 5 '13 at 18:37
lbochittlbochitt
1615
asked Aug 5 '13 at 18:37
lbochittlbochitt
1615
asked Aug 5 '13 at 18:37
lbochittlbochitt
1615
asked Aug 5 '13 at 18:37
lbochittlbochitt
1615
asked Aug 5 '13 at 18:37
lbochittlbochitt
1615
1615
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Libre Office online help mentions the incompatibility with MS Office macros. (Using Microsoft Office and LibreOffice):
With a few exceptions, Microsoft Office and LibreOffice cannot run the
same macro code.
Nevertheless, they suggest some macros may still work:
The most recent versions of LibreOffice can run some Excel Visual
Basic scripts if you enable this feature at LibreOffice -
PreferencesTools - Options - Load/Save - VBA Properties.
However, I suspect your macros are pretty complex. This is one of the issues converting to Linux 100%-- the rest of the world still uses the MS Office suite, it does its job well, but is not fully open standards compliant. I hate to suggest this, but have you considered installing Windows as a virtual machine (such as VirtualBox) inside Ubuntu just to use Excel? VirtualBox is available in the Ubuntu Software Center, and you will need a licensed Windows CD and MS Office CD to install them in Virtual Box.
answered Aug 5 '13 at 19:58
PJ SinghPJ Singh
4,43232550
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f329019%2frunning-excel-on-ubuntu-solver-macro-crashes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Libre Office online help mentions the incompatibility with MS Office macros. (Using Microsoft Office and LibreOffice):
With a few exceptions, Microsoft Office and LibreOffice cannot run the
same macro code.
Nevertheless, they suggest some macros may still work:
The most recent versions of LibreOffice can run some Excel Visual
Basic scripts if you enable this feature at LibreOffice -
PreferencesTools - Options - Load/Save - VBA Properties.
However, I suspect your macros are pretty complex. This is one of the issues converting to Linux 100%-- the rest of the world still uses the MS Office suite, it does its job well, but is not fully open standards compliant. I hate to suggest this, but have you considered installing Windows as a virtual machine (such as VirtualBox) inside Ubuntu just to use Excel? VirtualBox is available in the Ubuntu Software Center, and you will need a licensed Windows CD and MS Office CD to install them in Virtual Box.
answered Aug 5 '13 at 19:58
PJ SinghPJ Singh
4,43232550
add a comment |
Libre Office online help mentions the incompatibility with MS Office macros. (Using Microsoft Office and LibreOffice):
With a few exceptions, Microsoft Office and LibreOffice cannot run the
same macro code.
Nevertheless, they suggest some macros may still work:
The most recent versions of LibreOffice can run some Excel Visual
Basic scripts if you enable this feature at LibreOffice -
PreferencesTools - Options - Load/Save - VBA Properties.
However, I suspect your macros are pretty complex. This is one of the issues converting to Linux 100%-- the rest of the world still uses the MS Office suite, it does its job well, but is not fully open standards compliant. I hate to suggest this, but have you considered installing Windows as a virtual machine (such as VirtualBox) inside Ubuntu just to use Excel? VirtualBox is available in the Ubuntu Software Center, and you will need a licensed Windows CD and MS Office CD to install them in Virtual Box.
answered Aug 5 '13 at 19:58
PJ SinghPJ Singh
4,43232550
add a comment |
Libre Office online help mentions the incompatibility with MS Office macros. (Using Microsoft Office and LibreOffice):
With a few exceptions, Microsoft Office and LibreOffice cannot run the
same macro code.
Nevertheless, they suggest some macros may still work:
The most recent versions of LibreOffice can run some Excel Visual
Basic scripts if you enable this feature at LibreOffice -
PreferencesTools - Options - Load/Save - VBA Properties.
However, I suspect your macros are pretty complex. This is one of the issues converting to Linux 100%-- the rest of the world still uses the MS Office suite, it does its job well, but is not fully open standards compliant. I hate to suggest this, but have you considered installing Windows as a virtual machine (such as VirtualBox) inside Ubuntu just to use Excel? VirtualBox is available in the Ubuntu Software Center, and you will need a licensed Windows CD and MS Office CD to install them in Virtual Box.
answered Aug 5 '13 at 19:58
PJ SinghPJ Singh
4,43232550
Libre Office online help mentions the incompatibility with MS Office macros. (Using Microsoft Office and LibreOffice):
With a few exceptions, Microsoft Office and LibreOffice cannot run the
same macro code.
Nevertheless, they suggest some macros may still work:
The most recent versions of LibreOffice can run some Excel Visual
Basic scripts if you enable this feature at LibreOffice -
PreferencesTools - Options - Load/Save - VBA Properties.
However, I suspect your macros are pretty complex. This is one of the issues converting to Linux 100%-- the rest of the world still uses the MS Office suite, it does its job well, but is not fully open standards compliant. I hate to suggest this, but have you considered installing Windows as a virtual machine (such as VirtualBox) inside Ubuntu just to use Excel? VirtualBox is available in the Ubuntu Software Center, and you will need a licensed Windows CD and MS Office CD to install them in Virtual Box.
answered Aug 5 '13 at 19:58
PJ SinghPJ Singh
4,43232550
answered Aug 5 '13 at 19:58
PJ SinghPJ Singh
4,43232550
answered Aug 5 '13 at 19:58
PJ SinghPJ Singh
4,43232550
answered Aug 5 '13 at 19:58
PJ SinghPJ Singh
4,43232550
4,43232550
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f329019%2frunning-excel-on-ubuntu-solver-macro-crashes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
