https://bugs.freedesktop.org/show_bug.cgi?id=87050
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED CC| |[email protected] Resolution|--- |NOTABUG --- Comment #3 from m.a.riosv <[email protected]> --- I think there are several ways to do it, maybe the best and secure in advance is the C). A 1) First replace dots with nothing. Results in numbers. A 2 a) using regular expressions convert numbers in text: Search: .* Replace: '& A 2 b) with Menu/Data/Text to column: Select the numbers column Menu/Data/Text to column Mark column head and in Column type box select Text. --------------------------------------------------- B) In one step using regular expressions: Search: (.*)\.(.*)\.(.*) Replace: '$1$2$3 --------------------------------------------------- C 1) Format cells with numbers as Text @ C 2) Doing a search and replace dots for nothing. Format cells as text must be done before search and replace, to avoid the conversion in true numbers. Take in account that change the format never change the cell content. I think it works so by design. For me not a bug. Please if you are not agree reopen it, but in this case I think it would a request for enhancement. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
