Microsoft Technology Licensing, LLC

Robert Wayne Coffen

Juha P Niemisto

Michael J McCormack

Robert C Collie

Eric W Patterson

Kevin Joseph Fischer

Eoin James Burke

Kent Rogers Lowry

Su-Piao Bill Wu

Mark S Igra

Eric Lawrence Matteson

Hannah Wei Zhou

Thao Moua

Dennis R Newland

John C Haymond

Richard Lee Dickinson

Jeffrey E Larsson

Anna Timasheva

Sumit Chauhan

Joseph N Chirilov

Terri L Sorge

Joseph M Chirilov

Russell S Johnson

Ramakrishnan NataraJan

Eric Snyder

Xiaohui Pan

Rajeev S Misra

Michael J Eatough

Paul A Hafner

Larry Tseng

Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.

Block properties and calculated columns in a spreadsheet application

Methods and systems provide for bi-directional communication between a spreadsheet application worksheet and a database data source that allows modified data to be written from a spreadsheet application to source data in a database data source from which the original pre-modified data was obtained. Offline data changes in a spreadsheet application are cached by a data provider application and are published to a remote data source when the spreadsheet application is synchronized with the data source. Error conditions and data conflicts resulting from new or modified data published to a database data source from a spreadsheet application worksheet are reported to a user of the spreadsheet application worksheet through a data provider application to allow the user an opportunity to resolve error conditions and data conflicts between the user's data changes and other data changes made to the same source data contained in the database data source.

Data source write back and offline data editing and storage in a spreadsheet

Formats are extended automatically to cells in an electronic spreadsheet. Previously blank, newly edited cell(s) are determined to be an extension or within a list of cells based on having a consistent data type, and the like. Next, formatting of the list of cells is examined for consistency. If consistent formatting exists, it is applied to the previously blank, newly edited cell(s). List of cells may include rows, columns, and the like.

Extension of formulas and formatting in an electronic spreadsheet

An electronic spreadsheet is provided for automatically creating, expanding, and validating lists of cells. A list is created by receiving a user request for selecting a cell range, identifying a list range for the selected cell range, determining a header row for the list range, and generating a border for surrounding the list range. A list is expanded by determining that one or more cells are adjacent to the list and automatically expanding the list to include the new cells. A list is validated by determining a data type of data entered into the list and comparing the data type of the data entered into the list to a list data type. If, as a result of the comparison, the data type of the data entered into the list does not match the list data type, then the data type of the data entered into the list is invalid.

Creating and managing structured data in an electronic spreadsheet

Methods for automatically, without user instruction, extending a format and/or a formula to include a cell in an electronic spreadsheet. A previously blank newly edited cell may be determined to be an extension to or within a list of cells. A list of cells may be defined as a number of previous cells having a consistent data type. If a list of cells exists and the previously blank newly edited cell also includes the consistent data type, the previously blank newly edited cell is considered to be an extension of or within a list. The cells in the list are then examined for consistent formatting. If consistent formatting exists in the list, the consistent formatting is applied to the previously blank newly edited cell. Also, the cells in the list are examined for consistent formulas. The rows containing the cells in the list are each examined for a consistent formula having all supporting cells populated. If such a consistent formula is detected, it is applied to the row containing the previously blank newly edited cell. Also, the spreadsheet is scanned for aggregating formulas that reference the cells within the list. If an aggregating formula is discovered, it is updated to include the value of the data stored in the previously blank newly edited cell.

A spreadsheet program saves data into a hypertext markup language (HTML) document that can be viewed with a browser program, but persists all of the information associated with that data necessary to maintain formatting and functionality of the data if reintroduced into the spreadsheet program. The HTML document can then be used both for displaying the data over the Internet or other network in a browser program, and also for opening the data in the spreadsheet program. The information necessary for preserving the format and functionality of the data in the spreadsheet program is incorporated into the HTML document using HTML, Cascading Style Sheets (CSS), and Extended Markup Language (XML). HTML is used for expressing cell data information that is displayed in the browser program, CSS are used for expressing cell-level properties of the data, and XML is used for expressing information that is not displayed in the browser program, but which is necessary for some functionality of the data when used in the spreadsheet program. If any formatting of the data are changed to enable display of the data in the browser program as displayed in the spreadsheet program, the original formatting information is retained in a supporting file that is ignored by a browser program.

Storage of application specific data in HTML

A method and system for loading files into a spreadsheet application program (SAP) operating on a computer system, using an escalating load sequence. The SAP determines if a normal load mode failed while attempting to load the files. In response to determining that the normal load mode failed, the SAP escalates the load sequence to a safe load mode, where a plurality of checks are performed and the files are repaired. The SAP also determines if the safe load mode was successful in repairing and loading the files. If the SAP determines that the safe load mode was unsuccessful, the SAP escalates the load sequence to a data recovery mode, where the spreadsheet application program attempts to extract formulas and values from the file.

Method and system for repairing corrupt files and recovering data

Growing community of inventors

Redmond, WA, United States of America

Robert Wayne Coffen