Microsoft Technology Licensing, LLC

Matthew Hart Fichtner

Samuel C Radakovitz

John S Campbell

Christian Canton

Carlos Augusto Otero

Benjamin Edward Rampson

Jim Sun

John David Sully

Johnny S Campbell

Alexander Livingston

Catherine William Neylan

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

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

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

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.

Images associated with cells in spreadsheets

Operations on images associated with cells in spreadsheets

The present disclosure provides a novel approach to displaying spreadsheets on mobile devices (e.g., cell phones, tablets, etc.) so that they are more easily viewable by the user. Aspects of the present disclosure provide multiple different views of a spreadsheet and simple transitions among those views. The multiple views facilitate the display of important aspects of a spreadsheet and optimize the spreadsheet viewing area. In particular, deck and card views are disclosed, wherein each view corresponds to a different display format of the spreadsheet. Furthermore, editing the spreadsheet data is also provided within these views.

Decks, cards, and mobile UI

Systems and methods for charting videos and/or attributes of videos associated with a spreadsheet are provided. For instance, when a video is associated with a spreadsheet, the video may be treated as a new type of data within the spreadsheet. In some aspects, a plurality of videos may be associated with a spreadsheet, e.g., within a single cell or a range of cells. In aspects, the videos themselves, as well as video data (e.g., raw pixel data for each video frame, modulated data representing soundwaves of an audio file, etc.), video attributes (e.g., frame rate, aspect ratio, duration, resolution, bits per frame, video size, synchronization data, etc.), frame attributes (e.g., aspect ratio, color space, bitrate, etc.), audio attributes (e.g., pitch, volume, speed, etc.), and/or spreadsheet data (e.g., values in cells, user comments, etc.) may be incorporated into a chart using a spreadsheet charting function, either automatically or by user selection.

Video on charts

Images and additional data associated with cells in spreadsheets

Systems for associating streaming data 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, image attributes and audio attributes) may be viewed and/or manipulated by a user, providing stream processing functionality within a spreadsheet. Controls may be provided for playing the streaming data and/or playing the streaming data in response to spreadsheet data satisfying a condition. Spreadsheet operations (e.g., sort and/or filter operations) may also be performed on a range of cells based on parameters of associated streaming data.

Streaming data associated with cells in spreadsheets

Systems for associating videos 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 video attributes, image attributes and audio attributes) may be viewed and/or manipulated by a user, providing video and audio processing functionality within a spreadsheet. Controls may be provided for playing the video and/or playing the video in response to spreadsheet data satisfying a condition. Text transcriptions (e.g., speech-to-text) of an audio track associated with a video file may be inserted as subtitles into the video or a plurality of individual frames for the video. Spreadsheet operations (e.g., sort and/or filter operations) may also be performed on a range of cells based on parameters of an associated video.

Growing community of inventors

Seattle, WA, United States of America

Matthew Hart Fichtner