Bug 143477

Summary: Can not merge cells if some cells has been merged
Product: LibreOffice Reporter: CH_LUT. <xinyuzhong>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: buzea.bogdan, libreajans
Priority: low    
Version: Inherited From OOo   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108320    
Attachments: A plain text file which show the problem step by step.
A chinese video file which show the problem.
A english video file which show the problem

Description CH_LUT. 2021-07-21 13:26:41 UTC
Description:
Libreoffice Calc can not merge  some merged cells  with other cells .
Suggestions for improvement:I hope Libreoffice Calc can merge cells each oher  without limit like as MS Office Excel or Wps .


Steps to Reproduce:
Libreoffice Calc can not merge  some merged cells  with other cells .

Actual Results:
Libreoffice Calc can not merge  some merged cells  with other cells .

Expected Results:
Suggestions for improvement:I hope Libreoffice Calc can merge cells each oher  without limit like as MS Office Excel or Wps .


Reproducible: Always


User Profile Reset: No



Additional Info:
No
Comment 1 Timur 2021-07-26 11:10:50 UTC Comment hidden (obsolete)
Comment 2 CH_LUT. 2021-07-26 15:40:12 UTC
Created attachment 173863 [details]
A plain text file which show the problem step by step.
Comment 3 CH_LUT. 2021-07-26 15:56:27 UTC Comment hidden (obsolete)
Comment 4 CH_LUT. 2021-07-26 16:04:38 UTC
Created attachment 173864 [details]
A chinese video file which show the problem.
Comment 5 CH_LUT. 2021-07-27 00:09:56 UTC
Created attachment 173869 [details]
A english video file which show the problem

This is an english video file which show the problem.
Comment 6 Timur 2021-07-27 08:28:20 UTC
Reporter:
- you don't need to add ODT with simple text and image, just attach that image nex time
- in ODT you repeated what's clear, but didn't provide new info
- in video you also show the same (with new info that you merge via right-click, not via toolbar)
- you may not set New yourself
- if you provide requested info, you need set Unconfirmed.

But:
- I see now that merge is possible is MSO; while main course of action is to unmerge and merge again, drop-down button makes it possible to merge with merged cells
- so let's keep New status for enhancement
- merging with merged cell in MSO is one-click faster, but it looses data, it says "Merging cells only keeps upper-left value and discards other values"; so you don't options that LO offers
- at best, this is Low priority if feasible at all - it's very simple to use toolbar icon in LO twice, with merged and new cells marked, to unmark merged and to get a dialog how to merge them all
- I guess the option is to add dropdown button, but let's leave it to UX.
Comment 7 m_a_riosv 2022-08-02 22:14:46 UTC
*** Bug 150238 has been marked as a duplicate of this bug. ***
Comment 8 BogdanB 2022-08-07 19:26:41 UTC
Also in
Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 3ccbfaaf95005a34ca64ad250463ef5ce8842f43
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 9 BogdanB 2023-05-13 12:47:07 UTC
Also in
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 5cd9de202765e243e41416802f3e4486b8a96f16
CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded