Export to Excel (Data Only) does not work when the results include negative numbers. The file throws an error and is unable to be opened.
Exporting the same results to CSV will export the data and the even though the file opens, the negative number unexpectedly contains an apostrophe, e.g. '-25.
Steps to Reproduce:
1. For simplicity, create a custom number attribute on the Team object (issue is reproducible with out of the box attributes as well)
2. Go to the Team tab of an existing project and add the custom number attribute to the Team list view
3. Type in a negative amount for this custom field on the list view, Example: -25
4. Click on Save
3. Click on Options - Export to Excel (Data Only)
4. Open the downloaded file
Expected Results: The file opens in Excel
Actual Results: The file does not open and throws one of the following two errors:
"The file is corrupt and cannot be opened." OR "Problems During Load, Problems came up in the following areas during the load: Table"
Reviewing the xls in Notepad, the -25 is being exported in an unregnizable format:
Where it should be exported as: