Hi,
first of all I'm new to this group. I hope I'm not complete OT and I beg
you to tell me if I do anything wrong in this group.
Now to my question: I managed to develop a new component implementing
the Service AddIn and the first AddIn-Function I wrote took a string as
argument and returns a double. That was my first test and it works well.
Now - beginning the real quest - I want to write an Add-In-Function
taking a cell as Argument and returning another cell as result. Such a
function would be very needful for me as an auxilliaryfunction. My
problem is $subject - You could not have an argument of type cell (o.k.
it could be a cellRange but this is not really what I want) and you can
have in no way a returnvalue of type cell.
Can one explain why Add-In-Functions do have this restzrictions?
Can one tell me if there is a workaround which lets me solve e.g. the
following task:
I have an Add-In-Function - lets call it evalResult - which takes a
string as argument and returns a double.
Now I want do the following:
In a sheet - call it round5 - of my document there are the results of
the matches of the teams and the players of the teams in round 5 of the
tournament. In another sheet - lets say parameters - there is a cell
containing the name of my team.
Now I want to have a formula in the first cell of column G such that I
get the value I would get when evalResult would be used on the text one
line under and one column right of the cell where I found the name of my
team. In the second cell of column G the referenced cell should be that
two lines under and one column right of the "teamNameCell". So I want to
write Add-In-Functions - e.g. called getText and searchRelative - so
that I can use the formula
=evalResult(getText(searchRelative( parameters!$B$1, "searchRange",
"row(thisCell)", 1 )
but then searchrelative must be able to return a cell as result!!
You can argument I just could write a function evalResultRelative which
can take all the arguments and returns a double directly. This is true -
but(!) I do need the function evalResult as described and I do need the
searchRelative-technic in several places and circumstances in the whole
document.
So: again -
1) why do Add-In-Functions have this restrictions
and
2) is there a workaround solving the problem in such a way that I can
write the modular functions I want.
I hope my questions are clear enough and I hope I'm in the right
newsgroup for this questions
Thanks in advance for any help and greetings from
Holger Walliser
P.S.: I tried to post this questions yesterday but there did not appear
a posting of me - so I try it again now.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
