Microsoft Technology Licensing, LLC

Samuel C Radakovitz

John S Campbell

Christian Canton

Matthew Hart Fichtner

Carlos Augusto Otero

Benjamin Edward Rampson

Hiroshi Tsukahara

Clinton Dee Covington

Allison Jane Rutherford

Charles David Ellis

Brian Scott Ruble

Burns M Montgomery

David Francis Gainer

Dave McDonald

Jim Sun

Johnny S Campbell

Simon Peyton Jones

John David Sully

Yonghong Zeng

Owen Charles Braun

Jonathan Seth Kaufthal

Safiya Bhojawala

Uhl Albert

Andrew James Becker

Aaron Lamar Wilson

Anupam Garg

Matthew John Androski

Alexander Livingston

Catherine William Neylan

Marta Luis Burguete

Steven Paul Kraynak

Daniya Alisa Petal Ulgen

Adam Michael Buerman

Matthew Kevin Becker

Yonghong Zhen

Carlos A Ortero

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.

Compound data objects

Aspects disclosed herein relate to the use of navigational control UI elements to aid in navigating large surfaces on a touchscreen device. The navigational control UI element may be operable to facilitate traversal of the navigable surface along the axis upon which the navigational control UI element is placed. In alternate examples, the navigational control element may be operable to provide functionality to traverse or adjust the navigable surface along both the horizontal vertical axes. In still further aspects, other types of navigational control UI elements may provide the ability to directly jump to a specific position on the navigable surface.

Navigating long distances on navigable surfaces

A spin control graphical user interface is used to display a currently applied option and to receive options from a user. The spin control is a circular graphical user interface that is positioned near a displayed document to which it applies. For example, the spin control may be positioned on or near a corner of the displayed document. The spin control comprises options that are presented to a user upon rotation of the spin control. An option may be manually selected or automatically selected and applied to the displayed document upon rotating the spin control clockwise or counterclockwise. More than one spin control may be associated with the displayed document. The spin control may be automatically shown and removed from a display in response to whether the document to which the spin control is attached is currently being displayed.

Spin control user interface for selecting options

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.

Images on charts

Selected data is temporarily formatted and charted to assist a user in visualizing the selected data without the user having to manually create the display of the charted data. Once the temporary formatting and charting is automatically applied to the selected data, a user may interact with the visual formatting and charts to gain additional information. For example, the chart may be formatted differently, reference lines may be added, the chart may be sorted, the type of chart(s) displayed may be changed, the user may graphically navigate over the chart to obtain more detailed information, and the like. Once the user has completed interacting with the temporarily formatted and created chart(s) the visualizations are removed from the display.

Temporary formatting and charting of selected data

Described herein is a system and method for associating images with one or more cells in a spreadsheet application. As described, one or more images may be associated with a single cell in a spreadsheet application or it may be associated with a range of cells in the spreadsheet application. Information about the image, such as metadata, pixel information or other parameters, may be retrieved from the image. Once retrieved, a calculation engine may perform one or more calculations on the information in order to change an appearance of the image.

Calculations on images within cells in spreadsheets

Technologies are described herein for displaying one or more visual indicators to assist users in identifying cells of a spreadsheet that are affected by an operation. In embodiments disclosed herein, an application is configured to receive a request to perform an operation on at least one cell of the spreadsheet. The application then identifies cells of the spreadsheet that are affected by the operation. The application then displays a visual indicator to emphasize the affected cells. By providing a timely displayed visual indicator that brings attention to affected cells, the user is able to gain a better perspective of the extent of the operation and how the operation applies to the cells of the spreadsheet.

Enhanced indicators for identifying affected data

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.

Operations on dynamic data associated with cells in spreadsheets

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.

Sound on charts

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.

Rich data types

Described herein is a system and method for associating audio files with one or more cells in a spreadsheet application. As described, one or more audio files may be associated with a single cell in a spreadsheet application or it may be associated with a range of cells in the spreadsheet application. Information about the audio file, such playback properties and other parameters, may be retrieved from the audio file. Once retrieved, a calculation engine of the spreadsheet application may perform one or more calculations on the information in order to change the content of audio file, the playback of the audio files and so on.

Calculations on sound associated with cells in spreadsheets

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.

Operations on sound files associated with cells in spreadsheets

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.

Growing community of inventors

Bellevue, WA, United States of America

Samuel C Radakovitz