MOSS2007 + SP2 (Turkish) Calculated Column not accepting METİN formula
13/01/2012 Leave a comment
Hi Everyone,
if you try suggested formula for Sharepoint Calculated Column (MOSS2007 with Turkish Language Pack) on fallowing official article http://office.microsoft.com/tr-tr/sharepoint-foundation-help/HA010379915.aspx and the help document of wss like
=”Ekstre tarihi: “&METİN([Sütun2], “gg-aa-yyyy”)
is not working and getting error of “Söz dizimi hatası”
Cause :Should be a documentation error .
The formula should be “METNEÇEVİR” instead of “METİN” and the splitter should be “;” instead of “,”
Here is the correct version of formula:
=”Ekstre tarihi: “&METNEÇEVİR([Sütun2];”gg-aa-yyyy”)
You may getting some errors for other formulas please read fallowing warning and always keep in mind:
“All example formulas in this topic use commas “,” as the parameter delimiter character. In some countries, the comma is reserved for use as the decimal mark. In such countries, users creating a calculated field must use semi-colons “;” as the delimiter character. Regardless of which character is used when the field is created, the formula works on lists in SharePoint websites anywhere in the world. SharePoint automatically changes the delimiter character to the one that is appropriate for the language/culture of the current page. For example, suppose the following formula is created on a website whose culture setting is fr-fr (France): =IF(Number1>Number2;5;10). If the website’s culture is then changed to en-us (United States), the formula changes automatically to: =IF(Number1>Number2,5,10).”
http://msdn.microsoft.com/en-us/library/bb862071.aspx