Description: A formula (which returns a text as result) will be displayed after re-type it into cell when cell format is "Text". When cell format is "Number" it works. Steps to Reproduce: Pre-Step: Add the Basic-Macro "Toto_Macro.bas" which returns a text based on numeric parameters. 1. Open Toto.xlsx 2. Select cell AB2 3. Goto input line and copy the formula into clipboard 4. Press strg+x to remove it 5. Press strg+v to add it and press enter Result: Formula result will be displayed (ok) 6. Change format of cell AB2 to "Text" 7. Re-Run steps 3-5 Result: Formula will be displayed (Bug) Actual Results: Formula itself will be displayed. Expected Results: Result of formula should be displayed. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 153415 [details] Example files
(In reply to RobG from comment #0) > 6. Change format of cell AB2 to "Text" > 7. Re-Run steps 3-5 > Result: Formula will be displayed (Bug) if you format a cell with "Text", everything what is entered afterwards is treated as text, so a formula will not be evaluated. https://help.libreoffice.org/Calc/Formatting_Numbers_as_Text