Created attachment 50569 [details]
Demonstrate defined name bug
Open the attached spreadsheet. You will see there are two defined names: BonusSTR and HandAttackDC.
BonusSTR is defined to be "(HandAttackDC*5)". You will see, however, that LO has improperly saved the definition as "(handattackdc*5)". In other words, all lower case. Naturally, you will get an error if you use BonusSTR in a formula. If you correct the capitalization of HandAttackDC in the definition of BonusSTR, it will work correctly, and the capitalization will be retained, only in your current session. If you save and quit, HandAttackDC will again incorrectly be lowercase when you reopen the spreadsheet.
Working on this. The actual problem is not case sensitivity but the order in which defined names are encountered during import. BonusSTR needs HandAttackDC that is not present yet, hence it works when changing anything in the definition of BonusSTR later as it is recompiled then.
Fixed in master http://cgit.freedesktop.org/libreoffice/core/commit/?id=6f42e4d03b04204b7a864f3c5c9c03548f5e2392
*** Bug 40590 has been marked as a duplicate of this bug. ***
*** Bug 42310 has been marked as a duplicate of this bug. ***
In 3-4 http://cgit.freedesktop.org/libreoffice/calc/commit/?h=libreoffice-3-4&id=f270d113e354aa608a2efa641691167a504c6539