In google sheet, formula =CONCATENATE works the same – we don`t think we should fix it, but as a variant we can just add new formula =HTML to return content predetermined to it, removing all substitutes for html symbols.
Please, tell me about your thoughts on this issue.
Sorry for a late reply on forum. As far as I know, your problem has been resolved.
Just in case everybody else will be looking for an answer here I’ll leave a conclusion – we have implemented it to life.