Abstract: The present disclosure describes a value referred to as a compound object 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 such as, for example, a record, vector, matrix, table, or array. In other embodiments, the compound object may store multiple values as any nested combination of any one of the known or user-defined data structures. Each of the values stored in the compound object are individually referenceable and can fully participate with spreadsheet functionality including calculations, referencing, and formatting.

Abstract: Systems and methods for charting images and/or attributes of images associated with a spreadsheet are provided. For instance, when an image is associated with a spreadsheet, the image may be treated as a new type of data within the spreadsheet. In some aspects, a plurality of images may be associated with a spreadsheet, e.g., within a single cell or within a range of cells. In some aspects, the images themselves, as well as image data (e.g., pixelated data, etc.), image attributes (e.g., opacity, color palette, resolution, aspect ratio, image dimensions, author, creation date and/or time, file name, tags, file size, GPS location information, etc.), and/or spreadsheet data (e.g., values in cells, user comments, etc.) may be incorporated into a report (e.g., a chart) using a spreadsheet charting function, either automatically or by user selection.

Abstract: Systems, methods, and software are disclosed herein for enhancing functions and formulas in spreadsheets. A computing apparatus detects a beginning of a formula in a cell of a spreadsheet. In response to detecting the beginning of the formula, the computing apparatus identifies one or more vector representations of a context of the cell and supplies the one or more vector representations as input to one or more machine learning models. The one or more machine learning models produce output comprising one or more suggested functions for the formula and one or more suggested operands, which the computing apparatus presents in a user interface to the spreadsheet.

Abstract: Systems for performing operations on dynamic data associated with cells of a spreadsheet are provided. Both dynamic data and static data may be associated with a single cell of the spreadsheet. Upon association, parameters (including stream attributes, video attributes, image attributes and audio attributes) may be manipulated by a user, providing dynamic data processing functionality within a spreadsheet. Controls may be provided for playing the dynamic data and/or playing the dynamic data in response to spreadsheet data satisfying a condition. Operations for inserting text transcriptions (e.g., speech-to-text) of an audio track associated with dynamic data as subtitles may further be provided. Spreadsheet operations (e.g., sort and/or filter operations) may also be performed on a range of cells based on parameters of associated dynamic data.

Abstract: Systems and methods for charting audio files and/or attributes of audio files associated with a spreadsheet are provided. For instance, when an audio file is associated with a spreadsheet, the audio file may be treated as a new type of data within the spreadsheet. In some aspects, a plurality of audio files may be associated with a spreadsheet, e.g., within a single cell or within a range of cells. In some aspects, the audio files themselves, as well as audio data (e.g., modulated data representing soundwaves, etc.), audio attributes (e.g., frequency, amplitude, sampling rate, codec, bitrate, volume, pitch, speed, channel, audio effects, author/artist, creation date and/or time, file name, file size, duration, etc.), and/or spreadsheet data (e.g., values in cells, user comments, etc.) may be incorporated into a report (e.g., a chart) using a spreadsheet charting function, either automatically or by user selection.

Abstract: The present disclosure is directed to systems and methods for implementing rich data types in a spreadsheet application. Generally, a value being of a rich data type is as a type of value that has context and established relationships with other types of data. In particular, a rich data type is a data value having associated context, which may be units (e.g., inches, miles, meters, kilograms, seconds, joules, hertz, Fahrenheit, etc.) or other information about the data's type (e.g., city, stock, NCAA football team, car, restaurant, school, etc.). Additionally, a value being of a rich data type further includes established relationships with other types of data.

Abstract: Systems, methods, and software are disclosed herein for enhancing functions and formulas in spreadsheets. A computing apparatus detects a beginning of a formula in a cell of a spreadsheet. In response to detecting the beginning of the formula, the computing apparatus identifies a vector representation of a context of the cell and supplies the vector representation as input to one or more machine learning models. The one or more machine learning models produce output comprising one or more suggested functions for the formula and one or more suggested operands, which the computing apparatus presents in a user interface to the spreadsheet.

Abstract: The present disclosure relates to enriching a compound object with data provided by a third party service, database, or local database. In some embodiments, this is performed by receiving an entry of a value in a cell of a spreadsheet; determining whether the value is related to information provided by a service; based on a determination that the value is related to information provided by the service, selecting the service; displaying a field selection user interface; receiving a selection of one or more fields from the field selection user interface; receiving one or more values associated with the selected one or more fields; and enriching a compound object based on the selected one or more fields and associated one or more values.

Abstract: Systems for associating audio files with cells of a spreadsheet are provided. Both audio files and data may be associated with a single cell of the spreadsheet. An audio file may be recorded, retrieved from storage, or converted from a document (e.g., using text-to-speech technology) for association with a spreadsheet. Upon association, audio parameters may be viewed and/or manipulated by a user, providing audio processing functionality within a spreadsheet. Controls may be provided for listening to the audio file and/or playing the audio file in response to spreadsheet data satisfying a condition. Text transcriptions (e.g., speech-to-text) of audio files may be inserted into the spreadsheet. For low vision users, audio transcriptions (e.g., text-to-speech) of data may be generated and “played” for the user. Spreadsheet operations (e.g., sort and/or filter operations) may also be performed on a range of cells based on audio parameters of associated audio files.

Abstract: Aspects of the present disclosure further provide the ability to define, among other features, the layout of the cell view of the cell in which the compound object is stored as well as the card view of the compound object. Aspects of the present disclosure further provide the ability to modify properties associated with the values stored in a compound object, including, but not limited to properties of calculated values, value formatting, and permissions.

Abstract: In non-limiting examples of the present disclosure, systems, methods and devices for interacting with data in a productivity application are presented. A plurality of values associated with the productivity application may be analyzed to determine whether they include a value that can be added to a set comprising a plurality of values with a set data type upon which the productivity application can execute a plurality of set operations. An indication to add at least one of the analyzed values as a member of the set may be received. At least one of the analyzed values may be added as a member of the set. An indication to perform a set operation associated with the set may be received and performed, and the result of the performed set operation may be displayed on a productivity application user interface.

Abstract: Systems, methods, and software are disclosed herein for enhancing functions and formulas in spreadsheets. A computing apparatus detects a beginning of a formula in a cell of a spreadsheet. In response to detecting the beginning of the formula, the computing apparatus identifies a vector representation of a context of the cell and supplies the vector representation as input to one or more machine learning models. The one or more machine learning models produce output comprising one or more suggested functions for the formula and one or more suggested operands, which the computing apparatus presents in a user interface to the spreadsheet.

Abstract: Systems, methods, and software are disclosed herein for enhancing functions and formulas in spreadsheets. A computing apparatus detects a beginning of a formula in a cell of a spreadsheet. In response to detecting the beginning of the formula, the computing apparatus identifies one or more vector representations of a context of the cell and supplies the one or more vector representations as input to one or more machine learning models. The one or more machine learning models produce output comprising one or more suggested functions for the formula and one or more suggested operands, which the computing apparatus presents in a user interface to the spreadsheet.

Abstract: The present disclosure is directed to a spreadsheet application with an enhanced understanding of mathematical equations using a mathematical engine and a calculation engine. The disclosed spreadsheet application has many enhanced features, such as, but not limited to: analyzing complex equations, identifying dependencies, converting mathematical notation to spreadsheet notation, connecting variables in an equation to other cells of the spreadsheet, solving or simplifying equations, recommending different display representations of data, and a providing a math display mode.

Abstract: Systems and methods for charting audio files and/or attributes of audio files associated with a spreadsheet are provided. For instance, when an audio file is associated with a spreadsheet, the audio file may be treated as a new type of data within the spreadsheet. In some aspects, a plurality of audio files may be associated with a spreadsheet, e.g., within a single cell or within a range of cells. In some aspects, the audio files themselves, as well as audio data (e.g., modulated data representing soundwaves, etc.), audio attributes (e.g., frequency, amplitude, sampling rate, codec, bitrate, volume, pitch, speed, channel, audio effects, author/artist, creation date and/or time, file name, file size, duration, etc.), and/or spreadsheet data (e.g., values in cells, user comments, etc.) may be incorporated into a report (e.g., a chart) using a spreadsheet charting function, either automatically or by user selection.

Abstract: Systems and methods for associated one or more images with one or more cells of a spreadsheet are described. As described, a plurality of images may be associated with a single cell or a single image may be associated with a range of cells. Additionally, an image and additional data may be associated with the same cell. Upon associating an image with a cell, various parameters of the image may be displayed for viewing and/or customization by a user. Additionally, sort and/or filter operations may be performed on the spreadsheet based on the various parameters of associated images and/or operations (e.g., fit and/or resize operations) may be performed on various parameters of associated images. An associated image may move with a cell when the cell is reordered within the cell table, or an associated image may be allowed to float over the grid but may be referenced by a cell.

Abstract: The present disclosure is directed to systems and methods for implementing rich data types in a spreadsheet application. Generally, a value being of a rich data type is as a type of value that has context and established relationships with other types of data. In particular, a rich data type is a data value having associated context, which may be units (e.g., inches, miles, meters, kilograms, seconds, joules, hertz, Fahrenheit, etc.) or other information about the data's type (e.g., city, stock, NCAA football team, car, restaurant, school, etc.). Additionally, a value being of a rich data type further includes established relationships with other types of data.

Abstract: The present disclosure is directed to systems and methods for implementing notifications for rich data types in a spreadsheet application. Generally, a value being of a rich data type is as a type of value that has context and established relationships with other types of data. In particular, a rich data type is a data value having associated context, which may be units (e.g., inches, miles, meters, kilograms, seconds, joules, hertz, Fahrenheit, etc.) or other information about the data's type (e.g., city, stock, NCAA football team, car, restaurant, school, etc.). Additionally, a value being of a rich data type further includes established relationships with other types of data.

Abstract: Systems and methods for associated one or more images with one or more cells of a spreadsheet are described. As described, a plurality of images may be associated with a single cell or a single image may be associated with a range of cells. Additionally, an image and additional data may be associated with the same cell. Upon associating an image with a cell, various parameters of the image may be displayed for viewing and/or customization by a user. Additionally, sort and/or filter operations may be performed on the spreadsheet based on the various parameters of associated images and/or operations (e.g., fit and/or resize operations) may be performed on various parameters of associated images. An associated image may move with a cell when the cell is reordered within the cell table, or an associated image may be allowed to float over the grid but may be referenced by a cell.

Abstract: The present disclosure is directed to systems and methods for implementing rich data types in a spreadsheet application. Generally, a value being of a rich data type is as a type of value that has context and established relationships with other types of data. In particular, a rich data type is a data value having associated context, which may be units (e.g., inches, miles, meters, kilograms, seconds, joules, hertz, Fahrenheit, etc.) or other information about the data's type (e.g., city, stock, NCAA football team, car, restaurant, school, etc.). Additionally, a value being of a rich data type further includes established relationships with other types of data.