Before install: winecfg , locate riched20.dll and set it to native.
All common things that LibreOffice is capable to do , seems to work with a few tested sheets.
What does not
I have a XLSM file: I know it has macros that must create a new sheet and other elements to Sheet 1. But it does not works, and no clues why, not even an error message. The macro is silently ignored, a whole number of lines and a new sheet was not dynamic created as expected.
What was not tested
I did not created my own VBA macros yet.
FreeBSD wine package: i386-wine-devel-2.1,1
|Operating system||Test date||Wine version||Installs?||Runs?||Used|
|Current||FreeBSD 11.0 x86_64||Sep 17 2017||2.11||Yes||Yes||No||Bronze||Marcel Bonnet|
|Show||Ubuntu 16.04 "Xenial" amd64 (+ variants like Kubuntu)||Jun 30 2016||1.6.2||Yes||No||Garbage||an anonymous user|
|Show||Ubuntu 14.04 "Trusty" i386 (+ variants like Kubuntu)||Jun 17 2015||1.6.2||Yes||Yes||Bronze||an anonymous user|
|Show||Gentoo Linux x86_64||Sep 15 2013||1.7.0||Yes||Yes||Silver||Alexander Makarov|
|Show||openSUSE 12.3 x86_64||Jul 23 2013||1.6||Yes||Yes||Silver||Daniel Uto|
|Bug #||Description||Status||Resolution||Other apps affected|
|14980||Wine does not automatically use the riched20 installed by Office 2003/2007/2010/2013/2016||REOPENED||View|
|19534||Office 2007 menu button loses focus||NEW||View|
|20950||Excel 2007 changes .xls modification date on shutdown||UNCONFIRMED||View|
|23108||Excel & Powerpoint 2003/2007: can't switch between open documents from taskbar, misplaced taskbar icon||NEW||View|
|23805||Word / Excel 2007: issues with maximalized/windowed switching on dual monitor||UNCONFIRMED||View|
|29255||Microsoft Office 2003, 2007 & 2010 applications do not print OTF||NEW||View|
|29347||Excel 2007: previews saved under Wine do not display in either Wine or Windows||NEW||View|
|30587||Office 2007/2010 apps (Word, Powerpoint) cannot be maximized after being unmaximized by window manager||NEW||View|
|37383||Office 2007/2010 - Submenus invisible on GNOME 3.14||UNCONFIRMED||View|
|37396||MS Word 2007 & 2010: Word can't save as PDF/A(ISO 19005-1) (needs sRGB Color Space Profile.icm)||NEW||View|
|38774||Execute MS Excel 2007 macro crashes Excel||NEEDINFO||View|
|42459||Bogus/orphan small window sibling of Office 2007 applications||UNCONFIRMED||View|
Follow the directions in the entry for Microsoft Office (installer only) to install.
After installing, set riched20.dll to native,builtin in winecfg. This is needed for some dialog boxes and numbers on graphs to display properly. It is not necessary to install the dll with winetricks, as Office installs its own version. Do not set this override globally unless you have Office installed in a separate wineprefix.
Workarounds for bugs 23805 and 30587:
Solution 1: Run in an emulated virtual desktop. This is probably the easiest solution for most users.
Solution 2: Uncheck "Allow the window manager to control the windows" in winecfg. The downside is that Excel will no longer show up in the taskbar.
Solution 3: (KDE users only) In System Settings, Window Behavior, do the following: