Improve ability to copy paste Excel tables

Options
Vladimir Cech
Vladimir Cech Member Posts: 183
in
Hi,
Following
https://support.jamasoftware.com/hc/en-us/requests/28781
https://support.jamasoftware.com/hc/en-us/requests/28779
https://support.jamasoftware.com/hc/en-us/requests/37381
Please consider to improve how it is possible to copy tables from Excel and in fact how it is possible to copy any OLE objects from Word, Excel,... to RTF field. This a long time issue (originally reported with 2015 version and still persists in 8.15) and users are complaining that a lot of manual work is required to fix poor copy&paste. One example as a representative:
https://p4.zdusercontent.com/attachment/14735/bgUNoTnOe9aozMQksmbDMj4pq?token=eyJhbGciOiJkaXIiLCJlbmMiOiJBMTI4Q0JDLUhTMjU2In0..205uy244wHlRXOl31MU2mw.VocbCzd_dpcvc_ptmKGuHzVQHWiyFbiWZQXBwTvg9KP81YUaocQzkk9io_wy9TvAGyhasOFJv5DO5ckGtUjRw0aTaoOfyJC2TgL4tUFtYLPos2fgjegrNW-x2LScBjhLKbFQMctllGqaT9qp-_DIxXcfQ5ua9uWdJlgssrPV5VjA3R4XCv3pcuPkgRtpEy6Q9uxBAMYxgANb2WpLubLfO3_5DDISTKWPUE5tw_AAl10syhg0vQcuNWsj_F_88tNesFhQ-ERURCRuGnOrzuErKu01PK9BVlqwDv8BDZ5sphY.89cvq_yv-pznXNqyewfEewThank you
Vlada

Comments

  • [Deleted User]
    [Deleted User] Posts: 19
    Options
    I often have users complain of the copy/paste from Word, Excel, etc. to Jama RTE field.  I try to discourage it and suggest they author directly in the tool...but still people seem to like to first author in Word to get their thoughts & formatting together then paste into Jama.  The formatting doesn't always translate perfectly.
  • LawrenceR Rigge
    LawrenceR Rigge Member Posts: 13
    Options
    I agree this is long overdue for improvement.  FWIW - we find that you get better results if you copy-paste a table from Excel into Word and then copy-paste from Word to Jama.  Colors, cell alignment, borders, etc. more closely match the original Excel if you take the table into Word first.
  • Joel Hutchinson
    Joel Hutchinson Jama Staff, Data Exchange, Medical Devices & Life Sciences Solution, Jama Connect Interchange™ (JCI), Jama Validation Kit (JVK) + Functional Safety Kit (FSK) Posts: 10
    Options
    Thanks for the feedback Vlada, I appreciate it. We've been working with our rich text editor vendor for a while on bringing this functionality into Jama, but haven't been able to due to some technical limitations of the editor. Those limitations have since been resolved, and we are now planning on bringing better cut and paste from Excel into Jama by 8.20, which is our next standard release. I was demoing the newest version of the editor from the vendor last week, and believe this upgrade should resolve the issue you're experiencing.
    Joel Hutchinson

    Jama Software
  • Vladimir Cech
    Vladimir Cech Member Posts: 183
    Options
    Thank you Joel,
    Good to hear the improvement in coming :)
    Vlada
  • [Deleted User]
    [Deleted User] Posts: 1
    edited July 2018
    Options
    Hello, 

    I am currently trying to copy and paste an excel document into Jama but not all the borders make the transition. Is there some way to fix this? It doesn't make sense that some borders make it while others do not. I have tried putting it into Word first but it is a more complex table and still did not have all of the borders in the end.
  • [Deleted User]
    [Deleted User] Posts: 46
    edited July 2018
    Options
    The table function within JAMA does not allow users to insert rows, and if I try to add a row at the bottom, copy everything from where I want the row inserted and paste it back in, the table doesn't stay in the same formatting. And, if I copy the table to Word, insert my row, copy and try to paste back in, I lose some of the borders.

Categories