The application discloses a kind of multi-dimension
data management method and
system based on spreadsheet, method includes: in response to the editing operation instruction of the spreadsheet displayed to
client, update the table structure and table data of spreadsheet;Editing operation instruction at least includes one of the drag instruction for dragging the row, column of spreadsheet to freely combine, the hidden filter instruction for hiding filter row, column and the sorting instruction for sorting the data of row, column;Capture the
timestamp corresponding to editing operation instruction, with
timestamp as index, updated table structure and table data as history data modification
record, store the mapping relationship between index and history data modification
record;Through mapping relationship, trace history data modification
record.Therefore, by using the embodiment of the application, multi-dimension operation can meet the needs of enterprise to
inventory management refinement, individualization, while can track to operator and modification history, improve the security and reliability of data.