Devart Forums

Posted: **Fri 29 Aug 2014 16:56**

Hi all

I exported data to a Excel worksheet, when i open the file, i detected numeric columns were converted to TEXT columns....

The columns changed are float type.

Is there any way to export correctly.?

Thanks in advance

Posted: **Mon 01 Sep 2014 08:19**

Could you please provide us the CREATE definition of the table and the exported XLS file? You can include just a few test records so we can reproduce the issue on our side.

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

Posted: **Mon 01 Sep 2014 22:57**

Hello

Here are the files

check the columns "NUMCRED" and "CANTENTRE", they should be numeric types.

Code: Select all

CREATE TABLE PLD.TMP_CREDEXCED (
  FDESDE      DATE,
  FHASTA      DATE,
  FUENTEBD    VARCHAR2(10 BYTE),
  CDGRG       VARCHAR2(3 BYTE),
  CLNS        VARCHAR2(1 BYTE),
  CDGCLNS     VARCHAR2(6 BYTE),
  CICLO       VARCHAR2(2 BYTE),
  CDGCL       VARCHAR2(6 BYTE),
  NUMCRED     NUMBER(5, 0),
  CANTENTRE   NUMBER(15, 4),
  INICICLO    DATE,
  USUARIO     VARCHAR2(10 BYTE),
  FREGISTRO   DATE,
  TIPOACTO    VARCHAR2(10 BYTE),
  FULTREPORTE DATE
)

The exported excel file is this:
https://www.dropbox.com/s/4k50xip4u98rb ... D.xls?dl=0

hope it can be resolved

Thanks in advance...

Posted: **Wed 03 Sep 2014 10:26**

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

Posted: **Sat 06 Sep 2014 07:15**

I exported data to a Excel worksheet, when i open the file, i detected numeric columns were converted to TEXT columns....

_________
Unlock the key of your success by redhat dumps.By using our latest passguide and Iona College study material, you can easily HITACHI selftestengine Youtube

Posted: **Fri 30 Jan 2015 14:30**

We would like to let you know that we have released a new version 3.7 of dbForge Studio for Oracle where the issue you reported is fixed http://www.devart.com/dbforge/oracle/st ... nload.html

Thank you for your help in improving dbForge Studio for Oracle.

Devart Forums

Export to excel changed NUMBER to TEXT

Export to excel changed NUMBER to TEXT

Re: Export to excel changed NUMBER to TEXT

Re: Export to excel changed NUMBER to TEXT

Re: Export to excel changed NUMBER to TEXT

Re: Export to excel changed NUMBER to TEXT

Re: Export to excel changed NUMBER to TEXT