ODF is the the only relevant "free and open" feature. Any of your
programs can generate perfectly valid office documents with a similar
feature set as in MS Office, usable with many different applications.
Translating a typical "VBA solution" to something equivalent in
Basic/Python/Java requires far more effort than writing the original VBA
leading from one vendor lock-in to another one. The whole programming
logic depends on one particular office application.
The infamous "VBA compatibility mode" covers some trivial methods and
properties but you can not be sure that your VBA does exactly the same
thing in this app as it used to do in the other app. It does not support
anything more sophisticated, no user interface elements, no complex
method calls (spreadsheet: sort, filter, conditional formatting,
validation, charts, pivots,...).
Bugs anyone?
print cDbl("1.234"), cDbl("1,234")
http://www.openoffice.org/issues/show_bug.cgi?id=65555 (so easy to
confuse this interpreter using simple variants).
The absence of class modules makes Basic perfectly incompatible with
slightly advanced "VBA solutions".
StarBasic is a simplistic embeddable facility for batches of API calls.
The runtime functions hardly invites anyone to write a program logic
(arrays anyone? hashes/dictionaries? string replacements? format? regex?
abandon all hope).
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
For additional commands, e-mail: dev-h...@openoffice.org
