[Qgis-user] Problem with exporting attribute table to Excel

[Julian Schall]

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.stroebl at jena.de>
To: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] Problem with exporting attribute table to
	Excel
Message-ID: <53C6933F.3040801 at 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.upagu at gmail.com>
To: "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org>
Subject: Re: [Qgis-user] Problem with exporting attribute table to
	Excel
Message-ID:
	<CAFvg7Wjoz6H5ve4c6F-s=Y1hDKZW02=b6o+CAXDMiys_Z98YWg at 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.schall at 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
>
>