Transpose?

[infinity77]

Hi,

I'm using Koala2 for the first time on a rather simple Excel file (i.e., nothing with 45,000 formulae as mentioned in the PyCel site). However, it doesn't work, meaning I don't get the expected results after changing the inputs. The excel file contains a few TRANSPOSE calls that I naively implemented in excellib simply returning the original numeric values i.e., I don't do anything. But I guess that's not the right approach... Any suggestions on how I may tackle the TRANSPOSE calls?

[bleucitron]

Hello there ! We indeed didn't set up the library to use cases like TRANSPOSE yet.

I need a little more time to investigate, but it is most probable that your calculation is incorrect because the actual Excel TRANSPOSE function changes the cells pointed by the function. So if you don't point towards the correct cell, the result will be mechanically different.

I can't check right now, but i will as soon as possible and get back to you.