These are definitely items that we are thinking about and exploring ways to implement. For situations where there is data that cannot be shared in a doc, Cross-doc might be a good alternative. In the original doc, create a view of the table to be shared and hide any columns you don’t want to be visible in the new doc. Then in the new doc, when you sync it over, any hidden data in the first doc is not retrievable in any way.
Locking, permissions, and protection are difficult for a multitude of reasons and not really something a simple toggle can take care of. One example is thinking through what’s available through formulas within the doc if some data is there but shouldn’t be used.
Here is a better post explaining some of these items and the hurdles we need to consider while building this out…
I know this doesn’t answer everything for you as it is all still a work in progress as we explore the best ways to implement these solutions. Your feedback is definitely heard and we’ll keep moving forward with it!
Ben