| View previous topic :: View next topic |
| Author |
Message |
breshead
General User
Joined: 22 Apr 2008
Posts: 5
|
|
| Back to top |
|
 |
PromptJock
Super User
Joined: 26 Jul 2006
Posts: 703
|
 Posted: Thu Apr 24, 2008 8:04 pm Post subject: |
 |
|
This topic was recently addressed.
The upshot is this: OOo calc CAN NOT copy/paste merged cells into other merged cells. You can, however, paste merged cells into SINGLE, UNMERGED cells elsewhere on the active sheet. The pasted area will then inherit the "attributes" of what's being pasted (i.e., the unmerged area will become "merged" based on what's being pasted).
The upshot of this "irritation" is this: you can't "pre-define" a "merged-cell" area in your sheet to copy data from another "merged-cell" area.
Does this make sense and/or answer your question?
_________________
Logic is tweeting bird in meadow... |
|
| Back to top |
|
|
breshead
General User
Joined: 22 Apr 2008
Posts: 5
|
| Posted: Mon Apr 28, 2008 9:41 am Post subject: |
|
|
| Quote: | | Does it make sense? |
Not really if the first link I posted was correct.
| Quote: | | Does it answer my question? |
Well, now I just have another one...
Do you think you could point me at the location where this was addressed?
Obviously there is a need for this functionality, especially where you have a "sectioned" spreadsheet and (in our case) each section has date headers, each one of which happen to be in merged cells.
With this feature you can simply change one row of dates and copy/paste to the other rows as the dates change.
Without this feature you will be left with a bunch of manual editing that should not be necessary. Actually what I will be left with is ordering a bunch of copies of "Real" Office, as my boss puts it, which I really do not want to do. ( I am trying to move us over to OO.org from MS Office 2000 before I have to update everything and it is making waves)
I would love to be able to see the conversation that ended in that decision just to know what the arguments were, who to "try" and talk to and what my chances are.
Sometimes my boss is amenable to paying for a feature if it is not overly expensive.
If the first link I posted of the PDF is correct then the "fix" should not be to hard, unless of course the developers are considering this a "correctness" issue. Even in that case maybe a option setting somewhere might be acceptable.
Regardless I would appreciate a pointer to that conversation topic if you would not mind.
Thanks for your time. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5671
Location: Canada
|
| Posted: Mon Apr 28, 2008 3:34 pm Post subject: |
|
|
| breshead wrote: |
Regardless I would appreciate a pointer to that conversation topic if you would not mind.
Thanks for your time. |
Try a Search [menu choice in this forum] using "merge AND cells". Third or fourth topic down.
David. |
|
| Back to top |
|
|
breshead
General User
Joined: 22 Apr 2008
Posts: 5
|
| Posted: Tue Apr 29, 2008 10:53 am Post subject: |
|
|
Thanks David for the pointer, I did not get the exact same list that you did as the third and fourth items were not applicable but after going though them I did find reference to this
http://qa.openoffice.org/issues/show_bug.cgi?id=7500 issue that appears to be almost identical for all practical purposes.
The good news is that it might be done in the next iteration of 2.4!
A rearranged google search also found this..
http://wiki.services.openoffice.org/wiki/Fr.openoffice.org/FeaturesCalc
Which is very cool and lists a lot of features cross ref'ed with open issues. I could not find a similar one for the english OO.org.
Specifically it lists the above issue and one more like my own http://distribution.openoffice.org/issues/show_bug.cgi?id=2131 that seems to have kind of trailed off into disuse.
However it looks like issue 7500 is active and hopefully will be in the next version.
P.S. I cannot imagine having to deal with so much information and disseminating it in a useful manner. Kudos to the group responsible. (And to the OO.org developers in general of course!) |
|
| Back to top |
|
|
|
