vallettea
Support of arrays operations (MMULT, INVERSE, TRANSPOSE with Ctrl+Shift+Enter)
Salut, I discovered Pycel a few days ago, and tried (and failed) to add Excel array functions for it. (primarly MMULT, but also TRANSPOSE, and ideally INVERSE).
In my Excel files, I have a few matrix operations that I either enter using Ctrl+Shift+Enter (array formula in curly brackets https://support.office.com/en-us/article/guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7 ) or that I combine with Index (=INDEX(MMULT(arr1, arr2),row,col)).
It's only after these few days using Pycel, that I found your koala! Sounds great, more functions, but still not MMULT available.
Do you think it will be available one day? Any technical reasons that make it difficult to implement (e.g. cell references of arrays?)
Great work!
Hello, thanks for your interest. I think (but i'm not compeltely sure since this part wasn't coded by me and it was quite some time ago) that there are already cells referecing arrays in koala. However, we have no time to implement other function.
All the recent functions were implemented by the community. It's just a matter of having the time to dig in the code and make a pull request.
feel free to give it a shot. Best,
@iOiurson just added some docs that could help you: https://github.com/anthill/koala/blob/master/doc/index.md
Merci! Very relevant. I'll have a look at it and come up with a new version of MMULT when I have some time.