<p dir="ltr">Hi,</p>
<p dir="ltr">To trouble shoot this problem save your layer to a CSV file. Then, open the CSV with something like notepad++ and go see the lines where the problem begins in your excel file. Make sure you activate in notepad++ the option to see all characters. (View,show symbols,show all characters). </p>
<p dir="ltr">With that, you should be able to find the problem character that is causing excel start skipping columns.</p>
<p dir="ltr">You can then do a find and replace in notepad++ using the extended search mode.<br><br></p>
<p dir="ltr">Nicolas Cadieux M.Sc.<br>
Les Entreprises Archéotec inc. <br>
8548, rue Saint-Denis Montréal H2P 2H2<br>
Téléphone: 514.381.5112 Fax: 514.381.4995<br>
www.archeotec.ca</p>
<div class="gmail_quote">On Nov 30, 2015 10:49, "Yann Raes [via OSGeo.org]" <<a href="/user/SendEmail.jtp?type=node&node=5239189&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:<br type='attribution'><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<p><span style="color:#1f497d">Hi</span></p>
<p><span style="color:#1f497d">Thanks for the answer.</span></p>
<p><span style="color:#1f497d">I tried both options U suggested but none of them works.
</span></p>
<p><span style="color:#1f497d">Another option?</span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d">Grtz</span></p>
<p><span style="color:#1f497d">Yann</span></p>
<p><span style="color:#1f497d"> </span></p>
<div>
<p><span style="color:#1f497d"> </span></p>
</div>
<p><span style="color:#1f497d"> </span></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1pt;padding:3pt 0cm 0cm 0cm">
<p><b><span style="font-size:10pt;font-family:'tahoma' ,">Van:</span></b><span style="font-size:10pt;font-family:'tahoma' ,">
Qgis-user [mailto:<a href="/user/SendEmail.jtp?type=node&node=5239181&i=0">[hidden email]</a>] <b>Namens </b>Richard McDonnell<br />
<b>Verzonden:</b> maandag 30 november 2015 12:51<br />
<b>Aan:</b> <a href="/user/SendEmail.jtp?type=node&node=5239181&i=1">[hidden email]</a><br />
<b>Onderwerp:</b> Re: [Qgis-user] Problems occur when copying large amounts to Excel</span></p>
</div>
</div>
<p> </p>
<p style="margin-bottom:12pt">Yann,<br />
You can use the MMGGIS Plugin to export attributes to CSV, or, right click and select 'save as' (ticking the 'Save only selected features') selecting CSV as the output, it might be easier than using copy and paste, and may be more reliable.<br />
Regards,<br />
<br />
Richard</p>
<div>
<p>On 30/11/2015 10:39, Yann Raes wrote:</p>
</div>
<p>Hello</p>
<p>When I copy my attributes (+6000 attributes) to Excel I get several lines that are not copied correct. The lines split in half and makes a new line; so one line turns into two split
lines…</p>
<p>Anyone a solution for this bug?</p>
<p>Thanx.</p>
<p>Yann</p>
<p> </p>
<p><span style="font-size:12pt;font-family:'times new roman' , 'serif'"><br />
<br />
<br />
</span></p>
<pre>_______________________________________________</pre>
<pre>Qgis-user mailing list</pre>
<pre><a href="/user/SendEmail.jtp?type=node&node=5239181&i=2">[hidden email]</a></pre>
<pre>List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
<pre>Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<p><span style="font-size:12pt;font-family:'times new roman' , 'serif'"><br />
<br />
<br />
</span></p>
<div>
<p><span style="font-size:8pt;font-family:'arial' ,">OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart<br />
OPW - Looking to the future - Caring for the past<br />
<a href="http://www.opw.ie/" target="_top" rel="nofollow" link="external"><span style="text-decoration:none"><img border="0" width="494" height="76" src="http://www.opw.ie/en/media/opw-email-banner.png" /></span></a><br />
Email Disclaimer: <a href="http://www.opw.ie/en/disclaimer/" target="_top" rel="nofollow" link="external">http://www.opw.ie/en/disclaimer/</a>
</span></p>
</div>
</div>
<br />_______________________________________________
<br />Qgis-user mailing list
<br /><a href="/user/SendEmail.jtp?type=node&node=5239181&i=3">[hidden email]</a>
<br />List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br />
<br />
<hr noshade="noshade" size="1" />
<div style="color:#444;font:12px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/Problems-occur-when-copying-large-amounts-to-Excel-tp5239117p5239181.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/Problems-occur-when-copying-large-amounts-to-Excel-tp5239117p5239181.html</a>
</div>
<div style="color:#666;font:11px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif;margin-top:0.4em;line-height:1.5em">
To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.com <br />
To unsubscribe from Quantum GIS - User, <a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click here</a>.<br />
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML</a>
</div></blockquote></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Problems-occur-when-copying-large-amounts-to-Excel-tp5239117p5239189.html">Re: Problems occur when copying large amounts to Excel</a><br/>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html">Quantum GIS - User mailing list archive</a> at Nabble.com.<br/>