facebook

Pasting data to Excel when data contains line breaks

  1. MyEclipse IDE
  2.  > 
  3. General Development
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #353374 Reply

    b.hamblet
    Participant

    First off, here’s my system setup:
    *** Date:
    Monday, January 12, 2015 3:17:47 PM CST

    *** System properties:
    OS=Windows7
    OS version=6.1.0
    OS arch=x86
    Profile arch=x86
    Window system=win32
    Java version=1.7.0_45
    Workspace=file:/C:/Users/bh4864/Workspaces/MyEclipse Professional 2014/
    VM Args=-Xmx768m
    -XX:MaxPermSize=320m
    -XX:ReservedCodeCacheSize=64m
    -Dosgi.nls.warnings=ignore
    -Djava.class.path=C:\Users\bh4864\AppData\Local\MYECLI~1\plugins/OR8508~1.JAR

    *** Subscription information
    Product Id: E3MP (MyEclipse Professional Subscription)
    License version: 3.0
    Full Maintenance Included
    Subscription expiration date (YYYYMMDD): 20150723
    Number of users: 36

    *** Eclipse details:
    MyEclipse Enterprise Workbench

    Version: 2014
    Build id: 12.0.0-20131202

    Blueprint: N/A

    com.genuitec.eclipse.mobile.feature – 12.0.0.201311260528
    com.genuitec.myeclipse.database – 12.0.0.me201311281640
    com.genuitec.myeclipse.desktop – 12.0.0.me201311281640
    com.genuitec.myeclipse.enterprise.workbench – 12.0.0.me201311281640
    com.genuitec.myeclipse.geronimo – 12.0.0.me201311281640
    com.genuitec.myeclipse.glassfish – 12.0.0.me201311281640
    com.genuitec.myeclipse.icefaces.feature – 12.0.0.me201311281640
    com.genuitec.myeclipse.imageeditor – 12.0.0.me201311281640
    com.genuitec.myeclipse.jboss – 12.0.0.me201311281640
    com.genuitec.myeclipse.jetty – 12.0.0.me201311281640
    com.genuitec.myeclipse.jonas – 12.0.0.me201311281640
    com.genuitec.myeclipse.jrun – 12.0.0.me201311281640
    com.genuitec.myeclipse.jsf – 12.0.0.me201311281640
    com.genuitec.myeclipse.maven – 12.0.0.me201311281640
    com.genuitec.myeclipse.oracle – 12.0.0.me201311281640
    com.genuitec.myeclipse.orion – 12.0.0.me201311281640
    com.genuitec.myeclipse.persistence – 12.0.0.me201311281640
    com.genuitec.myeclipse.reports – 12.0.0.me201311281640
    com.genuitec.myeclipse.resin – 12.0.0.me201311281640
    com.genuitec.myeclipse.struts – 12.0.0.me201311281640
    com.genuitec.myeclipse.sun – 12.0.0.me201311281640
    com.genuitec.myeclipse.tomcat – 12.0.0.me201311281640
    com.genuitec.myeclipse.uml2 – 12.0.0.me201311281640
    com.genuitec.myeclipse.visualvm – 12.0.0.me201311281640
    com.genuitec.myeclipse.visualvm.server – 12.0.0.me201311281640
    com.genuitec.myeclipse.weblogic – 12.0.0.me201311281640
    com.genuitec.myeclipse.websphere – 12.0.0.me201311281640
    com.genuitec.myeclipse.ws – 12.0.0.me201311281640
    org.eclipse.birt – 4.3.1.me201311281640
    org.eclipse.datatools.connectivity.feature – 1.11.1.me201311281640
    org.eclipse.datatools.enablement.feature – 1.11.1.me201311281640
    org.eclipse.datatools.modelbase.feature – 1.11.1.v201306041610-7707GCcNBHLDaKTEcRi
    org.eclipse.datatools.sqldevtools.feature – 1.11.1.me201311281640
    org.eclipse.emf – 2.9.1.v20130902-0605
    org.eclipse.gef – 3.9.1.201308190730
    org.eclipse.graphiti.feature – 0.10.1.v20130918-0838
    org.eclipse.jpt.jpa.feature – 3.3.1.me201311281640
    org.eclipse.jpt.jpadiagrameditor.feature – 1.2.0.me201311281640
    org.eclipse.jst.common.fproj.enablement.jdt – 3.4.0.me201311281640
    org.eclipse.jst.enterprise_ui.feature – 3.5.0.me201311281640
    org.eclipse.jst.server_adapters.ext.feature – 3.3.103.me201311281640
    org.eclipse.jst.server_adapters.feature – 3.2.201.me201311281640
    org.eclipse.jst.server_ui.feature – 3.4.1.me201311281640
    org.eclipse.jst.ws.axis2tools.feature – 1.1.200.me201311281640
    org.eclipse.m2e.feature – 1.4.0.me201311281640
    org.eclipse.sapphire.platform – 0.6.6.201310081535
    org.eclipse.wst.common.fproj – 3.4.0.me201311281640
    org.eclipse.wst.server_adapters.feature – 3.2.300.me201311281640
    org.eclipse.xsd – 2.9.1.v20130902-0605
    org.springframework.ide.eclipse.feature – 3.3.0.me201311281640

    fr.obeo.acceleo.bridge.feature – 2.6.0.me201311281640
    org.eclipse.cvs – 1.4.0.v20130911-1000
    org.eclipse.draw2d – 3.9.1.201308190730
    org.eclipse.e4.rcp – 1.2.1.v20130910-2014
    org.eclipse.egit – 3.1.0.201310021548-r
    org.eclipse.epp.mpc – 1.2.1.I20130917-2019
    org.eclipse.equinox.p2.core.feature – 1.2.1.v20130827-1605
    org.eclipse.equinox.p2.discovery.feature – 1.0.100.v20130502-0334
    org.eclipse.equinox.p2.extras.feature – 1.2.0.v20130827-1605
    org.eclipse.equinox.p2.rcp.feature – 1.2.0.v20130828-0031
    org.eclipse.equinox.p2.user.ui – 2.2.0.v20130828-0031
    org.eclipse.help – 2.0.1.v20130911-1000
    org.eclipse.jdt – 3.9.1.v20130911-1000
    org.eclipse.jgit – 3.1.0.201310021548-r
    org.eclipse.jsf.feature – 3.7.0.me201311281640
    org.eclipse.mylyn.bugzilla_feature – 3.9.1.v20130917-0100
    org.eclipse.mylyn.commons – 3.9.1.v20130917-0100
    org.eclipse.mylyn.commons.identity – 1.1.1.v20130917-0100
    org.eclipse.mylyn.commons.notifications – 1.1.1.v20130917-0100
    org.eclipse.mylyn.commons.repositories – 1.1.1.v20130917-0100
    org.eclipse.mylyn.context_feature – 3.9.1.v20130917-0100
    org.eclipse.mylyn.cvs – 1.1.1.v20130917-0100
    org.eclipse.mylyn.discovery – 3.9.1.v20130917-0100
    org.eclipse.mylyn.git – 1.1.1.v20130917-0100
    org.eclipse.mylyn.ide_feature – 3.9.1.v20130917-0100
    org.eclipse.mylyn.java_feature – 3.9.1.v20130917-0100
    org.eclipse.mylyn.monitor – 3.9.1.v20130917-0100
    org.eclipse.mylyn.tasks.ide – 3.9.1.v20130917-0100
    org.eclipse.mylyn.team_feature – 3.9.1.v20130917-0100
    org.eclipse.mylyn.versions – 1.1.1.v20130917-0100
    org.eclipse.mylyn_feature – 3.9.1.v20130917-0100
    org.eclipse.ocl – 3.1.0.v20110606-1427
    org.eclipse.pde – 3.9.1.v20130911-1000
    org.eclipse.platform – 4.3.1.v20130911-1000
    org.eclipse.rcp – 4.3.1.v20130911-1000
    org.eclipse.wb.core.feature – 1.6.1.r43x201309092314
    org.eclipse.wb.core.java.feature – 1.6.1.r43x201309092318
    org.eclipse.wb.core.ui.feature – 1.6.1.r43x201309092325
    org.eclipse.wb.core.xml.feature – 1.6.1.r43x201309092330
    org.eclipse.wb.doc.user.feature – 1.6.1.r43x201309092334
    org.eclipse.wb.layout.group.feature – 1.6.1.r43x201309092345
    org.eclipse.wb.rcp.SWT_AWT_support – 1.6.1.r43x201309100026
    org.eclipse.wb.rcp.doc.user.feature – 1.6.1.r43x201309100019
    org.eclipse.wb.rcp.feature – 1.6.1.r43x201309100008
    org.eclipse.wb.swing.doc.user.feature – 1.6.1.r43x201309100012
    org.eclipse.wb.swing.feature – 1.6.1.r43x201309100023
    org.eclipse.wb.swt.feature – 1.6.1.r43x201309092350
    org.eclipse.wb.xwt.feature – 1.6.1.r43x201309100031
    org.sonatype.m2e.mavenarchiver.feature – 0.15.0.201207090125-signed-20130612210623

    Eclipse startup command=-os
    win32
    -ws
    win32
    -arch
    x86
    -showsplash
    -launcher
    C:\Users\bh4864\AppData\Local\MyEclipse\myeclipse.exe
    -name
    Myeclipse
    –launcher.library
    C:\Users\bh4864\AppData\Local\MyEclipse\plugins/org.eclipse.equinox.launcher.i18n.win32.win32.x86_3.2.0.v201103301700\eclipse_3215.dll
    -startup
    C:\Users\bh4864\AppData\Local\MyEclipse\plugins/org.eclipse.equinox.launcher_1.3.0.v20130327-1440.jar
    -configuration
    C:\Users\bh4864\AppData\Local\MyEclipse\configuration
    -install
    C:\Users\bh4864\AppData\Local\MyEclipse
    -vm
    C:\Users\bh4864\AppData\Local\MyEclipse\binary\com.sun.java.jdk7.win32.x86_1.7.0.u45\jre\bin\client\jvm.dll

    I’m having an issue with copying query results to the clipboard and then pasting them to Excel. If any of the data contains a line break, it causes the record in Excel to be broken up into multiple rows, and tabs in the data cause data in the row in Excel to be shifted to the right by several cells. I found something that seems to be a solution for a different version of MyEclipse, but it isn’t applicable to my version. Here’s that solution to help explain the issue I’m facing: https://bugs.eclipse.org/bugs/show_bug.cgi?id=374643#c4

    Is there a new fix for my version of MyEclipse?

    #353382 Reply

    support-swapna
    Moderator

    Hi,

    Sorry that you are seeing this issue.

    Can you please let us know which DB you are working with along with the sample data to help us replicate the issue at our end? If possible please also send us the screenshot of the issue to help us get a visual.

    #353383 Reply

    b.hamblet
    Participant

    @support-swapna wrote:

    Hi,

    Sorry that you are seeing this issue.

    Can you please let us know which DB you are working with along with the sample data to help us replicate the issue at our end? If possible please also send us the screenshot of the issue to help us get a visual.

    I’m connecting to a DB that is internal to my organization. No one outside of my organization is going to be able to connect to it. Replicating it should be very easy though, as it’s extremely consistent for everyone in my org that uses MyEclipse. I’m querying a table that contains several text fields. In one of those fields, the data typically contains several line breaks because it’s used to list several tasks within a project. It also contains several tabs. I’ve included a sample of the output when I copy the results to Excel. Column P – “TASK_LIST” is this problem field. You’ll see that rows 3 – 34 should all be part of the TASK_LIST field, but instead are copied to their own rows. Additionally, the tabs cause each row within this field to be spread across 2 columns. I’ve also included a screenshot of this field as it appears in our database. You can see where the tabs and line breaks have been inserted into the field contents.

    Attachments:
    You must be logged in to view attached files.
    #353384 Reply

    b.hamblet
    Participant

    @support-swapna wrote:

    Can you please let us know which DB you are working with

    Unless you mean which driver template? It’s Oracle (Thin Driver) if that helps.

    #353389 Reply

    support-swapna
    Moderator

    Hi,

    Thank you for the details. I could replicate the issue at my end.
    I will check with the team about the fix and get back to you soon.

    Thanks for your patience.

    #353397 Reply

    support-swapna
    Moderator

    Hi,

    I am afraid this does not look like a MyEclipse issue. You can check by pasting the data to a text file and see if its as expected.

    If you still think its a MyEclipse issue, please let us know why you think so.

Viewing 6 posts - 1 through 6 (of 6 total)
Reply To: Pasting data to Excel when data contains line breaks

You must be logged in to post in the forum log in