SQuirreL SQL Client / Bugs / #841 Export to excel results in strange rounding

#841 Export to excel results in strange rounding

Milestone: SQuirreL

Status: closed-duplicate

Owner: nobody

Labels: None

Priority: medium

Updated: 2021-09-05

Created: 2010-03-19

Creator: Anonymous

Private: No

Exporting the following query to Oracle 10g DB using SquirelSQL 3.0.3 and 3.1 :
select 16770001, 16775001, 16776501, 16777001, 16777201, 16777241, 16777251, 16777261, 16777271, 16777281, 16777291, 16777301, 16777401 from dual
result in a strange rounding of the values:
16770001 16775001 16776501 16777001 16777201 16777241 16777251 16777261 16777271 16777281 16777291 16777301 16777401
16770001 16775001 16776501 16777001 16777201 16777240 16777252 16777260 16777272 16777280 16777292 16777300 16777400
Strangely the header can be displayed properly.

Discussion

Kurt Huwig - 2010-03-26

This is a duplicate of 2973045 (which has a comment and this does not).

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- sfst - 2021-09-03
  
  Correct, and it (bug #843) was closed (and fixed) - so this one here can be closed too?
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gerd Wagner - 2021-09-05

status: open --> closed-duplicate

Group: --> SQuirreL

Priority: 5 --> medium
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gerd Wagner - 2021-09-05

Closed as requested.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Export to excel results in strange rounding

A Java SQL client for any JDBC compliant database

Group

Searches

Help

#841 Export to excel results in strange rounding

Discussion