back

by dosinga·3y ago·view on hn ↗
You are correct, that is the slicing syntax. We to carefully interpret the ":" in the right way. For example:

sort(l, lambda A:F1(A)) doesn't invoke

Sheet1[10:20] just returns the 10 to 20s row of that sheet, which I think is the most reasonable thing to do here

1 comments
I assume you mean rows 11 to 20 like the Python syntax would do or is it different because spreadsheet row numbers start at 1 instead of 0?
Ah, yes, sorry, just Python based slicing. It follows the numpy rules