CPC G06F 40/177 (2020.01) [G06F 11/0727 (2013.01); G06F 11/0784 (2013.01); G06F 21/6218 (2013.01)] | 20 Claims |
1. A computer-implemented method for creating a table, the method comprising:
receiving a request to create a table, the request including an indication of a number of columns and a number of rows for the table,
generating the table, the table comprising the number of columns and the number of rows indicated in the request, an intersection of a column and a row in the table being a cell of the table, the table further comprising a summary row;
rendering the table for display on a user interface of a client device, the table comprising a column type selection affordance for selecting a column type for at least one column rendered in the table and a summary type selection affordance for selecting a summary type for the at least one column rendered in the table; and
in response to receiving user input at the column type selection affordance, change the column type from a first column type to a second column type:
evaluating cell values of cells in the column for compatibility with the second column type;
in response to a first cell value being compatible with the second column type, rendering an updated cell value in accordance with the second column type;
in response to a second cell value being incompatible with the second column type, omitting the second cell value from a subsequent summary calculation in a respective cell of the summary row;
changing the summary type from a first summary type to a second summary type for a respective cell of the summary row;
computing a summary value for the respective cell of the summary row in accordance with the second summary type; and
causing display of the summary value in the respective cell of the summary row.
|