Formula display and search in a spreadsheet
In some embodiments, a spreadsheet application provides an option for collectively displaying the formulas associated with a set of cells in a separate view. In some embodiments, the view provides an option to search within the formulas (and/or other content) provided by the view. In some embodiments, a find and replace user interface of a spreadsheet application includes an option to search only in formulas.
1. A computer program product comprising a non-transitory computer readable storage medium storing a plurality of instructions, that when executed by a computing device having a display and an input device, cause the computing device to perform operations for processing a set of cells in a spreadsheet application, the operations comprising:
displaying, on the display, a portion of a spreadsheet, wherein the spreadsheet includes:
a first cell at a first cell location in a first table of the spreadsheet, wherein the first cell includes a first value determined based on a first formula, and
a second cell at a second cell location in a second table of the spreadsheet, wherein the second cell includes a second value determined based on a second formula; and
while displaying the portion of the spreadsheet on the display:
detecting, with the input device, an input corresponding to a request to concurrently display formula information for the first cell and the second cell; and
in response to detecting the input, displaying, on the display, formula view, wherein displaying the formula view includes concurrently displaying:
a cell location column that includes the first cell location for the first cell and the second cell location for the second cell,
a cell value column that includes the first value and the second value, and
a cell formula column that includes the first formula and the second formula, the cell location column being distinct from the cell formula column, wherein the formula view is grouped based on one or more of the following hierarchical divisions: documents, sheets or canvases, tables, rows of a table, columns of a table, and cells of a table.
2. The computer program product recited in claim 1 , wherein displaying the portion of the spreadsheet comprises displaying a primary view in a user interface of the spreadsheet application.
3. The computer program product recited in claim 1 , wherein:
the spreadsheet is a multi-sheet spreadsheet;
the first cell is in a first sheet of the spreadsheet; and
the second cell is in a second sheet of the spreadsheet.
4. The computer program product recited in claim 1 , wherein the formula view comprises a list.
5. The computer program product recited in claim 1 , wherein the formula view includes options to expand or collapse one or more of the hierarchical divisions.
6. The computer program product recited in claim 1 , wherein the formula view is hierarchically presented in a user interface based on a plurality of hierarchical divisions of the cells in the portion of the spreadsheet.
7. The computer program product recited in claim 1 , wherein the formula view comprises a user interface that includes one or more options for manipulating data presented in the formula view.
8. A system for processing a set of cells in a spreadsheet application, the system comprising:
a processor;
a display;
an input device; and
a memory having instructions stored thereon that when executed by the processor, cause the processor to:
display, on the display a portion of a spreadsheet, wherein the spreadsheet includes:
a first cell at a first cell location in a first table of the spreadsheet, wherein the first cell includes a first value determined based on a first formula, and
a second cell at a second cell location in a second table of the spreadsheet, wherein the second cell includes a second value determined based on a second formula; and
while displaying the portion of the spreadsheet on the display:
detect, with the input device, an input corresponding to a request to concurrently display formula information for the first cell and the second cell; and
in response to detecting the input, display, on the display, formula view, wherein displaying the formula view includes concurrently displaying:
a cell location column that includes the first cell location for the first cell and the second cell location for the second cell,
a cell value column that includes the first value and the second value, and
a cell formula column, that includes the first formula and the second formula, the cell location column being distinct from the cell formula column, wherein the formula view is grouped based on one or more of the following hierarchical divisions: documents, sheets or canvases, tables, rows of a table, columns of a table, and cells of a table.
9. The system recited in claim 8 , wherein displaying the portion of the spreadsheet comprises displaying a primary view in a user interface of the spreadsheet application.
10. The system recited in claim 8 , wherein the formula view is hierarchically presented in a user interface based on a plurality of hierarchical divisions of the cells in the portion of the spreadsheet.
11. The system recited in claim 8 , wherein:
the spreadsheet is a multi-sheet spreadsheet;
the first cell is in a first sheet of the spreadsheet; and
the second cell is in a second sheet of the spreadsheet.
12. The system recited in claim 8 , wherein the formula view comprises a list.
13. The system recited in claim 8 , wherein the formula view includes options to expand or collapse one or more of the hierarchical divisions.
14. The system recited in claim 8 , wherein the formula view comprises a user interface that includes one or more options for manipulating data presented in the formula view.
15. A computer implemented method for processing a set of cells in a spreadsheet application, the method comprising:
displaying, on the display, a portion of a spreadsheet, wherein the spreadsheet includes:
a first cell at a first cell location in a first table of the spreadsheet, wherein the first cell includes a first value determined based on a first formula, and
a second cell at a second cell location in a second table of the spreadsheet, wherein the second cell includes a second value determined based on a second formula; and
while displaying the portion of the spreadsheet on the display:
detecting, with the input device, an input corresponding to a request to concurrently display formula information for the first cell and the second cell; and
in response to detecting the input, displaying, on the display, a formula view, wherein displaying the formula view includes concurrently displaying:
a cell location column that includes the first cell location for the first cell and the second cell location for the second cell,
a cell value column that includes the first value and the second value, and
a cell formula column that includes the first formula and the second formula, the cell location column being distinct from the cell formula column, wherein the formula view is grouped based on one or more of the following hierarchical divisions: documents, sheets or canvases, tables, rows of a table, columns of a table, and cells of a table.
16. The method recited in claim 15 , wherein displaying the portion of the spreadsheet comprises displaying a primary view in a user interface of the spreadsheet application.
17. The method recited in claim 15 , wherein the formula view comprises a user interface that includes one or more options for manipulating data presented in the formula view.
18. The method recited in claim 15 , wherein the formula view comprises a list.