AUTODETECTION OF TYPES AND PATTERNS

摘要

The present disclosure describes pattern detections for storing multiple values in a compound object. A compound object is a value that stores multiple values in a single cell, wherein those multiple values are organized according to a defined structure. The compound object may store multiple values according to a known defined data structure. In embodiments, the compound object may store multiple values as any nested combination of any one of the known or user-defined data structures (e.g., nesting an array within a vector, or nesting a record within a record, or nesting matrices within a table, etc.). Each of the values stored in the compound object are individually referenceable and can fully participate with spreadsheet functionality including calculations, referencing, and formatting.

主权项

1. A computer-implemented method for pattern identification associated with an input to a cell of a spreadsheet, comprising:
receive a first value in a first cell; receive a second value in a second cell; identify a pattern corresponding to the first value and the second value, wherein the pattern is related to a schema; and based on identification of the pattern, store the first value and the second value in an object defined by the schema.