# US 2016/0261577 A1 · Analysis with embedded electronic spreadsheets

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2016/0261577 A1
- Document ID: US20160261577A1
- Status: Published application
- Kind: A1
- Application number: 14/815,137
- Filed: 2015-07-31
- Published: 2016-09-08
- Earliest claimed: 2015-03-03
- Assignees: Microsoft Technology Licensing, LLC
- Applicants: Microsoft Technology Licensing, LLC
- Inventors: Jih-Shiang Chang; Vageesh Banga; Madan Natu; Benjamin Andrew Kaiser; Amandeep Singh Pandher; Ruchika Rawat; Nirav Shah
- Web page: https://patentgrep.com/patent/US20160261577A1

## CPC

- H04L 67/02: based on web technology, e.g. hypertext transfer protocol [HTTP]
- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- H04L 67/10: in which an application is distributed across nodes in the network (software deployment G06F8/60; multiprogramming arrangements G06F9/46)
- H04L 67/125: involving control of end-device applications over a network
- H04L 67/30: Profiles
- H04L 67/04: specially adapted for terminals or networks with limited capabilities; specially adapted for terminal portability
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A computer system includes a processor and a data store coupled to the processor. A user interface module is configured to provide a user interface of a first application executed by the processor. The user interface of the first application displays a plurality of items. The processor is configured to receive a command for an embedded spreadsheet view relative to the plurality of items and responsively save an electronic spreadsheet file in the data store and interact with an electronic spreadsheet service to display the plurality of items in a spreadsheet portion of a user interface within the user interface of the first application.

## Claims

### Claim 1

A computer system comprising:
a processor;
a data store coupled to the processor;
a user interface module configured to provide a user interface of a first application executed by the processor, the user interface of the first application displaying a plurality of items; and
wherein the processor is configured to receive a command for an embedded spreadsheet view relative to the plurality of items and responsively save an electronic spreadsheet file in the data store and interact with an electronic spreadsheet service to display the plurality of items in a spreadsheet portion of a user interface within the user interface of the first application.

### Claim 2 (depends on 1)

The computer system of claim 1, wherein interaction with the electronic spreadsheet service is through a network.

### Claim 3 (depends on 2)

The computer system of claim 2, wherein interaction with the electronic spreadsheet service is in accordance with a web application open platform interface protocol.

### Claim 4 (depends on 2)

The computer system of claim 2, wherein the computer system is configured to automatically authenticate with the electronic spreadsheet service.

### Claim 5 (depends on 4)

The computer system of claim 4, wherein authentication is based on a file identifier and an organization identifier.

### Claim 6 (depends on 5)

The computer system of claim 5, wherein authentication is also based on a hash of the file identifier and the organization identifier.

### Claim 7 (depends on 6)

The computer system of claim 6, wherein authentication information transmitted by the computer system is encrypted.

### Claim 8 (depends on 1)

The computer system of claim 1, and further comprising an application programming interface exposed to the electronic spreadsheet service.

### Claim 9 (depends on 1)

The computer system of claim 1, wherein the display of the plurality of items in the spreadsheet portion is provided within an IFRAME.

### Claim 10 (depends on 1)

The computer system of claim 1, and further comprising providing a user interface element that, when actuated, causes items in the spreadsheet portion of the user interface to be saved in the data store.

### Claim 11 (depends on 10)

The computer system of claim 10, wherein the electronic spreadsheet file is saved using SQL.

### Claim 12 (depends on 10)

The computer system of claim 10, and further comprising providing a user interface element that, when actuated, reverts from the spreadsheet portion of a user interface to the first user interface.

### Claim 13 (depends on 12)

The computer system of claim 12, wherein reversion to the first user interface is performed without saving the items in the spreadsheet portion of the user interface to be saved in the data store.

### Claim 14 (depends on 1)

The computer system of claim 1, wherein the computer system is a CRM system.

### Claim 15

The a computer-implemented method of providing analysis of data displayed in a first application, the method comprising:
displaying a plurality of data items in a user interface of the first application;
receiving a request to convert the display of data items to an embedded electronic spreadsheet;
automatically generating an electronic spreadsheet file using the plurality of data items displayed in the user interface of the first application;
saving the electronic spreadsheet file;
authenticating with a remote electronic spreadsheet provider service;
causing the remote electronic spreadsheet service to provide a spreadsheet view of the electronic spreadsheet file; and
rendering the spreadsheet view within the user interface of the first application.

### Claim 16 (depends on 15)

The computer-implemented method of claim 15, and further comprising receiving changes to data items displayed in the spreadsheet view.

### Claim 17 (depends on 16)

The computer-implemented method of claim 16, and further comprising receiving a command to revert to the user interface of the first application and reverting to the first user interface without saving changes to the data items displayed in the spreadsheet view.

### Claim 18 (depends on 16)

The computer-implemented method of claim 16, and further comprising receiving a command to save changes to the data items displayed in the spreadsheet portion and responsively saving changes to associated data of the first application.

### Claim 19 (depends on 15)

The computer-implemented method of claim 15, wherein the electronic spreadsheet file is saved in a data store of the first application.

### Claim 20

A computer system comprising:
a processor;
a computer readable medium having instructions stored thereon that, when executed by the processor, provide a first user interface displaying a plurality of items; and
wherein the processor is configured to receive a command for an embedded spreadsheet view relative to the plurality of items and responsively save an electronic spreadsheet file and automatically authenticate with an electronic spreadsheet service to display the plurality of items in a spreadsheet portion of a user interface within the user interface of the first application.
