https://bugs.freedesktop.org/show_bug.cgi?id=77317
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #2 from Eike Rathke <[email protected]> --- That's not a bug. Applying a cell format never changes the cell content. The ' apostrophe in the input line is prepended so that when editing the content it stays text. Removing the ' will accept the input as number then. You can bulk change multiple cells by selecting them, apply a number format and then invoke Find&Replace Search: ^. Replace: $0 and in options check regular expression and selection only. Or use the Convert-Text-To-Number extension from http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates -- 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
