You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
@cunnane thanks for providing us with such a nice library! It enabled us to write excel UDFs / RTD functions with great ease.
I am facing a little issue - please have look and see if you can help me on that. Thanks in advance.
Python 3.12.3 (32 bit)
Windows 10
xloil 0.18.7
xloil does not disconnect the initial rtd function call after arguments to the function are modified.
This happens only for the first call to a function.
for the consequent modifications (with arguments other than the initial one), xloil disconnects those instances successfully.
consider the following rtd function:
@xloil.func(rtd=True)asyncdefecho_num(num: int):
while (True):
yieldstr(num);
logging.debug(f"{echo_num.__name__}(\"{num}\"): yielded at {datetime.datetime.now().strftime('%H:%M:%S')}");
awaitasyncio.sleep(4.0);
steps to reproduce:
open excel
in any cell write down the following
=echo_num(100)
you will see "100" to be displayed in the cell as expected.
in the log you can see messages coming in with an even interval of 4 seconds
edit the cell to have function argument '200' instead of '100'
=echo_num(200)
now, you can see log messages for both 100 and 200
edit the cell again to have any other number - say, 300
now, you can see log messages for both 100 and 300
(the call for argument 200 is successfully deregistered)
edit the cell again to have 100 back as argument
now, you can see log messages for 300 and log messages for 100 in twice the frequency (in every 2 seconds)
(the call for argument 300 is successfully deregistered - but functions got registered for initial 100, modified 300 and modified 100)
if you keep on repeating the above steps, as many times you modify the cell value to 100 that many number of function call sticks registered which would never get deregistered.
The text was updated successfully, but these errors were encountered:
@cunnane thanks for providing us with such a nice library! It enabled us to write excel UDFs / RTD functions with great ease.
I am facing a little issue - please have look and see if you can help me on that. Thanks in advance.
Python 3.12.3 (32 bit)
Windows 10
xloil 0.18.7
xloil does not disconnect the initial rtd function call after arguments to the function are modified.
This happens only for the first call to a function.
for the consequent modifications (with arguments other than the initial one), xloil disconnects those instances successfully.
consider the following rtd function:
steps to reproduce:
open excel
in any cell write down the following
=echo_num(100)
you will see "100" to be displayed in the cell as expected.
in the log you can see messages coming in with an even interval of 4 seconds
edit the cell to have function argument '200' instead of '100'
=echo_num(200)
now, you can see log messages for both 100 and 200
edit the cell again to have any other number - say, 300
now, you can see log messages for both 100 and 300
(the call for argument 200 is successfully deregistered)
edit the cell again to have 100 back as argument
now, you can see log messages for 300 and log messages for 100 in twice the frequency (in every 2 seconds)
(the call for argument 300 is successfully deregistered - but functions got registered for initial 100, modified 300 and modified 100)
if you keep on repeating the above steps, as many times you modify the cell value to 100 that many number of function call sticks registered which would never get deregistered.
The text was updated successfully, but these errors were encountered: