Created attachment 126825 [details] Lowercase changed to uppercase A field value is changed to uppercase when it refers to another field that contains lowercase value.
Hm, there was a bug like this, caused by Calc's Software Interpreter, but that should be fixed since v5.2.0.2 and v5.1.5. Can you confirm you are indeed using v5.2.0.4, and also check what happens if you follow step 4 from [1]? (checkboxes to enable/disable OpenCL and Software Interpreter are next to each other) If your version is 5.2.0.4, please create a sample spreadsheet (let's say, by clearing out all the irrelevant cells in the existing sheet), and attach it. [1] https://wiki.documentfoundation.org/QA/FirstSteps
*** This bug has been marked as a duplicate of bug 101866 ***