docs: 📝 Add cell selection syntax docs #583
Conversation
| height: 24px; | ||
| width: 24px; | ||
| content: ""; | ||
| background: url("data:image/svg+xml;charset=utf-8,%3Csvg viewBox='0 0 24 24' xmlns='http://www.w3.org/2000/svg'%3E%3Cpath d='M12 .297c-6.63 0-12 5.373-12 12 0 5.303 3.438 9.8 8.205 11.385.6.113.82-.258.82-.577 0-.285-.01-1.04-.015-2.04-3.338.724-4.042-1.61-4.042-1.61C4.422 18.07 3.633 17.7 3.633 17.7c-1.087-.744.084-.729.084-.729 1.205.084 1.838 1.236 1.838 1.236 1.07 1.835 2.809 1.305 3.495.998.108-.776.417-1.305.76-1.605-2.665-.3-5.466-1.332-5.466-5.93 0-1.31.465-2.38 1.235-3.22-.135-.303-.54-1.523.105-3.176 0 0 1.005-.322 3.3 1.23.96-.267 1.98-.399 3-.405 1.02.006 2.04.138 3 .405 2.28-1.552 3.285-1.23 3.285-1.23.645 1.653.24 2.873.12 3.176.765.84 1.23 1.91 1.23 3.22 0 4.61-2.805 5.625-5.475 5.92.42.36.81 1.096.81 2.22 0 1.606-.015 2.896-.015 3.286 0 .315.21.69.825.57C20.565 22.092 24 17.592 24 12.297c0-6.627-5.373-12-12-12'/%3E%3C/svg%3E") no-repeat; |
There was a problem hiding this comment.
This is just autoformatting, no changes in the .header-github-link:before class.
|
|
||
| # Cell Range | ||
|
|
||
| Cell ranges can be used to select a subset of cells in a 2D data structure, such as a `Sheet`. The syntax for cell ranges follows conventions from spreadsheet-software. Rows are referenced by one-based indices and columns by capitalized characters, ordered alphabetically. |
There was a problem hiding this comment.
"such as sheet" implies that the syntax would also be usable for other 2D data structures, such as tables. Right now, we only allow it on sheets, right? Could make sense whether we want the same syntax for tables or only for sheets.
That is however unrelated to the changes. Just wanted to bring it up as it came to my mind :)
There was a problem hiding this comment.
True, even though tables always have column names so I assume we'd use those. But I could see other 2D data structures in the future (since sheets are explicitly strings right now, maybe we have one with individual cells having data types), so I wanted to keep the wording future proof 😅 .
closes #582