Hi, The enhancement 120478(https://issues.apache.org/ooo/show_bug.cgi?id=120478) is done, support sheet scoped named ranges in Calc.
Code is committed in revision 1379349<http://svn.apache.org/viewvc?view=revision&revision=1379349>The build will be ready. Please test it when build is ready. Any problem please open bugs or send mail to discuss. Thanks The description of this enhancement is http://wiki.openoffice.org/wiki/Calc/Features/Calc_name_range_enchancement%28step1%29
