It's all about the answers!

Ask a question

Copy and paste a table from a Word document to an RRC artifact.


Jean-claude Valla (623) | asked Jan 07 '14, 5:06 a.m.
Hello,

I met a problem when I tried to copy and paste a table and its contents from a MS Word document into a RRC artifact. In fact, some rows and lines are disabled / disappearing when I paste my table which becames truncated, there are some strange hypertext links instead.

My questions are : what is the source of this problem and what should I do in order to solve it ?

Thanks for your help.

@en

--------------------------------------------------------------------------------------------------------------------------------------------

Bonjour,

J'ai rencontré un problème lorsque j'ai tenté de copier / coller un tableau et son contenu, le tout provenant d'un document Word, vers un artefact RRC. Au lieu d'avoir mon tableau, j'obtiens un tableau tronqué dans lequel, certaines lignes et colonnes disparaissent. A la place, j'ai d'étranges petits liens hypertexte.

Mes questions sont : d'où vient ce problème et comment y remédier ?

En vous remerciant.

@fr

Comments
My-An Nguyen commented Jan 07 '14, 12:57 p.m.

What version of RRC are you using?
Are you seeing the truncated table inside the artifact or only when printing the artifact?
When transferring (whether by copy/pasting or importing) a table from Word to RRC, the formatting needs to be converted to HTML, which is not always a trivial task given the many possibilities that Word allows.
Did you try importing instead?
It would also help to know how complex your table looks.




Quelle version de RRC utilisez-vous?
Voyez-vous le tableau tronque immediatement dans l'artefact ou seulement quand vous l'imprimez?
Lorsqu'on transfere un tableau de Word a RRC (que ce soit par copier/coller ou import), on doit traduire le formattage en HTML et ce n'est pas toujours une action simple vu que Word nous permet mille et une possibilites.
Avez-vous essaye d'importer le document au lieu?
Aussi, cela nous serait utile d'avoir une idee de quoi a l'air votre table.

6 answers



permanent link
Jean-claude Valla (623) | answered Jan 08 '14, 4:38 a.m.
Hi, My-An Nguyen,

At first, thanks for your answer. We're using RRC version 3.0. The table is truncated when I paste it in the artefact, I never print any artefact. I completely understand how important difficulties can be about translating Word into valid HTML contents, but you'll admit that such misshaping is unacceptable regarding a professionnal work, isn't it ?
I admit, I didn't try to import the document. But I would prefer work only with artifacts.
I can't tell about the table contents, it's confidential, I can only tell you it's a Word table, so, with Word style arrangements with four columns and a variable number of rows. Nothing special...

Thanks again.

@en

------------------------------------------------------------------------------------------------------------------------------------------
Bonjour, My-An Nguyen,

D'abord, merci de votre réponse, pour vous donner quelques précisions supplémentaires, nous utilisons la version 3.0 de RRC. Le tableau apparaît tronqué lorsque je le copie depuis Word dans un artefact, je n'imprime jamais d'artefacts. Je comprends tout à fait qu'il puisse y avoir de grosses difficultés à transformer du contenu Word en un contenu HTML valide, mais, dans le cadre d'un travail professionnel, de telles déformations des contenus ne sont pas acceptables, n'est-ce pas ?
Je l'admets, je n'ai pas essayé d'importer le document, mais c'est parce je préfère ne travailler qu'avec les artefacts.
Je ne peux rien vous dire en ce qui concerne le contenu des tableaux puisqu'ils sont évidemment confidentiels. Pour le reste, il s'agit simplement de tableaux Word avec les arrangement de style qui y sont propres ; quatre colonnes et un nombre de lignes variable. Rien de spécial...

Merci encore.

@fr

Comments
Donald Nong commented Jan 09 '14, 6:33 p.m.

Tables in a Word document can be very special even they look simple to the naked eyes. There can be very strange tagging as well. If you paste the table into a plain text editor, will you get the HTML source? If so, examine the HTML source and see what may go wrong.


permanent link
Jean-claude Valla (623) | answered Jan 13 '14, 4:39 a.m.
Hello,

Thanks for your answer. If I understand correctly what you said, I could modify appearence and contents of my table, only by modifying HTML source code ? But in order to modify that, does RRC provides any HTML source code editor ? If not, i'll be able to see the code, not to modify it. For sure, i could copy and paste in a Notepad the source code, but not to update it the software.

What would be your advice about that ?

@eng

___________________________________________________________________________________________

Bonjour,

Merci pour votre réponse. Si je comprends bien ce que vous m'avez dit, je pourrais modifier l'apparence et les contenus de mon tableau simplement en modfifant du code HTML ? Mais, pour le modifier, RRC fournit-il un éditeur de code ? Sinon, je pourrai voir le code, éventuellement, le copier / coller dans un bloc-notes, mais pas le modifier. De plus, même si je modifie du code, je ne peux pas le mettre à jour dans le logiciel ?

Votre avis sur ce sujet ?

@fre

permanent link
Marcus Apel (40146) | answered Jan 13 '14, 7:04 a.m.
edited Jan 13 '14, 7:13 a.m.

Hi Jean-Claude,

i have a similar problem. I want to copy Excel tables to RRC text artifacts. If i do this in Firefox with STRG-V the RRC response with an error (f.e. "...cvc-complex-type.3.2.2: Das Attribut 'height' darf nicht in Element 'td' verwendet werden.... / atfer the "height" attribut can't use an "td" element). Therefor i aspect, that the RRC Rich text editor is very strict in handling the HTML-code behind the copied Excel-tables.

I use a workaround to copy Excel tables. First i copy the tables in a rich text editor of an other Web-Software. After that i copy the tables from this software into the RRC rich text editor.

We have a Atlassian Confluence Wiki. The Atlassian rich text editor can interprete the Excel-Copy&Paste-Code and can write Copy&Paste-Code that the RRC editor can interprete. Not very elegant, but it works.


permanent link
Jean-claude Valla (623) | answered Jan 13 '14, 11:53 a.m.
Hello everyone,

I tried something which is quite long but works I think : you copy and paste your table from Word to an Excel, redimension it, wrap text but unmerge the merged cells... moreover, if the headers are white, think to change the color for black. Then, copy & paste to RRC... that makes an acceptable rendering... I don't know why...

Thanks for everything... if someone has a better answer...


@eng
----------------------------------------------------------------------------------------------------------------------------------------

Bonjour à tous,

J'ai essayé quelque chose qui semble marcher, bien que ce soit un peu long. Vous copiez / collez votre tableau de Word vers Excel, vous redimentionnez, vous mettez le renvoi à la ligne mais vous clivez les cellules fusionnées. En outre, si vos en-têtes de colonnes sont blancs, pensez à les passer en noir. Puis, copiez / collez dans RRC, ça donne un rendu acceptable... j'ignore pourquoi...

Merci à tous et si quelqu'un a une meilleure solution...



permanent link
My-An Nguyen (2963) | answered Jan 13 '14, 1:49 p.m.
Merged cells have been a challenge in earlier versions. From your latest update, it seems like that may be a major factor that prevents a successful copy/paste. There have been many improvements to the handling of table formatting (including merged cells), most of which are in effect in versions 4.x (our latest available version is 4.0.5). You should consider upgrading at some point in the future.

Without knowing what your table looks like, it can be hard to elaborate on why your workaround works (I understand your concerns for confidentiality. We do not really need to know the contents of the table. You could replace all text with "abc" if you wish to share the table layout)

permanent link
fabio brito (11) | answered Jan 08 '16, 7:32 a.m.
People, i yet work with RRC 3.0.1 and many time I have problems with copy and paste. I found this workaround. It is so usefull. Probably it is to be resolve your problems.

https://jazz.net/forum/questions/99572/saving-the-artifact-after-adding-more-columns-into-a-table-in-the-artifact-gives-an-error

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.