https://bugs.documentfoundation.org/show_bug.cgi?id=147837
Bug ID: 147837
Summary: When merging cells, it is not good that 'Keep the
contents of the hidden cell' is the default
Product: LibreOffice
Version: 7.3.1.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When merging cells with Calc, it is not good that 'Keep the contents of the
hidden cells' is the default. In Excel, 'Empty the contents of the hidden
cells' is selected. I'm afraid this will cause compatibility issues, human
error issues.
Steps to Reproduce:
1.Input 1, 2 and 3 to each cell. Sum with the SUM function. The total is 6.
2.Copy and paste the range.
3.Combine 1,2,3 of cells. Select the default. The joint is displayed as 1. The
total is 6.
Actual Results:
Combining cells with the default selection will give different results than
Excel.
Expected Results:
'Empty the contents of the hidden cells' should be the default selection.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Upload the image compared with Excel.
--
You are receiving this mail because:
You are the assignee for the bug.
