Bug Hunting Session
Bug 53850 - EDITING: Implement "Merge across" Excel feature - merge all cells in each row inside selection
Summary: EDITING: Implement "Merge across" Excel feature - merge all cells in each row...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: Calc-Merge-Split
  Show dependency treegraph
 
Reported: 2012-08-20 15:40 UTC by machaao
Modified: 2017-07-31 14:42 UTC (History)
6 users (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 machaao 2012-08-20 15:40:51 UTC
Problem description: 
I want a function, connecting cells in row.
MS exel has this function.
Please carry out this function.
Steps to reproduce:
1. ....
2. ....
3. ....

Current behavior:

Expected behavior:

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; CIBA; .NET4.0C; .NET CLR 1.1.4322)
Comment 1 bfoman (inactive) 2012-08-20 18:46:23 UTC
(In reply to comment #0)
> I want a function, connecting cells in row.
> MS exel has this function.
> Please carry out this function.

Please elaborate - detailed description will help to implement it (or find it if it is already available).
Comment 2 Lekow 2012-08-28 19:30:07 UTC
As I understand, the bug reporter suggested to implement the feature that is called "Merge across" in MS Office. It merges cells not to the one large cell, but merge all cells in each row inside selection. E.g. 5x5 selection will produce the 5x1 result. Here is the video about merging cells in Excel: http://www.youtube.com/watch?v=YERPlOfd8Kk&t=114s 

I can not find such function in Calc, so I join the feature request. It is very useful feature.
Comment 3 bfoman (inactive) 2012-10-11 21:01:55 UTC
NEW as feature request explained.
I added commenters to CC list, as this is an indication if a request is popular demand.
Comment 4 Christian Pietzsch 2015-08-17 20:29:57 UTC
This would be a very useful feature. But it shouldn't be limited to merging rows. You should be able to determine whether you want to merge rows or columns.
Comment 5 john 2017-04-11 00:29:14 UTC
Me too. This would be a very useful feature. I typically use "merge across" far more often than "merge" in Excel, I'm imagine others are probably the same.

Here is a macro implementation that I have not tried,
https://ask.libreoffice.org/en/question/76156/calc-merge-across-tool/
Comment 6 Marc Meledandri 2017-06-04 19:04:57 UTC
Please implement this rather common functionality.

I use merge across more often than any other form of cell merging.
Comment 7 Mark Jeronimus 2017-07-31 14:42:58 UTC
Workaround: Merge only first row. Copy. Select rest of the rows. Paste special - only format.