[mdlug] Macro Language in Libre Office

[Jeff Hanson]

No idea myself but I've been interested in it.  I have encountered a few
compatibility issues between Excel and Calc.  Indirect addressing
translation (semicolons vs. commas) Calc can't automatically fix, and Calc
has lower row/column number limits.  This D&D 5e character generator
spreadsheet is an extreme example of what Calc can't handle.  It includes
VBA macros:
http://www.enworld.org/forum/rpgdownloads.php?do=download&downloadid=1234

On Sat, May 27, 2017 at 4:19 PM, musichall at juno.com <musichall at juno.com>
wrote:

> Since I am migrating from Windows to some flavor/variant of Linux, I am
> considering engaging an effort to migrate VBA code (both for MS Word and MS
> Excel) to something corresponding to what is more native to the Linux
> realm.The work in Excel involves reading values (both numbers and
> corresponding text) into an 'array', sorting the "array" (I use the word
> array more as a discussion concept rather than as a specific method, but
> not to preclude/exclude its use), making some calculations with the
> numbers, then modifying (i.e. entering) some other blank cells with the
> results. The work in Word involves primarily page layout of given text:
> text organizing/manipulation or rather paragraph manipulation, keeping the
> text the same, but modifying presentation e.g. bold, underline, etc. I have
> been looking into both Mint and Fedora (more at Mint at the moment for this
> exercise) - both recent releases. Both releases appear to have included
> LibreOffice (LO). That's fine. With VBA, I have a
>  lready learned that 'mind-set' which applies to both applications, and I
> am looking for whatever (single) appropriate language to use in LO. My
> question is essentially which macro language to pursue for this work:
> LibreOffice Basic or Python? From what I've been able to gather, Python is
> more "powerful" (whatever that means), though LibreOffice Basic is supposed
> to be easier to transition to from VBA. What more might I consider using
> Python for? Thanks in advance for your help.
> ____________________________________________________________
> 3 Common Foods Surgeons Are Now Calling "Death Foods"
> 3 Harmful Foods
> http://thirdpartyoffers.juno.com/TGL3131/5929df9e5473c5f9e7014st01vuc
> _______________________________________________
> mdlug mailing list
> mdlug at mdlug.org
> http://mdlug.org/mailman/listinfo/mdlug
>