View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Int'l R1C1 or R1K1 or L1C1...

ps.

John Green, Stephen Bullen, Rob Bovey and Robert Rosenberg have a chapter in one
of their books that deals with international issues.

They share that chapter he
http://www.bmsltd.co.uk/ExcelProgRef/default.htm

Look for this link:
Chapter 22 - International Issues



Wim SKW wrote:

Hi Dave,

"Dave Peterson" wrote:

I don't use multiple languages, but if I wanted to check to see if A1 is locked,
I could use this in English:

=CELL("protect",A1)

I'm gonna guess that "protect" would change with different language
versions--protekt????

It may be worth a look to verify.


First of all, it may be worth noting that I have an *english* version of
WINXP, with several language packs installed, so I can change the language of
the menus and dialogs.
I've heard that this situation is different than say an original French or
Dutch or German version of XP, with a localised version of Office.

I have verified and found that each language has a more or less translated
word for "protect".
However, it seems that they all know "protect" too, but I don't know whether
this is because my base version of Office is English.
If I use the translated word for "protect", these words (*) only work when
the system is switched to that particular language.
Strange...

(*)
In Dutch: "bescherming" (which means "protection" in English)
In German: "Schutz" (also means "protection" in English)
In French: "protege" (which means "protected" in English), allthough in
_real_ French and according to the help files it should be "protégé" (with
accents), but that doesn't work !
According to
http://office.microsoft.com/fr-fr/ex...CH062528261036 , in Excel 2003 the French translation has been changed to "protection".
Even stranger...

-=Wim=-


--

Dave Peterson