I have two specific problems.
PROBLEM:
I have a Calc document containing macros that calls a custom DLL that
calls a database. The database must be opened before the other macros
will work. I associated the "open document" event to the "open database
macro".
The Calc document contains formulas that call the macros. Unfortunately,
every formula is called, and THEN the open document event is fired,
which attempts to open the database. I hacked a solution using a global
variable in the document, and I am able to catch the error, open the
database, and then reconnect. Is there a better event for me to use with
this calc document to open the DB before the formulas are called?
PROBLEM:
I am curious if this is a bug:
I have a formula such as =GetBalance(A1, B1, C1)
Assume that C1 has nothing in it. The value sent to GetBalance is zero,
even if I format the cell as text. I want to send an empty string. I can
do this using something like: =GetBalance(T(A1), T(B1), T(C1))
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
