I'm doing some debugging for a problem I have regarding formulas not getting parsed correctly. Its getting there but I discovered some strange behavior when doing some testing using a formula that includes variables from a different sheet.
For example, I have the following formulas:
The first one works, the second one does not. (The name "diåmeter" is intentional)
The first formula is taking values from the same sheet as the second formula and vice versa.
However, the sheet named "Variabler" is first in order, and "Uträkning" is second.
If I change the order of the sheets, and then change "setActiveSheetIndex()" accordingly, then the first one fails (resulting in #N/A) and the second one fails.
It seems like I can only collect variables from sheets having a higher indexnumber than the sheets Im working in.
Why is that?