Re: [api-dev] Scriptable Formula framework.

2008-07-19 Thread Paolo Mantovani
Il domenica 20 luglio 2008 00:56:50 Paolo Mantovani ha scritto:
 Hi Robert,

sorry, I meant to reply to Marcin


ciao
Paolo M

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [api-dev] Scriptable Formula framework.

2008-07-18 Thread Robert Vojta
On Thu, Jul 17, 2008 at 10:43 PM, Marcin Miłkowski [EMAIL PROTECTED] wrote:

 Unfortunately, Basic functions must be defined in the Standard module,
 otherwise they don't work. And therefore they cannot be packed in an
 extension.

If you put your new function in My macros, it doesn't work. But when
you put your function in any library stored within your calc document,
it works.

-- 
Robert Vojta


Re: [api-dev] Scriptable Formula framework.

2008-07-18 Thread Marcin Miłkowski

Robert Vojta pisze:

On Thu, Jul 17, 2008 at 10:43 PM, Marcin Miłkowski [EMAIL PROTECTED] wrote:


Unfortunately, Basic functions must be defined in the Standard module,
otherwise they don't work. And therefore they cannot be packed in an
extension.


If you put your new function in My macros, it doesn't work. But when
you put your function in any library stored within your calc document,
it works.



In other words, you cannot pack into the extension, right? It must be 
stored within the document. At least I couldn't find the way and the 
answer on the forum was that it's impossible.


I'm asking because there is a nice Polish numbers-to-words macro in 
Basic that we would love to pack into an extension instead of making 
users to copy and paste macros...


Regards,
Marcin

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[api-dev] Scriptable Formula framework.

2008-07-17 Thread Alexandro Colorado
Before I create a feautre request I really want to verify that this is not  
possible currently or can be solved with an easier workaround.


Basically can the formulas call on the scripting java backend to generate  
calculations in java/basic/python.


The idea basically is to write the formula in java/python/basic and load  
it as a Calc function. This basically turn the function classes  
programable and develoeprs can come up with their own calc functions to  
perform non-existent formulas.


Example: RealState(propertyvalue, morgage rate, period)


--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [api-dev] Scriptable Formula framework.

2008-07-17 Thread Marcin Miłkowski
Look for AddOns in the Wiki. It's possible to define your own Calc 
functions in Java, Basic (to an extent)... There are some extensions 
that insert numbers as natural language words as a special Calc function 
and they are basically AddOns.


Regards,
Marcin

Alexandro Colorado pisze:
Before I create a feautre request I really want to verify that this is 
not possible currently or can be solved with an easier workaround.


Basically can the formulas call on the scripting java backend to 
generate calculations in java/basic/python.


The idea basically is to write the formula in java/python/basic and load 
it as a Calc function. This basically turn the function classes 
programable and develoeprs can come up with their own calc functions to 
perform non-existent formulas.


Example: RealState(propertyvalue, morgage rate, period)





-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [api-dev] Scriptable Formula framework.

2008-07-17 Thread Alexandro Colorado

ok good to know. can you forward me the wikipage url?

On Thu, 17 Jul 2008 13:52:26 -0500, Marcin Miłkowski [EMAIL PROTECTED]  
wrote:


Look for AddOns in the Wiki. It's possible to define your own Calc  
functions in Java, Basic (to an extent)... There are some extensions  
that insert numbers as natural language words as a special Calc function  
and they are basically AddOns.


Regards,
Marcin

Alexandro Colorado pisze:
Before I create a feautre request I really want to verify that this is  
not possible currently or can be solved with an easier workaround.
 Basically can the formulas call on the scripting java backend to  
generate calculations in java/basic/python.
 The idea basically is to write the formula in java/python/basic and  
load it as a Calc function. This basically turn the function classes  
programable and develoeprs can come up with their own calc functions to  
perform non-existent formulas.

 Example: RealState(propertyvalue, morgage rate, period)




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [api-dev] Scriptable Formula framework.

2008-07-17 Thread Marcin Miłkowski

http://wiki.services.openoffice.org/wiki/Calc/Add-In

It's an Add-In, not an Add-On, sorry for causing confusion.


Alexandro Colorado pisze:

ok good to know. can you forward me the wikipage url?

On Thu, 17 Jul 2008 13:52:26 -0500, Marcin Miłkowski [EMAIL PROTECTED] 
wrote:


Look for AddOns in the Wiki. It's possible to define your own Calc 
functions in Java, Basic (to an extent)... There are some extensions 
that insert numbers as natural language words as a special Calc 
function and they are basically AddOns.


Regards,
Marcin

Alexandro Colorado pisze:
Before I create a feautre request I really want to verify that this 
is not possible currently or can be solved with an easier workaround.
 Basically can the formulas call on the scripting java backend to 
generate calculations in java/basic/python.
 The idea basically is to write the formula in java/python/basic and 
load it as a Calc function. This basically turn the function classes 
programable and develoeprs can come up with their own calc functions 
to perform non-existent formulas.

 Example: RealState(propertyvalue, morgage rate, period)




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]








-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]