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, wherein the first spreadsheet includes a protected content;
performing one or more mapping tests on the standardized spreadsheet to determine whether the standardized spreadsheet includes one or more informalities;
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; 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 one or more mapping tests comprises an analytical report test and a scenario comparison check.
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. 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 wherein the first spreadsheet includes a protected content;
perform one or more mapping tests on the standardized spreadsheet to determine whether the standardized spreadsheet includes one or more informalities;
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; and
generate a report for display at a user interface for a result of the one or more mapping tests.
9. The system of claim 8 , wherein the one or more mapping tests comprises a hash error check that determines whether there is a formula failure in the standardized spreadsheet.
10. The system of claim 8 , 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.
11. The system of claim 8 , wherein the one or more mapping tests comprises an external reference check that scans one or more external references in the first spreadsheet.
12. The system of claim 8 , 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.
13. The system of claim 8 , wherein the one or more mapping tests comprises an analytical report test and a scenario comparison check.
14. The system of claim 8 , wherein the one or more mapping tests are performed responsive to an edit to the first spreadsheet or the second spreadsheet.
15. 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, wherein the first spreadsheet includes a protected content;
perform one or more mapping tests on the standardized spreadsheet to determine whether the standardized spreadsheet includes one or more informalities;
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; and
generate a report for display at a user interface for a result of the one or more mapping tests.
16. The non-transitory computer-readable medium of claim 15 , wherein the one or more mapping tests comprises a hash error check that determines whether there is a formula failure in the standardized spreadsheet.
17. The non-transitory computer-readable medium of claim 15 , 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.
18. The non-transitory computer-readable medium of claim 15 , wherein the one or more mapping tests comprises an external reference check that scans one or more external references in the first spreadsheet.
19. The non-transitory computer-readable medium of claim 15 , 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.
20. The non-transitory computer-readable medium of claim 15 , wherein the one or more mapping tests comprises an analytical report test and a scenario comparison check.