For the record I'd like to note that this is a bizarre, unintuitive intended behaviour, and the fix you propose is equally bizarre and unintuitive. Having to install an extension seems way over the top for what should be a core functionality (I guess at some point someone was so desperate to do this that they resorted to coding the extension!).
I first attempted a find-replace for ' -> [empty], which didn't work. Your regex example will be totally opaque to nearly all users. The answer to the pasting some data from a website problem is to Paste Special... get the delimiters right and make sure to check the box to detect special numbers (my data are here: http://physics.nist.gov/PhysRefData/XrayMassCoef/ComTab/pyrex.html ). -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1305877 Title: [Upstream] ' prepended when applying Number Category to Text Category cell with a number in it To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1305877/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
