METHODS, SYSTEMS AND COMPUTER PROGRAM PRODUCTS FOR PROCESSING CELLS IN A SPREADSHEET

摘要

Methods, systems and computer program products are provided for processing cells in a spreadsheet. A first formula contained in a first cell and a second formula contained in a second cell to provide a consolidated formula, wherein the second formula references the output of the first cell are automatically consolidated. The consolidated formula is stored in a single cell. Further methods, systems and computer program products are provided for processing cells in a spreadsheet and wherein a first cell, a second cell that is referenced as a precedent cell by a formula contained in the first cell, and a formula or data contained in the second cell are displayed while hiding the formula contained in the first cell and its value.