Blank string or null - excel

diegonogueira

Hi everyone!

I found a problem when I try to export to excel and I have blank string or null values.
When I open the xlsx file, I found the tag:

  <c t="inlineStr" r="D2">
    <is>
      <t/>
    </is>
  </c>

This D2 cell is blank. When I try to use the COUNTBLANK function on excel, this cell blank is counted. It's like this D2 cell has some value..
When I delete the cell on excel and open the xml again, this tag is deleted. So, the excel only identify blank/null cell when it does not exists.

Has anyone faced this problem before? There is a workaround to do on export time or some plugin configuration?

Thank you.

allan

It looks like you might have fixed this yourself with your github pull request. Let's continue the discussion there when I've had a chance to look into it.

Allan