T. J. Frazier wrote:
Andreas Saeger wrote:
You are using Excel as application development platform. ...
And why not? So do I. Stable, customizable, automatically
cross-platform, and free.
Excel is *what*?
* Menus and XML
All the menus (and toolbars) in OO.o are kept in XML files. Interfaces
are available to customize these to any desired degree. Considerable
recent work has made this easier, for the benefit of extensions.
So you've got to rewrite every single line of VBA code.
* Extensions
You may want to investigate packaging your software as an extension.
That avoids license problems, and makes user installation very easy.
After your 2000 lines of VBA code changed to 3500 lines of StarBasic.
* Incompatibilities
The OO.o Basic language is nearly 100% compatible with other Basic
variants. It is the Application Program Interface (API) elements that
are only partly compatible. The underlying models of OO.o are not, and
never were intended to be, compatible with Microsoft. To some extent,
the API tries to bridge this gap.
StarBasic is strictly procedural while talking to a 100% object oriented
API (and only that particular API). It has bugs, some of them severe. It
is slow. It comes with a tiny set of runtime functions.
* Further reading
I commend to your attention the wiki page of the Documentation Project:
http://wiki.services.openoffice.org/wiki/Documentation
Small snippets of that documentation (corrections) are written by me.
where you will find links to the Developer's Guide and the Basic
Programmer's Guide. You may wish to investigate Category:Extensions on
the wiki, as well.
HTH
I commend to your attention the big, old VBA solution linked in the top
post. It will run out some day or rewritten entirely but never converted
to some other spreadsheet application. Now it runs for every single
client. A rewrite for OOo gives how many additional clients?
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
