#519 Excel Export on number

2.5.1
open
Unknown (89)
5
2012-12-29
2007-05-16
No

1/ Run
select 49652602 from dual;

2/ Export to excel (2003 french version)
(check recommended option for excel)
result is :
Line1 (header): 49652602
Line2 (value) : 49652600

--> BUG, may be option should not be recommended ?

Il notice that error is not the same depending on number size, and odd/even examples :
18704837 --> 18704836
18704836 --> 18704836

3/ I found a workaround
Re-export to excel
(check default formating)
result is :
Line1 (header): 49652602
Line2 (value) : 49652602

Discussion

  • Nobody/Anonymous

    We ran into this during a data load. Thankfully the export that does the data load is generated through as a tab delimited file so we were ok. The report file we generated was straight to Excel and we saw this problem on a large scale with the file. Once we tracked this down, we did an export to tab and loaded that to excel properly. The workaround listed here does work. We were noticing this on numbers of greater than 5000000000. Squirrel Version 2.6.6.

     
  • Stepan RYBAR

    Stepan RYBAR - 2009-01-09

    We have faced the very same problem. Using SQuirreL 2.6.4 on MS Windows 2000 and Java 1.6.0_10-b33. When we use default formatting, there is no problem, when we use formatting in Global Prefs (default format with dot - the lower one), there are errors. Stepan Rybar Here is an example with differences:

    CSV GlobalPrefs;XLS Global Prefs;CSV default formatting;XLS default formatting
    55257215;55257216;55257215;55257215
    55257704;55257704;55257704;55257704
    55259885;55259884;55259885;55259885
    55431631;55431632;55431631;55431631
    55431677;55431676;55431677;55431677
    55586524;55586524;55586524;55586524
    55724046;55724048;55724046;55724046
    55495124;55495124;55495124;55495124
    55495797;55495796;55495797;55495797
    55495829;55495828;55495829;55495829
    55496344;55496344;55496344;55496344
    55496425;55496424;55496425;55496425
    55496524;55496524;55496524;55496524
    55496710;55496712;55496710;55496710
    55496880;55496880;55496880;55496880
    55373804;55373804;55373804;55373804
    55374976;55374976;55374976;55374976
    55375807;55375808;55375807;55375807
    55376257;55376256;55376257;55376257
    55376942;55376944;55376942;55376942
    55376960;55376960;55376960;55376960
    55530691;55530692;55530691;55530691
    55530961;55530960;55530961;55530961
    55724416;55724416;55724416;55724416
    55724516;55724516;55724516;55724516
    55531394;55531392;55531394;55531394
    55531480;55531480;55531480;55531480
    55531597;55531596;55531597;55531597
    55531966;55531968;55531966;55531966

     
  • Nobody/Anonymous

    I believe I've also bumped into this.

    I have a 2 digit numeric values (dollars) in the query results. Despite playing with the configuration for Numeric values every way I can figure, if the export is numeric, the value is rounded to the next whole number. If the "default formatting" is used, the number is exported exactly as displayed with 0, 1, or 2 digits of accuracy - as text. I then have to select those fields and explicitly convert them to number in order to force a 2 digit format within Excel. Using CSV is not an option due to other fields which contain text that is corrupted by Excel's conversion process. [according to another co-worker]

    Squirrel version 2.6.8

     
  • Nobody/Anonymous

    We have the same problem with current config:
    Windows XP, SP3, Java jre1.6.0_07, Squirrel 3.0.1 !!

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks