Bug 129812

Summary:	EDITING: Changing cell format doesn't change how its text is shown
Product:	LibreOffice	Reporter:	John <johnsmithbeatles>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	6.2.7.1 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description John 2020-01-05 17:37:47 UTC

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:

Comment 1 m_a_riosv 2020-01-05 22:15:34 UTC

It is not a bug, change cell format never changes the cell content.

Comment 2 John 2020-01-05 23:22:18 UTC

(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.

Comment 3 m_a_riosv 2020-01-06 01:03:46 UTC

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