Libreoffice, excel macros problem

users
#1

Hi;
So that's what I want to use Excel Table LibreOffice program.
I tried, but not translated, I'd like your help ...
Attached tables.

#2

Hi :slight_smile:
LibreOffice uses a different version of Basic for it's macros so you might
need to rewrite some, or just avoid using macros altogether.

Microsoft macros have been used as an attack vector for a lot of malware
over the years. Once again they say their system is safe now but later we
will probably find out different. One of the things that makes their system
more secure is the pop-up that blocks macros and asks permission before
allowing them to run.

I think LibreOffice also allows other languages, such as Python,
Jellybean(?) and something else but i get the impression most people start
with Basic. These chapters from the official guides might help a bit:
Ch 13 in the "Getting Started Guide"
https://wiki.documentfoundation.org/Documentation/Publications
and chapter 12 in the Calc Guide.

Andrew Pitonyak's guide is a good in-depth guide if you need more. It might
cost money but it's well worth it.
https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers
It's at the bottom of the Programmers section . Andrew also helps out on
this list (as well as in the Documentation Team (guess who wrote the
chapters in the free guides?) and on the French Team but even if he is busy
there are other people on this list who might be able to help.

Is the macro short enough to post the whole bit of coding directly into an
email? This list doesn't accept attachments so we didn't see what you tried
to send last time. You can use Nabble to upload things. Use the "More"
button and then the "Upload" button is the top option. Probably better to
just post the code into an email so everyone can read it easily. The
mailing list is publicly accessible so please avoid giving any confidential
information
Regards from
Tom :slight_smile:

#3

Thanks for the kind words.... but you can download the latest updated copy for free from my web site.

http://www.pitonyak.org/OOME_3_0.odt

#4

Hi :slight_smile:
Thanks :)  Just done that :)  So it is even more worth the money! 
Thanks and regards from
Tom :slight_smile: