I have just been trying to export my spread data to a CSV. The last column of the data I have been working with does not always have a value and as a result when exporting to CSV I noticed that some rows end with a comma (the expected result when the value is blank) and others don't - even when the last value is blank... Very strange!
Thanks to some other posts out there on the web to get around this problem you need to populate the last column with a value - be it a space, a tab etc Once it contains a value the comma is then consistently applied to the csv output file - phew!
Here is a post on the Microsoft regarding this "feature" - Mircosoft support article
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment