Add find() command and direction constants #64

New Issue

glen · 2019-08-23T23:07:42Z

glen commented

2019-08-23 23:07:42 +00:00

Need a find(condition, stride, start) macro that will find the first cell starting at start (which defaults to the current cell) along the stride for which condition evaluates to true.

Should have direction constants right (= &(1,0,0)), left, up, down, above, below
to make this more readable. Note you can add right+down to get a diagonal stride.

Need a find(condition, stride, start) macro that will find the first cell starting at start (which defaults to the current cell) along the stride for which condition evaluates to true. Should have direction constants right (= &(1,0,0)), left, up, down, above, below to make this more readable. Note you can add right+down to get a diagonal stride.

glen referenced this issue from a commit

2019-08-28 19:54:13 +00:00

Implement a find() macro This macro looks at each cell along some stride through the sheet, returning the location of the first cell encountered at which a given expression evaluates to true, or boolean false otherwise. To make this more useful, this change also revamps the handling of boolean values, making them much more permissive and coercing to boolean type in fewer circumstances. It adds the bool() type conversion for explicitly coercing to boolean type, and fixes a small issue with reading hex-formatted floating-point values ('p' can be used as an exponent indicator). Closes #64.

glen closed this issue

2019-08-28 19:54:13 +00:00

Sign in to join this conversation.