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.
Gabriel Flores commented
see thread here for more details
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.
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.)
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
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
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.