Bug 137589 - Repeat: Merge Cells (Shift-Ctrl-Y) doesn't do same as Merge
Summary: Repeat: Merge Cells (Shift-Ctrl-Y) doesn't do same as Merge
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Merge-Split
  Show dependency treegraph
Reported: 2020-10-19 10:31 UTC by JamesGibb
Modified: 2023-08-24 04:37 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

test file (7.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-19 15:38 UTC, BogdanB

Note You need to log in before you can comment on or make changes to this bug.
Description JamesGibb 2020-10-19 10:31:08 UTC
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
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: (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