Description: Merge Cell Problem version LibreOffice Calc Version: 6.0.6.2 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. Summary 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: 1.select cell 2.select Format 3.select Merge 4.select Merge Actual Results: cells are merged, but "Merge and Centered" is checked Expected Results: Either "Merge" is shown selected or only "Split Cells" is allowed. Other related problems --- See summary Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [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 ***