Whenever the GoogleTranslate() function fails within a Google Docs spreadsheet, it places the following comment with each #VALUE cell:
"error: The combination of the second and third paramter is invalid: 'en', 'gd'. Translation between these two langauges are not supported yet." (FYI, 'gd' is the Scots Gaelic language) The problems with the error message itself: 1. "Parameter" is misspelled "paramter" 2. "Languages" is misspelled "langauges" 3. Subject-verb disagreement between "Translation" and "are" But there's something worse going on here... The problem with throwing this type of error condition, I assert, is that Google Apps Scripts taking data from translated cells are subject to failure solely because Google has not yet implemented a particular pair of languages. Why not let the translation fail gracely by NOT attempting it? That is, let GoogleTranslate() return the original (untranslated) text to the cell, but add the 'error' comment behind it! Thanks. -- You received this message because you are subscribed to the Google Groups "General" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-translate-general?hl=en.
