AUTOMATICALLY ADJUSTING SPREADSHEET FORMULAS AND/OR FORMATTING

• US 20170139893A1
• Filed: 11/09/2016
• Published: 05/18/2017
• Est. Priority Date: 11/12/2015
• Status: Abandoned Application

• Current Assignee: Smartsheet Inc.
• Original Assignee: Smartsheet Inc.
• Inventors: Maliska, JR., Thomas P., Rucker, Erik
• Application Number:
  US15/347,630
• Publication Number:
  US 20170139893A1
• Time in Patent Office: Days
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

In some embodiments, if a Master Row is associated with tabular data, a formatting operation replicates formatting from the Master Row in any new row created at the same level of hierarchy in the tabular data. In some embodiments, the tabular data editor allows users to specify whether formatting set by a user edit in a cell before application of a Master Row results in a merger or override. In some embodiments, formatting set by a user edit after a Master Row is applied is treated as custom edit to that cell or row, and is not again changed to match the Master Row (unless the hierarchy of the row changes, and another Master Row is applied).

Claims

1. A computer-implemented method of automatically modifying a computerized information display, the method comprising:

detecting, by a computing device, that a trigger indicating an updated row in a spreadsheet has been activated;

reviewing, by the computing device, a set of master rows to determine if the updated row should be automatically modified based on a corresponding master row; and

in response to identifying a corresponding master row to be used to modify the updated row, modifying, by the computing device, the updated row based on the identified master row.