Hi Joachim,
glad to hear that your add-in works now. Well not everything was
possible but you are able to workaround the multiple returns.
I would suggest that you take a look on new add-in with a configuration
file to define the new add-in function 8with localization if you want).
This new approach has several advantages and it would be nice if you can
support this. I know it is not so important for you because your add-in
works but i think it is worth to support the latest features at least
for new implementations.
Or did you already have an xcu file for your add-in?
Juergen
Joachim Dahl wrote:
> Hi Andreas,
>
> I think the Python UNO bridge works fine; I managed to return an
array
of
> values by using an array function.
> I needed to return multiple arrays of different lengths; to give a
> specific
> example I made a wrapper around a
> linear programming solver with input arguments 'c' (a vector), 'G' (a
> matrix) and 'h' (a vector). This routine
> outputs a status string, a vector 'x' and a vector 'z', and I used
an
> IDL
> as
>
> string lp ([in] sequence < sequence <double> > c,
> [in] com::sun::star::table::XCellRange x,
> [in] sequence < sequence <double> > G,
> [in] sequence < sequence <double> > h,
> [in] com::sun::star::table::XCellRange z);
>
> i.e., I used the XCellRange as a way to return additional variables by
> "writing back" values in x and z. This approach
> works well for me in Python.
>
> The only problem I have left is that I have optional arguments, some
of
> which are also "output" argument (albeit, in
> the sense of being XCellRanges), but that's not possible with a Calc
> add-in. So my work-around for this problem
> is to have a different function 'lp2' with more arguments (all
mandatory).
>
> But in summary, the Python UNO bridge seems fine for writing add-ins.
>
> Joachim
>
>
>
> On 5/25/07, Andreas Saeger <[EMAIL PROTECTED]> wrote:
>>
>> Joachim Dahl wrote:
>> > me.
>> >
>> > So my problem is not so much of how to write a prototype of an
>> addin, but
>> > rather how to
>> > implement something more advanced like "methodFour".
>> >
>> > Joachim
>> >
>>
>> Hi Joachim,
>> http://wiki.services.openoffice.org/wiki/CompleteAddIn has a chapter
>> "Transforming sequence of sequence into array". This describes the
same
>> problem as I tried to explain with my simple Basic function
TWICE(array)
>> in http://www.oooforum.org/forum/viewtopic.phtml?t=57196. Only
>> array-functions, such as the built-in LINEST, can return more than
one
>> value. The resulting array has to be converted to a 2-dimensional
matrix
>> rather than a list of lists. So it is possible that python alone is
not
>> suitable for add-ins that deal with sheet functions in array context.
>>
>> Andreas
>>
>> ---------------------------------------------------------------------
>> 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]
