You create a report that contains a Zero with more than 14 decimal places of precision.
You export the file as Excel XLSX.
When opening the file, Excel will throw the error:
"We found a problem with some content in 'report.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."
After clicking Yes,
"Excel was able to open the file by repairing or removing the unreadable content"
"Repaired Records: Cell information from /xl/worksheets/sheet1.xml part"
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
<summary>Errors were detected in file 'C:\Users\HAL9256\Documents\report.xlsx'</summary>
<repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet1.xml part</repairedRecord>
After repairing, the cells with Zero's format have been converted to a text field containing "0.00000000000000" this is undesirable.
This is similar to the Connect issue: 751606
I am running:
Microsoft SQL Server 2014 (SP1-CU5) (KB3130926) - 12.0.4439.1 (X64)
Feb 15 2016 12:12:43
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )
Excel 2016 MSO (16.0.4321.1000) 64-bit