Abstract: Various embodiments of the present technology generally relate to enhancements to spreadsheet tables. More specifically, embodiments of the present technology include systems and methods for incorporating various table column operations into table columns headers, thereby simplifying the act of propagating a desired effect across a range that exactly matches the table column. In an embodiment, a spreadsheet application detects a cell event in a spreadsheet, wherein the cell event affects one or more cells of the spreadsheet, determines that a cell of the one or more cells is inside a range that makes up a table in the spreadsheet, identifies a table column of the table to which the cell belongs, identifies metadata for the table column, wherein the metadata for the table column comprises column configuration instructions, and applies the column configuration instructions to the cell.

Abstract: Various embodiments of the present technology generally relate to enhancements to spreadsheet tables. More specifically, embodiments of the present technology include systems and methods for incorporating various table column operations into table columns headers, thereby simplifying the act of propagating a desired effect across a range that exactly matches the table column. In an embodiment, a spreadsheet application detects a cell event in a spreadsheet, wherein the cell event affects one or more cells of the spreadsheet, determines that a cell of the one or more cells is inside a range that makes up a table in the spreadsheet, identifies a table column of the table to which the cell belongs, identifies metadata for the table column, wherein the metadata for the table column comprises column configuration instructions, and applies the column configuration instructions to the cell.

Abstract: Disclosed are novel approaches to debugging a formula in a spreadsheet environment. An execution trace shows step-by-step how a formula is evaluated. Instead of overwhelming users by displaying a step for every atomic evaluation, multiple evaluations are displayed in the same step. This makes the execution trace compact yet intuitive, enabling users to quickly and efficiently understand how the formula is evaluated. Visualizing formula execution in this way also reduces the computing and energy costs of excess recalculations incurred by trial-and-error based debugging techniques.

Abstract: Disclosed is a range preview system that displays data from a relevant range of cells. The range preview system intelligently elides and contextualizes data ranges for efficient visualization. The range preview system optimizes space utilization by selectively collapsing rows and columns. For example, rows and columns that are referenced by a formula may be selected for inclusion in the range preview. This conserves screen real estate while providing users with a concise overview of data ranges. The range preview system may also infer labels, providing context during formula interpretation by associating references with nearby headers or other descriptions.

Abstract: The generation of a response to a task prompt that represents a task to perform on declarative code. The response is generated with the aid of a language model that was trained on imperative code. The declarative code includes declarations about data. A task prompt represents a task to perform on the declarative code. At least a portion of the declarative code and at least a portion of the task prompt are converted into input imperative code. The input imperative code is then caused to be provided as input to the language model, resulting in the language model generating output imperative code. At least a portion of the output imperative code is then converted into a response to the task prompt.

Abstract: A method of providing a geographically distributed live mixed-reality meeting is described. The method comprises receiving, from a camera at a first endpoint, a live video stream; generating an mixed reality view incorporating the received video stream; rendering the mixed reality view at a display at the first endpoint and transmitting the mixed reality view to at least one other geographically distant endpoint; receiving data defining a bounding area; calculating a real world anchor for the bounding area using the data defining the bounding area; rendering the bounding area in the mixed reality view at a real world position determined using the real world anchor; and applying different rule sets to content objects placed into the mixed reality view by users dependent upon the position of the content objects relative to the bounding area in real world space.

Abstract: A mechanism to show how code is operating with different sets of input. After accessing the code that is to be evaluated along with the multiple input sets for that code, the computing system generates a multi-dimensional array of values. This is done by, for each of at least some of the multiple input sets, generating a corresponding intermediate value set of one or more intermediate values that are generated as the code operates upon the corresponding input set to generate a corresponding output value set. Then, the computing system causes a multi-dimensional array of values to be visualized using a multi-dimensional representation. In this multi-dimensional visualization, input sets are represented in at least one dimension against at least one intermediate value of the corresponding intermediate value set in at least another dimension.

Abstract: The indirect querying of models to determine capabilities possessed by the model. Such indirect queries take the form of model input that potentially includes a natural language input user data. Such model input is structured such that the output of the model is either not natural language at all, or else is natural language that is not semantically responsive to the natural language input. Nevertheless, the output is evaluated to estimate or determine the capability possessed by the model. Thus, models may be more fully utilized to their better potential.

Abstract: The automated generation of a natural language explanation of what code does. The code is structured to perform tasks because the code itself semantically specifies that those tasks are to be performed. A task-centric representation of the code is automatically generated that includes a task representation of each of some or all of the tasks to be performed as specified by the code. Natural language utterances are then automatically generated by generating a corresponding natural language utterance that semantically describes in natural language the corresponding task represented by the corresponding task representation. Controls are rendered for each natural language utterance that each permit a user to edit the corresponding natural language utterance. After editing, the code itself may be automatically modified or regenerated to reflect the changed natural language utterances.

Abstract: The indirect querying of models to determine capabilities possessed by the model. Such indirect queries take the form of model input that potentially includes a natural language input user data. Such model input is structured such that the output of the model is either not natural language at all, or else is natural language that is not semantically responsive to the natural language input. Nevertheless, the output is evaluated to estimate or determine the capability possessed by the model. Thus, models may be more fully utilized to their better potential.

Abstract: The generation of a response to a task prompt that represents a task to perform on declarative code. The response is generated with the aid of a language model that was trained on imperative code. The declarative code includes declarations about data. A task prompt represents a task to perform on the declarative code. At least a portion of the declarative code and at least a portion of the task prompt are converted into input imperative code. The input imperative code is then caused to be provided as input to the language model, resulting in the language model generating output imperative code. At least a portion of the output imperative code is then converted into a response to the task prompt.

Abstract: Various embodiments of the present technology generally relate to enhancements to spreadsheet tables. More specifically, embodiments of the present technology include systems and methods for incorporating various table column operations into table columns headers, thereby simplifying the act of propagating a desired effect across a range that exactly matches the table column. In an embodiment, a spreadsheet application detects a cell event in a spreadsheet, wherein the cell event affects one or more cells of the spreadsheet, determines that a cell of the one or more cells is inside a range that makes up a table in the spreadsheet, identifies a table column of the table to which the cell belongs, identifies metadata for the table column, wherein the metadata for the table column comprises column configuration instructions, and applies the column configuration instructions to the cell.

Abstract: A method of providing a geographically distributed live mixed-reality meeting is described. The method comprises receiving, from a camera at a first endpoint, a live video stream; generating an mixed reality view incorporating the received video stream; rendering the mixed reality view at a display at the first endpoint and transmitting the mixed reality view to at least one other geographically distant endpoint; receiving data defining a bounding area; calculating a real world anchor for the bounding area using the data defining the bounding area; rendering the bounding area in the mixed reality view at a real world position determined using the real world anchor; and applying different rule sets to content objects placed into the mixed reality view by users dependent upon the position of the content objects relative to the bounding area in real world space.

Abstract: A spreadsheet application displays a spreadsheet of cells in tabular form. User input is received specifying an input range of cells of the spreadsheet, a destination range of cells of the spreadsheet and a local modification. A memory stores a representation of the spreadsheet indicating formatting, values and formulas. An update of the representation is computed by applying the local modifications to the representation. Values of cells of the input range of the spreadsheet are calculated by using the updated representation and the calculated values are displayed at the destination range.

Abstract: A method of providing a geographically distributed live mixed-reality meeting is described. The method comprises receiving, from a camera at a first endpoint, a live video stream; generating an mixed reality view incorporating the received video stream; rendering the mixed reality view at a display at the first endpoint and transmitting the mixed reality view to at least one other geographically distant endpoint; receiving data defining a bounding area; calculating a real world anchor for the bounding area using the data defining the bounding area; rendering the bounding area in the mixed reality view at a real world position determined using the real world anchor; and applying different rule sets to content objects placed into the mixed reality view by users dependent upon the position of the content objects relative to the bounding area in real world space.

Abstract: A set of electronic slide decks is searched using a target slide of a first electronic slide deck, each of the electronic slide decks containing a sequence of slides to be presented individually. A computer system receives from a user input individually selecting the target slide as a search input from the slides of the first electronic slide deck, compares the target slide with the slides of each electronic slide deck in the set to determine whether any of those slides matches the target slide, so as to determine, for each of the set of electronic slide decks, whether that electronic slide deck contains at least one slide that matches the target slide; and displays a set of search results in response to the user input, wherein each of the search results represents one of the electronic slide decks determined to contain at least one matching slide.

Abstract: A spreadsheet application displays a spreadsheet of cells in tabular form. User input is received specifying an input range of cells of the spreadsheet, a destination range of cells of the spreadsheet and a local modification. A memory stores a representation of the spreadsheet indicating formatting, values and formulas. An update of the representation is computed by applying the local modifications to the representation. Values of cells of the input range of the spreadsheet are calculated by using the updated representation and the calculated values are displayed at the destination range.

Abstract: To prevent spreadsheet errors, a solution is disclosed that provides a multiple-region spreadsheet including additional representations, providing readily usable creation and editing of computational structure operations, without altering the conventional grid representation of a spreadsheet or its formula syntax. The multiple-region spreadsheet may include a traditional row-column arrangement of cells in a grid format, along with a calculation view pane intended to display underlying formulas used in the grid along with truncated cell assignments.

Abstract: Technology is disclosed herein for handing approximate (or uncertain) values in spreadsheet applications. More specifically, the technology describes spreadsheet applications that support arrays or sets of approximate (or uncertain) values as native entities. An approximate (or uncertain) value may be the value of a cell of the spreadsheet that is resolvable by formula, charts and other functionalities. In some implementations, approximate values may include a range of data and a probability distribution that can be automatically created by the spreadsheet application, generated based on context, input by the user, etc. Because the approximate (or uncertain) value is natively available, it can be incorporated in a spreadsheet like other values. Additionally, the approximate (or uncertain) values can automatically propagate through a spreadsheet calculation to obtain a final approximate result.

Abstract: Methods for generation and execution of elastic sheet-defined functions and arrays are performed by systems, devices, and apparatuses. Elastic sheet-defined functions are generated from inelastic defined functions. Specific notations for tile ranges and range references of inputs for an inelastic function are generated, and heights, widths, rows, and columns of the inputs are modified with delta variables. Constraints for the delta variables are generated and mapped to solve for a constraints solution for a given inelastic function. Based on the constraints solution, an elastic sheet-defined function is generated that takes dynamic input ranges of different sizes. Elastic sheet-defined functions are executed to prevent overlap of tiles and ranges for variables by generating new sheets for tiles and ranges, dynamically moving tiles and ranges, and assigning cells as arrays. Software programming arrays are also dynamically sized in a similar manner.