Offset values

[maartenvanbenthem]

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.

[maartenvanbenthem]

And offset in percentages is not working as expected.

[thenikso]

hmm interesting. the code seams fine. perhaps you could add a jsbin (for example based on this) to show off the problem?

[ianldgs]

Negative values in percentage are also not working.

[Khaos-Storm]

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.