Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Excel Export - Blank Cells No Longer Blank

Tim H
edited 12/09/19 in Archived 2015 Posts

The recent release has caused an issue with export to Excel.  

 

Any empty cell in the Smartsheet isn't actually empty when exported to Excel - I've got a tracking spreadsheet which uses as part of a calculation a count of non-blank cells in a column and this has stopped working.  

 

The last Smartsheet export I took on 7th July was fine, I took another one today and it doesn't recognise the cells as being blank (if you click the cell and clear content / delete then it does) so I can only presume it was something in the 11th July release which has caused this.

 

Please could this be fixed as it's causing me a real headache!

Comments

  • As an update to this - it looks like the empty cells are being exported with a line return in them, which Excel treats as non-empty (if you copy and paste the 'empty' cell into Notepad++ it comes up with CR LF characters)

  • Travis
    Travis Employee

    Thanks for bringing this to our attention! I will submit this to our developers and will let you know when I hear back from them. 

  • Travis
    Travis Employee

    Hello! To give you an update, our developers have identified what is causing this and a fix will be included in our next release which should be released in late July / early August. 

  • Great, thanks

This discussion has been closed.