vallettea / koala

Transpose your Excel calculations into python for better performances and scaling.
GNU General Public License v3.0
147 stars 59 forks source link

What is the use of the associated cells #179

Closed danielsjf closed 5 years ago

danielsjf commented 5 years ago

I'm trying to debug an issue with row ranges (e.g. Sheet1!5:5). The problem is that some of them get reference cells and others don't. When they get a reference cell, the evaluation function returns only this reference cell which is obviously a very different solution from the range.

Would it be possible to explain what this is used for?

My issue might be related to #40 as it's more likely to run into these issues when a full row/column is selected.

For reference, these are the lines I'm referring to.

brianmay commented 5 years ago

Unfortunately, my understanding of this particular piece of code is rather weak. As in I have no idea what it does. Still trying to understand what a reference cell is, and why some cells get them and others don't.

danielsjf commented 5 years ago

I still have no clue what it does exactly, but it seems that adding the empty cells to the ranges solves this issue.