Created attachment 127280 [details]
Described bug on sheet 2
In some cases result of simple reference to cell contains text is CAPITALIZED.
Example: A7 contains "3a Gim" result of reference "=A7" in H7: "3A GIM". If i change reference like this: "=A7&"" " (Add empty string) result is ok "3a Gim". I use strings in CASE SENSITIVE projects (www, passwords etc.) and this behavior is very cumbersome. This may affect many users of Calc. In previous version (4.0? i don't remember) every think works fine.
This is supposed to be fixed, the fix was done in two batches, one for LibreOffice 5.1.5 and 5.2.0, the other will be available in 5.1.6 and 5.2.2.
As a workaround you can also go to Tools -> Options... -> LibreOffice -> OpenCL, and uncheck both checkboxes (restart of LibreOffice required afterwards).
*** This bug has been marked as a duplicate of bug 75387 ***