Description: 1. Open Calc. Select some cell. Ensure the cell format is "Number": Context Menu > Format Cells > Numbers > Category = Number 2. In the selected cell, type "= foo bar" (without quotes). It will be an error: Err:509. 3. Change the format of this cell from "Number" to "Text". 4. See that "Err:509" wasn't changed to "= foo bar". It is still "Err:509". Steps to Reproduce: - Actual Results: - Expected Results: - Reproducible: Always User Profile Reset: No Additional Info:
It is not a bug, change cell format never changes the cell content.
(In reply to m.a.riosv from comment #1) Isn't is weird? A) When you add "= aaa bbb" content to the cell that have "Number" format, it will be processed as formula. B) When you add the same content to the cell that have "Text" format, it will be processed as literal text. C) But when you change the format from "Number" to "Text" and vice versa, the content will *not* be changed. This behavior is completely inconsistent with A and B.
C) is right, cell content it's not changed, Differentiate between cell value and cell format, it's the key. Maybe you don't like it but I'm pretty sure it won't change. https://help.libreoffice.org/6.3/en-US/text/scalc/guide/text_numbers.html?&DbPAR=CALC&System=WIN