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.