SSRS export to Excel XLSX creates invalid Excel file when source data contains Zero with precision more than 14 decimals places - by HAL9256

Status : 

 


6
0
Sign in
to vote
ID 2524655 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 3/28/2016 9:30:45 AM
Access Restriction Public

Description

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"

Log:
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
  <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <logFileName>error489000_04.xml</logFileName>
  <summary>Errors were detected in file 'C:\Users\HAL9256\Documents\report.xlsx'</summary>
  <repairedRecords>
    <repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet1.xml part</repairedRecord>
  </repairedRecords>
</recoveryLog>

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
https://connect.microsoft.com/SQLServer/feedback/details/751606/sql-server-2012-reporting-services-export-to-excel-xlsx-zero-to-15-decimals-places

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
Sign in to post a comment.