How can online collaborative documents solve the situation where two users modify a cell at the same time because of network problems, what technology is needed to solve this? What are the clear and known solutions?

在线协同文档如何解决两个用户因网络问题同时修改一个单元格的情况，需要哪些技术来解决？有哪些明确且已知的解决方案？

By adding optimistic or pessimistic locks? How to solve it amicably?I'm more concerned with back-end processing solutions

通过添加乐观或悲观的锁？如何友好地解决？我更关心后端处理解决方案