Bug 137589

Summary: Repeat: Merge Cells (Shift-Ctrl-Y) doesn't do same as Merge
Product: LibreOffice Reporter: JamesGibb
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: aaronthj82, buzea.bogdan
Priority: medium    
Version: 6.3.6.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108320    
Attachments: test file

Description JamesGibb 2020-10-19 10:31:08 UTC
Description:
Merging a series of pairs cells in Calc, when the Merge and Centre Cells button is used works as it should, but if then Shift-Ctrl-Y is used the contents are not centred.
Document is in xlsx format.  Text is orientated at 90­°

Steps to Reproduce:
1.Enter text into two non-adjecent cells.
2.Select one of them and an adjacent one and then Merge and Centre Cells
3.Select the second one and an adjecent cell and use Shidft-Ctrl-Y to repeat the action

Actual Results:
The first merge and centre results in centred content.  The second only merges and does not centre the content.

Expected Results:
Both merged contents to be centred.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 BogdanB 2020-10-19 15:38:43 UTC
Created attachment 166516 [details]
test file

Confirm with
Version: 7.0.2.2
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

but doesn't depend of type of file, is the same in any .odf file

Step to reproduce:

- Please open my file (.odf file)
- Select the cell with "A" and the next cell after -> Merge them -> center align
- Select the cell with "B" and the next cell after -> Ctrl+Shift+Y -> left align
Comment 2 QA Administrators 2022-10-20 03:44:21 UTC Comment hidden (obsolete)
Comment 3 Aaron 2023-08-24 04:37:45 UTC
This bug is still present in

Version: 7.5.5.2 (X86_64) / LibreOffice Community
Build ID: ca8fe7424262805f223b9a2334bc7181abbcbf5e
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-AU (fr_FR); UI: en-US
Calc: threaded