Bug 139596 - Unexpected "Merge" option results in Calc
Summary: Unexpected "Merge" option results in Calc
Status: RESOLVED DUPLICATE of bug 116513
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.6.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-01-13 21:08 UTC by hugh
Modified: 2021-07-27 03:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description hugh 2021-01-13 21:08:34 UTC
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
Comment 1 Timur 2021-07-26 12:27:16 UTC
Not only this is duplicate, but you reported it.

*** This bug has been marked as a duplicate of bug 116513 ***