Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


Hi :)
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 :)




On 9 March 2015 at 06:33, Stefan Weigel <stefan.weigel@bildungskreis.org>
wrote:


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



Am 08.03.2015 um 22:51 schrieb Xbot:
Thanks for your answer Stefan,

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

Le 08/03/2015 22:39, Stefan Weigel a écrit :
Hi,

Am 02.03.2015 um 15:52 schrieb Xbot:

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







--
LibreOffice - Die Freiheit nehm' ich mir!

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.