in cell B4, enter formula =SeaNine it changes to =seanine and gives the expected error message because SeaNine and seanine are undefined name cell C9 SeaNine or seanine error message remains in cell B4, even after Ctrl+Shift+F9 copying cell B4 to another cell retains the error in the copy Manage Names (Ctrl+F3), replace one character in SeaNine (or seanine) with the identical character and click OK formula in cell B4 finally recognizes the reference replacing one character in SeaNine (or seanine) with the identical character, in the formula in B4, also works
I can not reproduce with Version: 4.4.0.0.beta2+ Build ID: e1de94244c1b0419c1c3415c02381e8b7a87abe0 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2014-12-14_11:45:23 After entering name formula works. Please test with Version: 4.4.0.0.beta2+
I have confirmed that the problem does not occur in LO Calc 4.4.0 Beta2 Dev Daily installed 2014 12 18.