https://bugs.documentfoundation.org/show_bug.cgi?id=147837
--- Comment #8 from JO3EMC <jo3...@jarl.com> --- Dialogs are certainly one approach, and I think it's not a bad way at this point for picking up all the requests. However, what is proposed here is the selection of the initial value there. My opinion is that "Empty the contents of the hidden cells" is better. Many of the people around me have similar ideas, and so far no one has any other ideas. Opinions are also exchanged in the Japanese category of Ask, and it is such a situation. https://ask.libreoffice.org/t/topic/74933 Although it deviates a little from the proposal of this issue. >From the perspective of not breaking existing data or formulas, "Keep the contents of the hidden cells" is certainly "safer". But I think that kind of safety is not necessary. Cell merging changes the appearance and structure of the "visible sheet". If the structure of the sheet changes, I think it may be natural that the written content is damaged, in a sense. Similar things usually happen with other cell operations. Rather, it is more dangerous that information that is difficult for the user to know is left in the "invisible place". It is difficult to follow the behavior of formulas, and also there is the risk of information leakage. "Safe" depends on the point of view. It seems more dangerous to me that it is harder to detect invisible data. The introduction of the "Hidden Row / Column Indicator" feature in LibreOffice 7.4 may also be from a similar perspective. I think the Bug 137780 introduced in Comment 5 is standing on this view. Data loss is usually visible. We can notice. If the data is promised not to be hidden, the awareness is even more certain. Microsoft doesn't always do the right thing, but it can be right. To me, Microsoft's judgment seems to be better on this issue. -- You are receiving this mail because: You are the assignee for the bug.
