Good morning,
we noticed a bug in Oracle SQL Developer 4.0.3 when we export data to Excel file with the "Query Worksheet Name" option enabled and the SQL code is very large: the script contains 10 IN() clauses with near 10'000 items, for a total of over 160'000 characters.
If we select the Excel 95-2003 (xls) file format, the file always opens correctly and the SQL worksheet is empty: I think because the length of the SQL string exceeds the maximum supported by the Excel cell.
If we select the Excel 2003+ (xlsx) file format, when Excel tries to open the file says it is corrupted and offers to recover it truncating the SQL code in the SQL worksheet.
Many thanks, best regards.