https://bugs.documentfoundation.org/show_bug.cgi?id=164013
--- Comment #5 from george <[email protected]> --- (In reply to Christopher R Lee from comment #4) > This issue dates from 2012 at the latest and it's one of a couple of things > that continue to prevent widespread use of LibreOffice, even in very small > associations and enterprises, a serious matter in the present world IT > context. Thank you for bringing this up and emphasizing the broader impact. I looked into how the other major cloud competitor handles this: Google Sheets actually suffers from a very similar limitation. In Google Sheets, you can set data validation to "Reject input" on invalid entries, but there is no native way to protect cell formatting and underlying validation rules while keeping cell editing open. A standard paste operation (Ctrl+V) from an external source will overwrite styles, borders, and number formatting unless you resort to custom Apps Scripts or lock the entire range completely, which prevents data entry altogether. Only Microsoft Excel currently provides granular protection options to lock cell formatting and validation while still permitting end users to input data. Because both Google Sheets and LibreOffice Calc are missing this proper distinction between rule protection and value editing, implementing this feature in Calc is more than just catching up with Excel. It represents a genuine opportunity for LibreOffice to pull ahead of Google Sheets and offer a superior workflow for shared templates and administrative forms. -- You are receiving this mail because: You are the assignee for the bug.
