公开(公告)号：US20220253597A1

公开(公告)日：2022-08-11

申请号：US17169076

申请日：2021-02-05

Applicant: Microsoft Technology Licensing, LLC

Inventor： John Herbert Martin Williams ,  Andrew Donald Gordon ,  Joseph McDaid ,  Benjamin Edward Rampson ,  Brian Jones

IPC: G06F40/18 ,  G06F40/169 ,  G06F16/22 ,  G06F16/23

Abstract: A system for provenance aware editing for propagating edits back to spreadsheets is provided. The system receives an indication of an operation to be performed at an output location. The operation indicates one or more input locations on a spreadsheet that each provides an input value. The input values are accessed and tagged with their corresponding input location on the spreadsheet. Based on the operation and the input value from each of the one or more input locations, the system derives and displays the result at the output location. A user edit to the result is received at the output location, which causes transmission of a propagation request to change the input value at one or more of the tagged input locations. Using where-provenance associated with the tagged input locations, the system propagates the user edit to one or more of the tagged input locations.

公开(公告)号：US11636254B2

公开(公告)日：2023-04-25

申请号：US17169076

申请日：2021-02-05

Applicant: Microsoft Technology Licensing, LLC

Inventor： John Herbert Martin Williams ,  Andrew Donald Gordon ,  Joseph McDaid ,  Benjamin Edward Rampson ,  Brian Jones

IPC: G06F40/18 ,  G06F16/22 ,  G06F16/23 ,  G06F40/169

Abstract: A system for provenance aware editing for propagating edits back to spreadsheets is provided. The system receives an indication of an operation to be performed at an output location. The operation indicates one or more input locations on a spreadsheet that each provides an input value. The input values are accessed and tagged with their corresponding input location on the spreadsheet. Based on the operation and the input value from each of the one or more input locations, the system derives and displays the result at the output location. A user edit to the result is received at the output location, which causes transmission of a propagation request to change the input value at one or more of the tagged input locations. Using where-provenance associated with the tagged input locations, the system propagates the user edit to one or more of the tagged input locations.

公开(公告)号：US11461544B2

公开(公告)日：2022-10-04

申请号：US16848753

申请日：2020-04-14

Applicant: Microsoft Technology Licensing, LLC

Inventor： Advait Sarkar ,  Andrew Donald Gordon ,  John Herbert Martin Williams

IPC: G06F40/18 ,  G06F3/04817 ,  G06F3/0482 ,  G06F40/174

Abstract: A spreadsheet application displays a spreadsheet of cells in tabular form. User input is received specifying an input range of cells of the spreadsheet, a destination range of cells of the spreadsheet and a local modification. A memory stores a representation of the spreadsheet indicating formatting, values and formulas. An update of the representation is computed by applying the local modifications to the representation. Values of cells of the input range of the spreadsheet are calculated by using the updated representation and the calculated values are displayed at the destination range.