How does BCP compare with “spreadsheet compliance” solutions?
Most spreadsheet compliance solutions work with spreadsheets as individual files (not ranges of data) and tell a company what has happened with the file not unlike Excel’s own basic revision tracking capability– there is no central version of the truth for shared data/formulas at the cell level—only at the file level. This means there is: • No collaborative sharing of data/formula sharing • No consolidation • No cell-level access control • Versions are done at the file level using a “diff” capability (versus through a versioned database) • Changes are managed through a tabular dump– there’s no “in spreadsheet” change management Also, data security is managed by the database with BCP– not just locally in a given spreadsheet.
