Videos associated with cells in spreadsheets

• US 9,990,350 B2
• Filed: 09/30/2016
• Issued: 06/05/2018
• Est. Priority Date: 11/02/2015
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Campbell, Johnny S., Otero, Carlos Augusto, Canton, Christian, Fichtner, Matthew Hart, Radakovitz, Samuel C., Rampson, Benjamin Edward
• Primary Examiner(s): RIES, LAURIE ANNE
• Application Number:
  US15/282,269
• Publication Number:
  US 20170124048A1
• Time in Patent Office: 613 Days
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
• CPC Class Codes: G06F 3/165 Management of the audio stream, e.g. setting of volume, audio stream path
• CPC Class Codes: G06F 40/106 Display of layout of documents; Previewing
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs
• CPC Class Codes: G11B 27/031 Electronic editing of digitised analogue information signals, e.g. audio or video signals
• CPC Class Codes: H04L 43/045 for graphical visualisation of monitoring data
• CPC Class Codes: H04L 65/65 Network streaming protocols, e.g. real-time transport protocol [RTP] or real-time control protocol [RTCP]
• CPC Class Codes: H04L 65/70 Media network packetisation
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04N 5/272 Means for inserting a foreground image in a background image, i.e. inlay, outlay

Abstract

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.

Claims

1. A system comprising:

at least one processing unit; and

at least one memory storing computer executable instructions that, when executed by the at least one processing unit, cause the system to perform a method, the method comprising;

receiving at least one video;

referencing the at least one video in a function associated with at least one cell of a spreadsheet;

determining that a condition of the function is satisfied; and

displaying a visual representation of the at least one video as background for the at least one cell in the spreadsheet, wherein at least some data associated with the function is displayed over the visual representation within the at least one cell.

2. The system of claim 1, wherein the reference to the at least one video is one of:

a globally unique name; and

a uniform resource locator.

3. The system of claim 1, further comprising:

performing an operation on the at least one cell; and

performing one of;

moving the at least one video with the at least one cell; and

not moving the at least one video with the at least one cell.

4. The system of claim 3, wherein the operation is one of:

a sort operation; and

a filter operation.

5. The system of claim 1, further comprising:

floating the video over the grid.

6. The system of claim 1, further comprising:

pasting the at least one video into the cell;

dropping the at least one video into the cell;

retrieving the at least one video from storage based on a file locator; and

inserting the at least one video into the cell.

7. The system of claim 1, further comprising:

determining that the condition of the function is not satisfied; and

displaying a different visual representation of a different video as background for the at least one cell in the spreadsheet, wherein at least some data associated with the function is displayed over the different visual representation within the at least one cell.

8. A method for associating at least one video with at least one cell of a spreadsheet, the method comprising:

receiving at least one video;

associating the at least one video with at least one cell of a spreadsheet;

displaying a visual representation of the at least one video in the at least one cell of the spreadsheet; and

in response to associating the at least one video with the at least one cell, surfacing one or more parameters for the at least one video in a user interface in response to one or more of;

hovering over the at least one video;

right-clicking the at least one video; and

launching a user interface.

9. The method of claim 8, wherein the one or more parameters comprise one or more of:

video data;

video attributes;

audio data; and

audio attributes.

10. The method of claim 8, further comprising:

displaying the visual representation of the at least one video as background for the at least one cell.

11. The method of claim 8, further comprising:

performing an operation on the at least one cell based at least in part on the one or more parameters.

12. The method of claim 8, wherein the video comprises a plurality of individual frames.

13. The method of claim 12, further comprising:

providing a user interface (UI) element for viewing one or more of the plurality of individual frames.

14. The method of claim 8, further comprising:

displaying the visual representation of the at least one video over a range of cells.

15. A computer-readable storage medium storing computer executable instructions that, when executed by at least one processing unit, cause a computing device to:

receive at least one video for association with at least one cell of a spreadsheet;

receive additional data for association with the at least one cell;

create a compound data type including the at least one video and the additional data;

associate the compound data type with the at least one cell; and

display a visual representation of the at least one video as background for the at least one cell and at least a portion of the additional data over the visual representation in the at least one cell.

16. The computer-readable storage medium of claim 15, wherein the compound data type comprises a plurality of fields, the computer executable instructions further causing the computing device to:

dereference at least one field of the plurality of fields; and

perform an action on the at least one field.

17. The computer-readable storage medium of claim 15, wherein the compound data type comprises a plurality of fields, the computer executable instructions further causing the computing device to:

construct a formula to retrieve a value for at least one of the plurality of fields.

18. The computer-readable storage medium of claim 15, the computer executable instructions further causing the computing device to:

receive layout attributes for displaying the visual representation of the at least one video and at least the portion of the additional data in the at least one cell.

19. The computer-readable storage medium of claim 15, the computer executable instructions further causing the computing device to:

dynamically display an increased portion of the additional data as the at least one cell is enlarged.

20. The computer-readable storage medium of claim 15, the computer executable instructions further causing the computing device to:

provide a card view of the compound data type in a user interface, wherein the card view displays the at least one video and the portion of additional data in a formatted layout.