Description: In calc do the following: format a cell as text; enter a division equation, e.g.=4/2. Convert cell to number; hit return in cell. Number won't divide. Must erase expression and re-enter. Steps to Reproduce: 1.Format a cell as text 2.Enter a division equation, e.g. =4/2 3.Convert cell from text to numeric 4.Hit return, =4/2 remains in cell unchanged. 5.Erase and re-enter =4/2, expression works. Actual Results: See above Expected Results: See above Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
There is not such bug. Change the format doesn't change the content of the cell. So the text in a cell formatted as text remains as text after change the cell format. https://help.libreoffice.org/Calc/Formatting_Numbers_as_Text