[Qgis-user] Problems occur when copying large amounts to Excel

[Nicolas Cadieux]

Hi, 
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).  
With that, you should be able to find the problem character that is causing excel start skipping columns. 
You can then do a find and replace in notepad++ using the extended search mode. 
Nicolas Cadieux M.Sc. 
Les Entreprises Archéotec inc.  
8548, rue Saint-Denis Montréal H2P 2H2 
Téléphone: 514.381.5112  Fax: 514.381.4995 
www.archeotec.ca 
On Nov 30, 2015 10:49, "Yann Raes [via OSGeo.org]" <ml-node+s1560n5239181h72 at n6.nabble.com> wrote: 

	







Hi 
Thanks for the answer. 
I tried both options U suggested but none of them works. 

Another option? 
  
Grtz 
Yann 
  

  

  


Van:
 Qgis-user [mailto: [hidden email] ] Namens Richard McDonnell 
Verzonden: maandag 30 november 2015 12:51 
Aan: [hidden email] 
Onderwerp: Re: [Qgis-user] Problems occur when copying large amounts to Excel 


  
Yann, 
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. 
Regards, 

Richard 

On 30/11/2015 10:39, Yann Raes wrote: 

<blockquote style="border-left:2px solid #cccccc;padding:0 1em" style="margin-top:5pt;margin-bottom:5pt">
Hello 
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… 
Anyone a solution for this bug? 
Thanx. 
Yann 
  




_______________________________________________ 
Qgis-user mailing list 
[hidden email] 
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user 
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user 






OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart 
OPW - Looking to the future - Caring for the past 

Email Disclaimer: http://www.opw.ie/en/disclaimer/ 





_______________________________________________
Qgis-user mailing list
[hidden email] 
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user 

	
	
	
	
	
	
	
		If you reply to this email, your message will be added to the discussion below: 
		http://osgeo-org.1560.x6.nabble.com/Problems-occur-when-copying-large-amounts-to-Excel-tp5239117p5239181.html 
	
	
		To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.com 
		To unsubscribe from Quantum GIS - User, click here . 
		NAML 
	



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Problems-occur-when-copying-large-amounts-to-Excel-tp5239117p5239189.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151130/fdfcfa72/attachment.html>