Bug in Google Spreadsheet import?

Haha, I had to double check the Spreadsheets Standards to verify that's the right behavior, but yes, it seems that's the expected/correct behavior.

The problem is that in Excel, Google Spreadsheet and some other spreadsheet programs, the single apostrophe at the beginning of the cell, has an special meaning. It defines that the string that comes next is a Text, not a date, nor a value, but a Text.
That means, that when you type in an Spreadsheet you are basically typing [Text].
You can even see in the spreadsheet, that its cell doesn't show the (') you can only see it when you click it and edit its formulae.

To make the double single quotes work, just make it three single quotes (''') or add an space at the beginning ( '').

Hope that helps,
Frank

Yes, That its now fixed in v2.8.4a5. I just uploaded it to the beta folder.
I also updated the Unity Tests to verify this cases, so that they don't happen again in the future.

Also, 2.8.4a5 fixes the export/import, but only when doing REPLACE. The AddNewTerms mode needed some changes to the WebService, so, in order to make it work, you will need to delete the WebService in your GoogleDrive and reinstall it again.

Hope that helps,
Frank

We just updated the WebService to V5. Is that the correct one, or is there a V6?

It was a change that doesn't break functionality for others using 2.8.3 or older, so left it with v5 while 2.8.4 is still in beta.
As soon as I release 2.8.4f1 then I most likely will rename it to v6.