My Boss is crazy

[John21]

I have and extremely weird question or at list I think is odd. Is ther
any possible way in whish I can translate the language of a column o
worksheet or workbook. For example click a column and get a menu o
options to change the language

 

[aaron.kempf]

IT SURE WOULD BE EASY IN A DATABASE!!!

 

[Harlan Grove]

(e-mail address removed) wrote...

IT SURE WOULD BE EASY IN A DATABASE!!!

Why don't you show us how easy?

A simple lookup of individual words in one language with words in
another language? Go on and try it.

 

[aaron.kempf]

it's called internationalization

a) have a list of keywords in a database
b) have a language_id or something like that
c) use captions in different languages depending on the region that
you're in.

I've been doing stuff like this in the database world for years.

-Aaron

 

[Harlan Grove]

(e-mail address removed) wrote...

it's called internationalization

a) have a list of keywords in a database
b) have a language_id or something like that
c) use captions in different languages depending on the region that
you're in.

I've been doing stuff like this in the database world for years.

....

Keywords are nice, but how do you translate the English sentence "I get
it." into any other language?

Message internationalization is MUCH EASIER than true translation
because the messages are fixed sentences or series of sentences, and
the database comes with the complete translations in all supported
languages. It's just a simple lookup on message ID and language ID.
It's not translation.

But this may or may not be what the OP's after. It's possible what the
OP wants to do is change the language settings for formulas on the fly.
That's not possible in either Excel or Access (if Access provides
internationalization for it's built-in functions). Language settings
apply at application level, nor document or document section level.

 

[aaron.kempf]

you store it in multiple languages.

why is it that there are 8.2 million links for 'database
internationalization' but there are only 300 hits for 'Excel
internationalization'?

store multiple versions in XML or in a Database.

but Excel sure isn't strong enough to support internationalization /
localization

IIF(MY_LANGUAGE="ENGLISH"), 'HELLO WORLD, (IIF(MY_LANGUAGE="GERMAN"

oh _wait_ a second; Excel only supports nesting if thens up to 7 layers
deep-- so that's not an option


lol

spreadsheets are for RETARDS

there are hundreds of products for translating DATA. the root of the
problem is that Excel is an ass-ton of spaghetti code and it's
impossible to STORE DATA IN EXCEL.

Excel doesn't have 10% of the functionality it needs for data entry;
let alone complex queries.

It's all about filtering ****nut.

and Excel CANT FILTER

 

[aaron.kempf]

and if Excel could FILTER with 1/100th of the functionality of a
database product?

then maybe you could use Excel to store these strings.

if Excel could utilize web services; if Excel could utilize extended
stored procs-- that could translate text strings-- through a web
service-- than maybe _ALL_ the excel dorks in the world would be worth
a single nickel collectively.

but putting code in Excel VBA? And distributing DLLs on the desktop?

Excel just doesn't have 1/10th of the functionality of a real database

Excel is for BABIES