Calc issue: display bug

users
#1

Hi,

I've a display bug with a xlsm file opened with LO:

how it is displayed in Libreoffice (4.3.4.1 and 4.4.1.2) : http://i.imgur.com/1gmRFnF.png
how it is displayed in Excel (2007) : http://i.imgur.com/2ApxxVQ.png
the xlsm file: http://demo.ovh.eu/download/81443811d52fef29c48908a28e57b895/1.xlsm

How to fix it?

Best regards

#2

Hi,

It seems I got no answer to my previous message, did I something wrong? Do you need more explanations?

Best,

Eric

#3

Hi,

I've a display bug with a xlsm file opened with LO:

how it is displayed in Libreoffice (4.3.4.1 and 4.4.1.2) :
http://i.imgur.com/1gmRFnF.png how it is displayed in Excel
(2007) : http://i.imgur.com/2ApxxVQ.png the xlsm file:
http://demo.ovh.eu/download/81443811d52fef29c48908a28e57b895/1.xlsm

How to fix it?

Reduce your expectations. Especially because this file contains
VBA-Code.

Stefan

#4

Thanks for your answer Stefan,

About expectations, are you implying there is nothing to do to make this file working in LibreOffice?

#5

Hi Eric,

this might give you an idea:
https://www.google.de/?q=run+vba+macro+in+libreoffice

Perhaps it is possible to replicate the functionality by means of
LibreOffice. Probably this requires a programming expert who can
create the macro program in LibreOffice.
(http://www.libreoffice.org/get-help/professional-support/) Maybe
you can find an expert if you specifically ask for it here on the
list or on discuss@documentfoundation.org.

Greetings,
Stefan

#6

Hi :slight_smile:
If you can post the code in an email to this mailing list there are people
here who might be able to help directly with possible suggestions for
editing the code. It really depends on how long and complicated the code
is. Something really long but that turns out to have something very simple
and obvious might get a good answer. If the coding shows an interesting
problem then people might be interested in having a go at figuring it out.

Macros are known to create problems within MS Office and have so often
hidden malware that many email systems attempt to filter out any documents
that might contain macros. Also when trying to open a document in MS
Office nowadays it tends to display an alert and a warning. Additionally
each different version of MS Office has slight differences in the code that
it can run so you might well have to re-write or at least edit macros in
order to use on different versions of MS Office, and then edit again for
the next new version.

So although moving macro code to LibreOffice presents a few problems it is
not much more trouble than you would face trying to get those macros to
work properly on other versions of MS Office - but with the advantage that
LibreOffice's macros tend to be a LOT safer and don't often need upgrading
between different versions of LibreOffice or OpenOffice.

LibreOffice also allows people to write "Extensions" / add-ons / plug-ins
that tend to be a much better idea than as macro as they can be viewed and
even edited without digging around in a single document. There is a
special website for LibreOffice Extensions which might already have the
functionality you are trying to add. When people publish their Extensions
there, if they use an OpenSource license, then other people can help with
any bug-fixes or updates in the future.

Regards from
Tom :slight_smile: