Toad World® Forums

Issues with Excel Export in SQL Navigator 7.1

We just upgraded from SQL Nav 6.4 to 7.1. In the earlier version when we export the data to excel (.xls format) the NULL values in the cells use to get exported into excel as blank. If we do ISBLANK() in the excel, it returned TRUE.

But in the new version (7.1), the export of data into Excel is coming up as non-blank. ISBLANK() function in excel on these empty cells comes up as FALSE. This is causing problems when we do math functions on top of cells having NULL values. Earlier the math functions use to work seamlessly by considering the empty cells as zero, but now this has changed. we need to explicitly convert and we do lot of extracts using SQL Nav.

Could you please revert to the original feature or point me if there is any option available to do this.

Thanks

Dinesh

Hi Dinesh,

Thanks for your report, in 7.1, we use empty string assign to Null value in excel, so when you do ISBLANK() in the excel, it returned FALSE.

we have create Defect SQLNAV-1749 for you, will let you know when we fix it

Thanks,

Michael

Hi Dinesh,

The first 7.2 beta of SQL Navigator is finally available (expires on 25-Dec-2014)

defect SQLNAV-1749 has been fixed.

Find download links from: www.toadworld.com/…/default.aspx

Thanks,

Michael