Numbers translate question

"I wanna translate automatically by first cell to second cell what should I do?"

I suspect what you want to do is enter some text in one language in the first cell, then have the text, translated to a different language, returned to the second cell.

The requirements for that to happen would be:

1. Numbers is able to 'push' the original data from cell 1 to translation software, either IN Numbers, in a different application ON the same computer, or via the internet to an online translator, such as Bing or Google's translate pages.
2. Numbers is able to be told the language from which you want the text to be translated AND the language in which the translated text is to be returned.
3. Numbers is able to connect to the output side of the translation software, in order to collect the translated version of the text.

Crash points:

1. Numbers, like most spreadsheets is able to pull data from another cell in the same spreadsheet, but is not able to push data to another cell in the same spreadsheet or to an application external to Numbers.
2. The language in which Numbers operates is determined by the Language setting for the open account on the computer. This is set in System Preferences. Individual Numbers documents may be set to use a different language. BUT this setting determines only the language in which functions used in formulas are named; the grammar conventions and spellings used in the document, and other 'local' format preferences.
3. Numbers may be able to connect with a translation site, but I've not yet seen any documentation for that possibility.

IF that can be done, it might be possible to use and Applescript to assist with moving the data to the Numbers table and collecting the translator's output.

Until that happens, or is known, your most efficient route is likely to:

1. Enter the text inLANGUAGE 1 into Cell 1 of the Numbers document.
2. Select, then Copy that text.
3. In Safari (or other browser), open the Google or the Bing (or other) translation page.
4. Paste the text into the entry box.
5. Set the original language (or accept the application's decision as to what language it is written in) for that box.
6. Set the destination language for the results box.
7. Let the translation be completed, then select and Copy the output text in the result box.
8. Click on Box 2 in Numbers, then Paste.

Regards,

Barry

What do you mean by "translate"? Could you give an example of what you want to see?

SG