[Issue 96274] Cell contents remains number after modification with format cell

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=96274

mroe <mr...@gmx.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|oooqa                       |
         Resolution|---                         |WONTFIX
           Severity|trivial                     |normal
             Status|CONFIRMED                   |RESOLVED

--- Comment #10 from mroe <mr...@gmx.net> ---
I close this old issue as RESOLVED:WONTFIX. (maybe NOT_AN_ISSUE)

reason:
a) (see comment 3) Changing the format of a cell does never change the content
of a cell.

b) (in reply to comment 9) There are only 3 types of possible content of a
cell:
1) number, 2) string, 3) formulae.
Dates and currencies are also only numbers with different format.

To see the problem of the attached sample document simply select View → Value
Highlighting (Ctrl+F8).

To solve the problem convert the values according to the selected cell format:
1) Select the cells
2) Edit → Find & Replace (Ctrl+F)
3) Search for: .*
Replace with: &
[x] Current selection only
[x] Regular expressions
4) [Replace All]

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.