Open in Excel empty cells not empty

Remko1981

When i use the very handy feature of 'Open in Excel' by right clicking in the result grid cells which contained a NULL value are left blank which is very useful. Though if i create a pivot table from the exported data empty cells are counted as if there is data inside them.

Manually clicking delete on blank cells solves this problem but this is not feasible on large datasets. When i now need to do counts for values i replace all empty cells with a value and then switch the fields so that the cells are truly empty.

This behavior for us is very error prone since i almost send out a compliance report which scored 100% while the compliance was much lower than that.

Before clicking delete on empty cell(Aantal = Count).

After manually clicking delete on 1 cell:

Kurt_M

Hi @Remko1981

I just wanted to let you know the developers have actually fixed this for the next release of SQL Prompt.

Once that has been released, I will let you know.

Kurt_M

Hi @Remko1981

I've confirmed this has been fixed in the latest release. You can use the following link to download it:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.11.3.26715.exe

Kurt_M

Hi @Remko1981

I've replicated what you've put in your post. I have forwarded this to our development team to have a look into. I will advise you once I hear back from them.

Thanks.