Export to excel changed NUMBER to TEXT

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
sis01
Posts: 9
Joined: Thu 07 Mar 2013 16:43

Export to excel changed NUMBER to TEXT

Post by sis01 » 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

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: Export to excel changed NUMBER to TEXT

Post by alexa » 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.

sis01
Posts: 9
Joined: Thu 07 Mar 2013 16:43

Re: Export to excel changed NUMBER to TEXT

Post by sis01 » 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...

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: Export to excel changed NUMBER to TEXT

Post by alexa » 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.

syed20
Posts: 1
Joined: Sat 06 Sep 2014 07:13

Re: Export to excel changed NUMBER to TEXT

Post by syed20 » 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

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: Export to excel changed NUMBER to TEXT

Post by alexa » 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.

Post Reply