Created attachment 125176 [details] Screenshot inserting a formula calc display formula text instead of the result. this makes Calc unusable on Linux.
See your options, menu Tools -> Options -> LibreOffice Calc -> View under Display the option Formulas should be unchecked, likely it is checked for you.
*** Bug 99958 has been marked as a duplicate of this bug. ***