Issue 62867

Summary: Pasting cells in complex table does not work
Product: Calc Reporter: georgeen <jquiroga2005>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 3.2   
Target Milestone: ---   
Hardware: All   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Tables to test this and other issues none

Description georgeen 2006-03-07 14:50:08 UTC
Create a table with 7 columns and about 20 rows and the page is in a landscape
orientation, the fifth column is a kind of separator (mixing all cells of this
column to achieve that effect). When I try to copy the information from the
first three columns into the last three columns the paste fails and anything is
copied. If I have titles (merging the first row to put into the resultant cell a
title) copy again the first three columns, when I try to paste into the other
side of the table even when the shape is exactly the same (the mixed cells for
the title in the first row in the last two columns), anything is pasted, the
same if I try to copy only a single column, again I cannot paste the data. I
donĀ“t know why I cannot paste data into the same table and I must to copy cell
by cell and not massively.
Comment 1 georgeen 2006-03-07 14:51:39 UTC
Created attachment 34636 [details]
Tables to test this and other issues
Comment 2 michael.ruess 2006-03-08 14:40:07 UTC
MRU->FME: it is not possible to insert some copied stuff e.g. on the last page
of the table. 
Example: select some cells (e.g. A1.1.4 to A1.3.9 on first page left) and try to
paste in the empty cells on last page -> it does not do anything.
Also, it is not possible to select some cells on page 2 or lower. I think it is
related to the pasting problem.
Comment 3 frank.meies 2006-06-20 13:56:37 UTC
FME: Changed target to 2.x
Comment 4 georgeen 2007-01-05 14:10:48 UTC
The last activity was on 2006-06-20 05:56:37 and this feature is very important,
do you have some news about it?, do you know if the bug was located or if is
necessary to re-do something?, please send me some news about this issue because
is hard to convince others that OO is THE way, and has this kind of troubles.
Comment 5 frank.meies 2007-01-08 09:57:58 UTC
FME: Hmm, looks like the table structure is somewhat weired. By creating the
'separator' the table ends up having a giant repeating headline. This is due to
Writer's current table model. Merging a couple of cells vertically and defining
a repeated headline generally isn't a good idea. I'll give an example: Starting
with a table with seven columns and 20 rows, merging the cells of the forth
column gives you this table structure:

row
  cell
    20 inner rows with three cells each
  cell
  cell
    20 inner rows with three cells each

So the resulting table consist of only one outer row, which is the repeated
headline row. So I guess that most likely this is not what you wanted to achieve
when creating your separator, at least not when the table is larger than one
page. In the attached bugdoc, the repeated header covers almost the whole page.

Anyway, copying a cell selection into a part of a table, which has nested rows
does not work, in fact it never seemed to work (checked with OOo 1.0). 

Workaround is to first copy the cells, then create the 'separator' column.

Some more good news: We are currently implementing a new table model (using
rowspans instead of nested rows), see i4032. The problem is not existing with
this new model anymore. So I tend to change the target to 'OOo later'.
Comment 6 georgeen 2007-01-09 14:36:16 UTC
Thanx for the news, and yes, the table is somewhat weird, but was done for
someone with almost no experience with tables I had to help her dividing the
page on columns and one table as urgent workaround, but for the purpose of "bug
detection" was pretty well. About the new way to do tables, do you know if
"later" will be on 2.1.x or 2.x or 3.x?.
Comment 7 frank.meies 2007-01-09 18:09:06 UTC
FME: The new table model will make it into 2.x, most probably.
Comment 8 georgeen 2010-04-23 01:39:42 UTC
When I think that the problem finally was resolved, I discover that in Linux
when I merge some cells and after I insert a column it works, but when I try to
delete a column the merge is lost. If the merge is in rows, is the same with the
differenc that is very slow and after the merge is lost.