You are correct, that is the slicing syntax. We to carefully interpret the ":" i... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		dosinga on Feb 16, 2023 \| parent \| context \| favorite \| on: Launch HN: Neptyne (YC W23) – A programmable sprea... 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 on Feb 16, 2023 [–]

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?

dosinga on Feb 16, 2023 | [–]

Ah, yes, sorry, just Python based slicing. It follows the numpy rules

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact