14/04/2011 Leave a comment
One of our customer complain that after migrate Sharepoint 2007 farm to Sharepoint 2010 farm and implement turkish language pack , calculated column of formula is not working.And Getting error The Formula contains a syntax error is not supported.
Change the culture settings to previous language than see it will work. If you load Turkish Language Pack and define Religional Settings -> Culture as Turkish , Calculated Column Formula syntax has changed to use “;” semi colon instead of “,” colon. Because Decimal seperator is “,” colon in some cultures like Turkish and this cause a conflict between Calculated Column Formule Syntax Parameter seperator and Decimal Seperator.
SUM(10.10 , 10.20 , 10.30) it s working en-US as total of 30.60
SUM(10,10 , 10,20 , 10,30) its working wrong tr-TR as total of 120.
Here is the right usage:
SUM(10,10 ; 10,20 ; 10,30)
In Migration senarios you have to careful for culture differences between two product.