-
-
Notifications
You must be signed in to change notification settings - Fork 11
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
The Python plugin has about a 20% chance of freezing when opening Excel. #97
Comments
This is a difficult one, of course I cannot easily replicate it! Does it happen when you have non of your own code loading via xlOil? Does it happen when you start Excel with a blank workbook |
Yes, I have a personal macro workbook that should have an impact. Removing it greatly reduces the chance of freezing. |
Here is my entry code
|
Are you able to give me some debug-level logs of when the problem does and doesn't happen? I've reviewed the code and nothing stands out as a possible timing error. |
My custom addin entry is MyAddin.X. I use blank file to test. excel freezed when open some larger file,or xlsm file.The patterns that emerge are quite random. I tested a scenario with a relatively high probability (1/3): opening and then closing multiple xlsm files larger than 2M each(Maybe it's not related to the file size, but to the complexity and time consumption of the calculations.). The Excel window becomes unresponsive, and it seems that the log file also stops recording. I post my settings and the log file below. The malfunction has been eliminated if I uninstall xloil plugin
Here is log file:
|
Here is ok log
|
…g up of settings reading code. Should help with Github #97
Thank you for the debugging help here! I've added a new ini file option in xlOil 0.18.8: |
The latest version 0.18.8 has significantly reduced freezing issues. However, importing A.py from the entry file and updating functions registered in A.py will cause errors. Hot reload only works in entry file.
|
When enabling the Python plugin, there is a certain probability that Excel may become unresponsive, requiring the process to be forcibly terminated.
The text was updated successfully, but these errors were encountered: