Effective deployment of spreadsheets in browser environments

A computer-implemented method, comprising:

• receiving, by a server, an opening of a spreadsheet file, the spreadsheet file comprising cells defined by rows and columns;
• transmitting, via a network, a dataset of the spreadsheet file for visualization of the spreadsheet file at a user interface of a client device;
• generating associations between values in the dataset and a plurality of cells in the spreadsheet file;
• receiving an indication that a first display area is displayed at the user interface;
• performing calculations for the spreadsheet file, the calculations involving a first subset of the cells that are projected to be covered by the first display area in the spreadsheet visualized at the user interface and a second subset of the cells that are projected to be excluded by the first display area;
• maintaining the associations between the second subset of the cells and the values that are assigned to the second subset of the cells while the second subset of the cells are outside of the first display area;
• receiving an indication of a change from the first display area to a second display area, the second display overlapping with at least one of the cells in the second subset;
• and
• transmit the values associated with the second subset of the cells to the client device.

A non-transitory computer readable medium for storing computer code comprising instructions, the instructions, when executed by a processor, cause the processor to:

• receive an opening of a spreadsheet file, the spreadsheet file comprising cells defined by rows and columns;
• transmit, via a network, a dataset of the spreadsheet file for visualization of the spreadsheet file at a user interface of a client device;
• generate associations between values in the dataset and a plurality of cells in the spreadsheet file;
• receive an indication that a first display area is displayed at the user interface;
• perform calculations for the spreadsheet file, the calculations involving a first subset of the cells that are projected to be covered by the first display area in the spreadsheet visualized at the user interface and a second subset of the cells that are projected to be excluded by the first display area;
• maintain the associations between the second subset of the cells and the values that are assigned to the second subset of the cells while the second subset of the cells are outside of the first display area;
• receive an indication of a change from the first display area to a second display area, the second display overlapping with at least one of the cells in the second subset;
• and
• transmit the values associated with the second subset of the cells to the client device.