https://bz.apache.org/ooo/show_bug.cgi?id=96274
mroe <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords|oooqa | Resolution|--- |WONTFIX Severity|trivial |normal Status|CONFIRMED |RESOLVED --- Comment #10 from mroe <[email protected]> --- 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.
