Bug 105124

Summary: Division quirk in Version: 5.1.4.2 Build ID: 1:5.1.4-0ubuntu1
Product: LibreOffice Reporter: bill.wilken@wilkenmai.com <bill.wilken>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 5.1.4.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description bill.wilken@wilkenmai.com 2017-01-05 16:12:28 UTC 
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
Comment 1 m_a_riosv 2017-01-05 22:29:31 UTC 
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