Mapping tests of spreadsheets in server-browser environments
A file management system may include a file server that performs calculations of a spreadsheet file instance to generate a dataset that includes values in the spreadsheet file instance. The file management system also may include an application operating at a client device that is in communication with the file server via a network. The application may receive, via the network, a version of the dataset comprising the values generated by the calculations performed by the server. The application may visualize a spreadsheet at the user interface. The visualized spreadsheet may display at least a subset of the values. In one case, protected contents of one or more cells in the spreadsheet may be converted to other values when displayed at the user interface.
1. A computer-implemented method comprising:
storing a first spreadsheet having a first arrangement of data;
storing a second spreadsheet having a second arrangement of data different from the first arrangement of data;
storing a standardized spreadsheet that stores a first mapping to the first spreadsheet and a second mapping to the second spreadsheet, the standardized spreadsheet being a third spreadsheet that (1) associates a set of cells in the standardized spreadsheet to a first set of cells in the first spreadsheet according to the first mapping and (2) associates the same set of cells in the standardized spreadsheet to a second set of cells in the second spreadsheet according to the second mapping;
performing one or more mapping tests on the standardized spreadsheet to determine whether the standardized spreadsheet includes one or more informalities, wherein the one or more mapping tests comprises an analytical report test and a scenario comparison check; and
generating a report for display at a user interface for a result of the one or more mapping tests.
2. The computer-implemented method of claim 1 , wherein the one or more mapping tests comprises a hash error check that determines whether there is a formula failure in the standardized spreadsheet.
3. The computer-implemented method of claim 1 , wherein the one or more mapping tests comprises a cell value comparison test that compares a first value in a first cell in the first spreadsheet to a value in a cell of the standardized spreadsheet, the first cell and the cell of the standardized spreadsheet are associated according to the first mapping.
4. The computer-implemented method of claim 1 , wherein the one or more mapping tests comprises an external reference check that scans one or more external references in the first spreadsheet.
5. The computer-implemented method of claim 1 , wherein the one or more mapping tests comprises an aggregation test that determines whether a value in a dashboard cell of the standardized spreadsheet is aggregated correctly.
6. The computer-implemented method of claim 1 , wherein the standardized spreadsheet is associated with a plurality of scenarios, each scenario associated with a set of predetermined values for one or more cells.
7. The computer-implemented method of claim 1 , wherein the one or more mapping tests are performed responsive to an edit to the first spreadsheet or the second spreadsheet.
8. The computer-implemented method of claim 1 , wherein the first spreadsheet is private includes a protected content, the computer-implemented method further comprises generating a public publication that removes the protected content, wherein the one or more mapping tests comprises a test that scans for whether the protected content is included in the public publication.
9. A system comprising:
one or more processors; and
memory coupled to the one or more processors, the memory storing computer code comprising instructions, the instructions, when executed by the one or more processors, cause the one or more processors to:
store a first spreadsheet having a first arrangement of data;
store a second spreadsheet having a second arrangement of data different from the first arrangement of data;
store a standardized spreadsheet that stores a first mapping to the first spreadsheet and a second mapping to the second spreadsheet, the standardized spreadsheet being a third spreadsheet that (1) associates a set of cells in the standardized spreadsheet to a first set of cells in the first spreadsheet according to the first mapping and (2) associates the same set of cells in the standardized spreadsheet to a second set of cells in the second spreadsheet according to the second mapping;
perform one or more mapping tests on the standardized spreadsheet to determine whether the standardized spreadsheet includes one or more informalities wherein the one or more mapping tests comprises an analytical report test and a scenario comparison check; and
generate a report for display at a user interface for a result of the one or more mapping tests.
10. The system of claim 9 , wherein the one or more mapping tests comprises a hash error check that determines whether there is a formula failure in the standardized spreadsheet.
11. The system of claim 9 , wherein the one or more mapping tests comprises a cell value comparison test that compares a first value in a first cell in the first spreadsheet to a value in a cell of the standardized spreadsheet, the first cell and the cell of the standardized spreadsheet are associated according to the first mapping.
12. The system of claim 9 , wherein the one or more mapping tests comprises an external reference check that scans one or more external references in the first spreadsheet.
13. The system of claim 9 , wherein the one or more mapping tests comprises an aggregation test that determines whether a value in a dashboard cell of the standardized spreadsheet is aggregated correctly.
14. The system of claim 9 , wherein the standardized spreadsheet is associated with a plurality of scenarios, each scenario associated with a set of predetermined values for one or more cells.
15. The system of claim 9 , wherein the one or more mapping tests are performed responsive to an edit to the first spreadsheet or the second spreadsheet.
16. The system of claim 9 , wherein the first spreadsheet is private includes a protected content, wherein the instructions further cause the one or more processors to generate a public publication that removes the protected content, wherein the one or more mapping tests comprises a test that scans for whether the protected content is included in the public publication.
17. A non-transitory computer-readable medium configured to store computer code comprising instructions, the instructions, when executed by one or more processors, cause the one or more processors to:
store a first spreadsheet having a first arrangement of data;
store a second spreadsheet having a second arrangement of data different from the first arrangement of data;
store a standardized spreadsheet that stores a first mapping to the first spreadsheet and a second mapping to the second spreadsheet, the standardized spreadsheet being a third spreadsheet that (1) associates a set of cells in the standardized spreadsheet to a first set of cells in the first spreadsheet according to the first mapping and (2) associates the same set of cells in the standardized spreadsheet to a second set of cells in the second spreadsheet according to the second mapping;
perform one or more mapping tests on the standardized spreadsheet to determine whether the standardized spreadsheet includes one or more informalities wherein the one or more mapping tests comprises an analytical report test and a scenario comparison check; and
generate a report for display at a user interface for a result of the one or more mapping tests.
18. The non-transitory computer-readable medium of claim 17 , wherein the one or more mapping tests comprises a hash error check that determines whether there is a formula failure in the standardized spreadsheet.
19. The non-transitory computer-readable medium of claim 17 , wherein the one or more mapping tests comprises a cell value comparison test that compares a first value in a first cell in the first spreadsheet to a value in a cell of the standardized spreadsheet, the first cell and the cell of the standardized spreadsheet are associated according to the first mapping.
20. The non-transitory computer-readable medium of claim 17 , wherein the one or more mapping tests comprises an external reference check that scans one or more external references in the first spreadsheet.