Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: User interface

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Restore the working "Open in Excel" functionality for exporting numbers.

In version 10.12.1 and older the "Open in Excel" functionality actually created a Excel file where numbers were numbers and could be used in formulas like SUM. Starting in, I think, 10.12.4 you started exporting all numbers as a string. That completely breaks the usability, as you can then no longer make a formula using the numbers. (And while Excel offers the option to convert them back to numbers, it would be a pain to do it for each column that needed it and it takes FOREVER.)

At this point I will have to stay on 10.12.1 and not upgrade until this functionality is restored.

8 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Michael shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Michael commented  ·   ·  Report

    Just to be clear, don't just change it so "small" numbers are actually numbers and large numbers that would display as scientific notation are text. ALL numbers need to stay as numbers in Excel.

  • Michael commented  ·   ·  Report

    Yes, the solution for large numbers displaying as scientific notation is to change the number *formatting* option, which is easy and quick, not to convert the numbers to text. (Which using Excel's feature to convert them back to numbers takes a VERY LONG time for a large spreadsheet, not to mention the pain of going through and picking all the different columns that it would need to be done to.)

  • AlphonseG commented  ·   ·  Report

    Please revert back to the way it was. Making numbers text is totally illogical.
    Whomever decided on this needs a reality check.

  • Daniel Verhagen commented  ·   ·  Report

    Please restore the feature back to its original functionality. It's fine to improve the usability by using the decimal separator in the locale settings, but changing the field from a number field to a text file defeats the purpose of the feature.

  • Joe Sirgey commented  ·   ·  Report

    I cannot understand why they made this change, breaking normal numbers so big int doesnt show as scientific notation is a strange move, lets break all numbers so someone doesnt have to widen a column in excel.