| View previous topic :: View next topic |
| Author |
Message |
stepanstas
Newbie
Joined: 13 Jan 2007
Posts: 2
|
 Posted: Sat Jan 13, 2007 7:32 am Post subject: Multiple Cell Group Merge Not There |
 |
|
Excell has this feature, and i use it a lot
So i though you may want to add it to OOo
If i Selected row 1 and 5 together (using CTRL)
I cannot merge
what i would want to do is to merge them as two separate things, not together
the ctrl function itself works (selecting groups of cells, but not when they are together (ex. I want A1-C1,A2-C2, and A3-C3 to have the same properties (what i use is merge across). currently it merges the cells all together
do you understand? |
|
| Back to top |
|
 |
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Sat Jan 13, 2007 7:24 pm Post subject: |
|
|
I may misunderstand. You can copy one row and use Paste-Special to paste its formats to another.
_________________
search forum by month |
|
| Back to top |
|
|
jasondodd
General User
Joined: 25 Mar 2005
Posts: 20
Location: Colo, Iowa
|
| Posted: Sun Jan 14, 2007 3:33 pm Post subject: |
|
|
| I also use that feature a lot and miss it in ooo. They issue is really around using multiple selects for the merge feature. I do a lot of heavy formatting of spreadsheets and that would be real handy. Maybe there is a way to use styles to apply this to multiple selections??? I'll have to try that. |
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Sun Jan 14, 2007 4:04 pm Post subject: |
|
|
I posted a macro for merging a block row by row. It could be adapted easily to merge column by column:
| Code: | Sub mergeColByCol
'First select the range of cells you want merged. This will merge the selected cells with
'other selected cells in the same column. It will only work with a range of contiguous cells.
' CODE REMOVED
End Sub |
I regret I misread the op as A --> C instead of A to C.
"Merge" is not a cell property which can be set in a style.
_________________
search forum by month
Last edited by noranthon on Wed Jun 13, 2007 6:08 pm; edited 1 time in total |
|
| Back to top |
|
|
stepanstas
Newbie
Joined: 13 Jan 2007
Posts: 2
|
| Posted: Tue Jan 16, 2007 5:06 pm Post subject: |
|
|
Im glad to know im not alone
noranthon, im not sure if you still understand
maybe this will help
 |
|
| Back to top |
|
|
|
