readxls returns wrong result when chart exist in the excel file
Reported by Chin Luh Tan
testexcel.zip (12.21 KB, application/x-zip-compressed)
excel files to test the readxls function
BUG DESCRIPTION:
----------------
readxls return invalid data when a chart exist in the excel file
ERROR LOG:
----------
No error, just return dummy data
HOW TO REPRODUCE THE BUG:
-------------------------
The attached zip file contains test1.xls and test2.xls, both have same data but the test2 comes with a simple chart.
-->Sheets = readxls('test1.xls')
Sheets =
Sheet1: 18x2
Sheet2: 0x0
Sheet3: 0x0
-->Sheets = readxls('test2.xls')
Sheets =
Sheet1: 18x1
Sheet2: 0x0
Sheet3: 0x0
The return dimensions are different, and the data for the test2 are just empty string or nan.
OTHER INFORMATION:
------------------