Hi Carlos, hi Bernhard, thank's for your replys. You both were right, it was a problem in the settings of Excel. After changing the decimal-delimiter from "," into "." and the thousand-delimiter from "." into "'" it worked. Only thing is that I now have to get used to the international standard in daily working with excel. Should be feasible...
Julian ------------------------------------------------------- Message: 2 Date: Wed, 16 Jul 2014 16:59:11 +0200 From: Bernhard Str?bl <bernhard.stro...@jena.de> To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Problem with exporting attribute table to Excel Message-ID: <53c6933f.3040...@jena.de> Content-Type: text/plain; charset=windows-1252; format=flowed Hi, I guess it is a problem of decimal delimiter settings ("." versus ","). A German Windows machine normally is set to ",". Bernhard Am 16.07.2014 16:51, schrieb Julian Schall: > Hi, > > if I export a attribute table into Excel (select features?copy?open > Excel?paste) excel doesn?t identify decimal numbers (double/real) > greater or equal 1.0. For example a value of 1.5 in the column AREA in > QGIS will be 15 in excel. > > How can I solve that by still using the quick and easy ?copy-paste method?? > > Thanks for help! > > > Julian > > > ------------------------------ Message: 3 Date: Wed, 16 Jul 2014 10:05:53 -0500 From: Carlos Cerd?n <sig.up...@gmail.com> To: "qgis-user@lists.osgeo.org" <qgis-user@lists.osgeo.org> Subject: Re: [Qgis-user] Problem with exporting attribute table to Excel Message-ID: <CAFvg7Wjoz6H5ve4c6F-s=Y1hDKZW02=b6o+caxdmiys_z98...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hi Julian Perhaps your operative system or your Excel decimal separator is comma (Some times I have troubles with this). If doesn't, try opening the *.dbf file of your shape directly into Excel or LIbreOffice Calc (take care about changes that can affect shape linking). Good luck Carlos 2014-07-16 9:51 GMT-05:00 Julian Schall <j.sch...@ff-forst.de>: > Hi, > > > > if I export a attribute table into Excel (select features?copy?open > Excel?paste) excel doesn?t identify decimal numbers (double/real) greater or equal 1.0. > For example a value of 1.5 in the column AREA in QGIS will be 15 in excel. > > How can I solve that by still using the quick and easy ?copy-paste method?? > > Thanks for help! > > > Julian > > _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user