| View previous topic :: View next topic |
| Author |
Message |
Grandis
OOo Advocate
Joined: 05 Mar 2007
Posts: 232
Location: Norway
|
 Posted: Sun Aug 03, 2008 9:06 pm Post subject: Merged cells - cannot copy contents nor format |
 |
|
Hi. I'm using OOo V2.41 on winXP.
Everytime I have two merged cells (equal number of spanned cells) and trying to use the format paintbrush I get the following errormsg:
And the format doesn't copy.
I can see nobody have posting a similar problem on the forum before - so that make me think this may be some option that is wrong.
The installation of OOo isn't new. Same setting since ver 2.31 (and installed OOo just over again without uninstall old versions) so it might be that. Anyone with same problem? If no, i guess delete all settings would help....
_________________
Windows XP sp2 |
|
| Back to top |
|
 |
PromptJock
Super User
Joined: 26 Jul 2006
Posts: 741
|
| Posted: Mon Aug 04, 2008 5:28 am Post subject: |
|
|
Are you trying to copy merged cells into OTHER merged cells? if you are, then that's the reason for the error message.
When you want to copy a "merged cell" field to another place in calc, the "target" MUST be a SINGLE, UNMERGED calc cell. Then, and only then, will your "merged cell" field successfully copy, along with all the formatting attributes of the "merged cell" field.
Does this make any sense or otherwise help? 
_________________
I'm making perfect sense - you're just not keeping up! |
|
| Back to top |
|
|
Grandis
OOo Advocate
Joined: 05 Mar 2007
Posts: 232
Location: Norway
|
| Posted: Mon Aug 04, 2008 7:09 am Post subject: |
|
|
| PromptJock wrote: | Are you trying to copy merged cells into OTHER merged cells? if you are, then that's the reason for the error message.
When you want to copy a "merged cell" field to another place in calc, the "target" MUST be a SINGLE, UNMERGED calc cell. Then, and only then, will your "merged cell" field successfully copy, along with all the formatting attributes of the "merged cell" field.
Does this make any sense or otherwise help? |
Sure it make sense. Thanks a lot 
Then I say:
Being able to copy contents between merged cells is a "missing feature".
ontopic (with that in mind):
That makes the workaround pretty easy: Just unmerge the merged cells that is target for the contents/format that is to be copied.
_________________
Windows XP sp2 |
|
| Back to top |
|
|
|
