Named cells and output

[felipesabino]

Add the ability to create named cells or intervals to make it easier to access cells or range of cells in addition to reference the cells by indexes.

One way I think this could behave is

• when right clicking a cell or a range, the menu could display a "name" option to name that cell/range
• for python scripts, the cell/c could also receive a name or have an isolated function for that, same goes for the cells/getCells function
• for formulas, the cell reference could support the range name in addition to the formula notation

Here are excel references as how they currently support this feature in their frontend

• https://support.microsoft.com/en-us/office/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64
• https://support.microsoft.com/en-us/office/insert-a-named-range-into-a-formula-in-excel-131f2e66-30b6-4f1a-afb3-83007f63082d
• https://support.microsoft.com/en-us/office/create-a-named-range-in-excel-adee78ff-bcf0-4283-8c29-83304ca0c29d
• https://support.microsoft.com/en-us/office/use-the-name-manager-in-excel-4d8c4c2b-9f7d-44e3-a3b4-9f61bd5c64e4

[davidkircos]

Thanks for creating this issue. We are actively thinking about implementing named ranges/tables. It will make it easier to move data around the grid too.

[davidkircos]

We could also support dynamic array references such as A1# which references the full array output of cell A1. See example

dynamic array example.xlsx