Merge Cell Problem version LibreOffice Calc Version: 184.108.40.206
The "Merge Cells" mechanism give unexpected results.
During merging cells to contain long strings I discovered several unexpected results.
1. Select the cells in the row containing the string then
Format > Merge Cells > Merge Cells properly merges cells
But repeating Format > Merge Cells shows that the Merge and Center Cells options is selected.
I expected the Merge Cells option to show selected.
If the selected Merge and Center Cells option is now clicked on, the cells are split. This might be proper unchecking of the option to get back to the pre-merged condition and may be equivalent to the Split Cells option.
2. Select the cells in the row containing the string then
Format > Merge Cells > Merge and Center Cells properly merges centers cells
and repeating Format > Merge Cells shows that the Merge and Center Cells options is properly selected. If the selected Merge and Center Cells option again is clicked on, the cells are again split. This might be proper unchecking of the option to get back to the pre-merged condition (equivalent to the Split Cells option).
But Select the cells in the row containing the string then
Format > Merge Cells > Merge Cells now merges and center cells.
I expected the cells to be merged and not centered.
a. Clicking on either "Merge" or "Merge and Center" options results in a checkmark appearing by the "Merge and Center" option.
b. Clicking anywhere in the Merge option menu after either selecting "Merge" or "Merge and Center" appears to be equivalent to clicking on the "Split Cells" option.
b. Once "Merge and Center" is inflicted on cells, attempting to change to "Merge" by "Split" and "Merge" result in "Merge and Center"
Steps to Reproduce:
cells are merged, but "Merge and Centered" is checked
Either "Merge" is shown selected or only "Split Cells" is allowed. Other related problems --- See summary
User Profile Reset: No
[Information automatically included from LibreOffice]
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Not only this is duplicate, but you reported it.
*** This bug has been marked as a duplicate of bug 116513 ***