Excel Export - Blank Cells No Longer Blank

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!

Find more posts tagged with

Project Management

Importing and Exporting

Comments

Tim H

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

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

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.