Block properties and calculated columns in a spreadsheet application

US8621340B2 · kind B2 · utility

Assignee

• Microsoft Corporation · US

Inventors

• Joseph Chirilov · Kirkland, US
• Dennis R. Newland · Monroe, US
• Eoin Burke · Seattle, US
• Hannah W. Zhou · Redmond, US
• John C. Haymond · Duvall, US
• Juha Niemisto · Mercer Island, US
• Robert C. Collie · Kirkland, US
• Robert W. Coffen · Redmond, US
• Thao Moua · Bellevue, US

Key dates

• Filing date: Dec 20, 2004
• Grant date: Dec 31, 2013
• Expiry date: Oct 30, 2026

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F40/18
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

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.