[原创] Connection with server application error的解决办法 Connection, error, application, server, 办法

Localizer

当使用TagEditor打开Excel文件，准备保存成ttx文件时，出现如下错误（见截图）：
% S: Q. |8 u3 D# [) \5 I" s, Y! N: C! ~0 Y/ w- \( v8 ^
(80005): Connection with server application error:
* J) Q4 Y9 M- B+ h' PSpecified cast is not valid.   `; I- D% x0 T1 h! v: [6 X# @

# q9 T" T5 Q  S1 i0 z5 t9 k5 O6 z) F' C1 C% F$ _1 A2 E( c, w, v
3 {: f9 t5 o% `/ |. G- k
反复试了几次都这样，以前一直没出现过这个问题。于是仔细研究并上网搜索。终于知道了原因，并且找到了一个解决办法。. G3 j, y6 }" {7 P# @9 N
2 m' N) E% N+ z! k$ y' S
原来，这是由于Excel中有插入的文本框或图形造成的，如果这些文本框或图形不需要翻译，只需要把它们从Excel中删除，然后转换成ttx文件开始翻译，翻译完成后，再把他们重新拷回来即可。但如果这些文本框或图形中有需要翻译的内容，只能把这些文字拷出来单独翻译，等Excel翻译完成后，再把这些单独翻译的文字帖回到Excel中。
/ A% A) \) D- m/ A8 R2 I- [: ~" O# S3 z9 L& E5 o+ G) Z
虽然麻烦了一些，但毕竟是个解决办法。我用这个办法成功转换了文件。
0 N* N4 s# x$ H! ~2 }7 H% v4 @3 R4 j( W+ k9 x) x4 }, _4 I
SDL 技术支持提到了这个问题：
$ t0 S! e% f; b, N! }& @" U; j6 H+ W
When opening a Microsoft Excel document in TagEditor, the error message Connection with server application error: Specified cast is not valid is shown.
7 L$ x% \& v, d% }. F8 G(Error code: 80005).& d# z! [7 s5 u% j
" w2 R, W, h0 {' C; a
Explanation
- K; D  \4 r% ~  v6 Q: |5 u" dThis error may occur when your Microsoft Excel document contains a text box or a drawing that is an OLE (Object Linking and Embedding) object.
) r# n! r0 K0 _, F: M8 J( TThere is no fix for the issue yet. The best workaround depends on if the object contains translatable text or not.
. T# A: t* m; i& T" U' RIf the object does not contain text that you have to translate, or if you do not have to translate the text within the text box or drawing, you can either delete it from your source file and paste it back into your translated target file after translation, or protect it in Microsoft Excel using Tools > Protection > Protect sheet. All text on that particular sheet will then be automatically skipped when you open your file in TagEditor.
$ L& c$ `8 ]1 S4 CIf you really need to translate the text within the text box or drawing, the best workaround for this issue is to copy and paste this text into a new empty file and translate it from there. Afterwards you must recreate the object in your translated Excel file and copy the translated text back in.