patronas / opuxl Goto Github PK

Actually the result matrix is created in the active sheet starting at active cell.
Usually it should be created starting the original cell containing the function call.

Example:

• function fn(string s, int start, int end) gives back a column vector of numbers
• We have two cases:
  s="M" --> result is the vector [start, start+1, start+2, ..., end]
  s="F" --> result is the vector [start+10, start+11, start+12, ..., end+10]

Assume we write the formula in cell A5 and we use cell A1 as reference for the first parameter s.

So:

• A1 contains M
• in A5 we write the formula: =fn(A1;1;100)
  That produces the vector [1,2,3,...,100] in cells A5,A6,A7,...,A105

Now we change the parameter in cell A1 from M to F.
That produces the vector [11,12,13,...,110] in cells A2,A3,A4,...,A102
So the second function call overwrites the function in cell A5.

(My) expectation:
result is updated in the original area, in the example in cells A5,A6,...

I think, the problem is using the active cell instead of the cell containing the function call which is actually performed.

public object display()
        {
            Excel.Application app = (Excel.Application)ExcelDnaUtil.Application;
            Excel.Worksheet worksheet = (Excel.Worksheet)app.ActiveWorkbook.ActiveSheet;
            Excel.Range startCell = app.ActiveCell;

            var propKey = "" + startCell.Row + PROPERTY_DIVIDER + startCell.Column;

Hope my explanation is clear enough.

Excel returns "Error while executing Function" if the Java function returns a Java object.

XLLOOP supports object handles, so that objects can be used as arguments for other functions.

Is it possible for opuxl to support that too?

current:

• different properties are hardcoded

target:

• IP, Port, Function Prefix should be configurable by a config file which should be placed next to the .XLL file.

Eg.: config.ini

ip=127.0.0.1
port=56789
prefix=Opus

I downloaded 2 files below
https://github.com/PATRONAS/opuxl/raw/master/opuxl_addin/Opuxl/OpuxlClassLibrary/Opuxl.xll
https://github.com/PATRONAS/opuxl/raw/master/opuxl_addin/Opuxl/OpuxlClassLibrary/Opuxl.dna

Installed Opuxl.xll add-in, the add-in appeared in the add-in list and was activated/ticked

Closed Excel

Started Java DemoServer

Console showed "[Thread-0] INFO de.patronas.opus.opuxl.server.OpuxlServer - Opuxel Server Socket startet on port: 61379"

Started Excel, Opus functions weren't registered, =Opus.GetSeries(3) returns #NAME?

Java process was OK, I was able to telnet to 127.0.0.1:61379, so it looks like the add-in couldn't create a connection