I've been using the Datagrid object in my application and it's been working fine as a really efficient way of importing data, I'd like to keep using it as I'm familiar with it now and lots of my events and expressions rely on the object.
One nag I've had, which isn't really game-breaking but a massive inconvenience, is that when I copy data into a cell from an Excel spreadsheet all the commas are treated as delimiters and separate large blocks of text into multiple cells. This is a problem as many of my cells contain paragraphs of text with multiple commas, and I'd like the paragraphs to remain in one cell.
So is it possible to change the delimiter from a comma to some other other character? Or to remove the delimiter entirely? It would make my development much more efficient!
Thanks in advance