Since users can make cell-level changes concurrently to the same data, how does BCP determine which value in a spreadsheet “wins” when conflicting values are input by two separate users?
BCP’ approach to conflict resolution is to present all changes from all users during a given period to the participants– this is a unique part of our versioned database system which lets multiple users work concurrently and in isolation. All changes are presented to the users/manager who can then determine which one “wins” which, in our parlance, means is made the current version. There is no check-in/check-out and locking out users while concurrent updates are being processed. It’s important to note, too, that all the non-winning changes are not lost.
