MODERN SPREADSHEET ARRAYS

摘要

The present disclosure provides a novel approach for creating and referencing arrays as implemented in a spreadsheet application. Aspects of the present disclosure include, but are not limited to: referencing arrays, creating dynamic arrays, collapsing values of an array into a single cell, spilling values of an array to a table, referencing one or more values in collapsed arrays, visually indicating no spill errors while maintaining calculation capabilities thereon, and implicit intersection of data.

主权项

1. A computer-implemented method for resolving a cell to an array of values, the method comprising:
receiving a plurality of values; receiving a selection to create an array; and creating the array that includes each of the plurality of values.