Offset values
Opened this issue · 4 comments
I am using V 1.5.7
The offset values are interpreted as:
[top, bottom, left, right]
and not as the documentatiosn tells:
[top, right, bottom, left]
Maybe usefull to have an example with the offset too.
And offset in percentages is not working as expected.
hmm interesting. the code seams fine. perhaps you could add a jsbin (for example based on this) to show off the problem?
Negative values in percentage are also not working.
I too have found that OFFSET doesn't work when it points to a cell that calculates a percentage. Frustrating limitation, but my work around has been to create a second column that just points to the cell that does the calculation. Then I point my offset to the cell that just has the value, rather than the calculation for percentage.
Example: Let's say column A is date, column B is my total, and column C is my partials. Column D calculates that row for C/B, and shows a percentage.
If my OFFSET points to a cell in column D, it will just return 0.
So my workaround was to create a column E that just points to the calculated value in column D. Then setup my OFFSET so that it points to E.
-Silly limitation to run into.