DataTables logo
≡

Blank string or null - excel

Blank string or null - excel

diegonogueiradiegonogueira Posts: 2Questions: 1Answers: 0
in Free community support

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.

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 65,865Questions: 1Answers: 10,958 Site admin
    Answer ✓

    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

This discussion has been closed.