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
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)
-
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.
-
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
