4 ms·
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
by dosinga 4y ago
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
- michaelmior 4y agoI 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?
- dosinga 4y agoAh, yes, sorry, just Python based slicing. It follows the numpy rules