two-column comparison documents to translate

Can TransTools for Excel be upgraded to translate Excel documents using the same real carriage return as TransTools for AutoCAD, importing .xlsx (no more </BR> to simulate real carriage returns)?

This format is convenient for the compatibility and versatility of Excel and AutoCAD in operation and document structure!

To use the CAT tool, it is necessary to install software, languages, and various tedious settings for sentence segmentation. It is also necessary to convert some existing .xlsx documents into translation memory. The operation process is very tedious and complicated. Sometimes you just need to judge the text matching rate of the new drawing of AutoCAD first, and you are not in a hurry to do the translation directly. At this time, the efficiency of using TransTools for Excel will be much faster. We are only AutoCAD drawing typesetters, not translators, and cannot translate directly!

I am not a translator, just an AutoCAD typesetter. I often work with the same clients to translate and typeset AutoCAD drawings, so I often encounter customers who deliver similar drawings for translation and typesetting!

At this time, we will first extract the text of the new drawings that the customer wants to work on, and then use the two columns of .xlsx that have been translated in the past to translate and replace the extracted text .xlsx, and then sort and delete the translated part, Only leave the blanks that have not been translated, and then hand over the untranslated parts to translators for translation, which can greatly save the cost of translating words. Therefore, the profit of our drawing typesetting operation is largely derived from deleting duplicates. Text no longer translated! Moreover, this method can also make the translations of the old and new drawings unified, and there will be no situation where the original text is the same but the translation is different!

The translator will return the translation after translation, and then reconcile the new and old .xlsx two columns against the document, write it back to the drawing, and then do the typesetting!

Because TransTools for Excel translates by pasting text lines, whether it is the original text or the inserted text, it is not a real carriage return. If either side is changed to a real carriage return, it will cause a mismatch and no translation. This is not a use case. Any tool can do it.

In fact, you can turn <br/> into a real carriage return without any tools, just use Excel's built-in replace command.

However, this command behavior cannot be solved fundamentally. The problem of real carriage return needs to be continuously converted from <br/> to real carriage return, or the real carriage return to <br/>.

A translation that imports .xlsx and supports true carriage returns must be used instead to effectively resolve this issue.

Excel is a newline character yes...

Because I'm not familiar with English (and I don't understand programming and various documentation principles)

I wrote in Chinese first, then Google machine translation

I don't know if there is any discrepancy between the machine translation and my original meaning

Excel is Alt + Enter and Word is Enter

But I am not in the mood to study these, I just feel that the translation data of AutoCAD and Excel generated by TransTools cannot be used interchangeably, and I feel very troubled!