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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1305877 Title: [Upstream] ' prepended when applying Number Category to Text Category cell with a number in it Status in LibreOffice Productivity Suite: Confirmed Status in “libreoffice” package in Ubuntu: Triaged Bug description: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:4.2.3~rc3-0ubuntu2 Candidate: 1:4.2.3~rc3-0ubuntu2 Version table: *** 1:4.2.3~rc3-0ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages 100 /var/lib/dpkg/status 3) What is expected to happen in Calc is secondary click an an empty cell -> Format Cells... -> under Category choose Text -> click button OK -> in that cell type 1 -> secondary click the cell -> Format Cells... -> under Category choose Number -> click button OK and when one clicks the cell the input line just shows 1, as it does in Microsoft Excel 2003 (11.5612.8172). 4) What happens instead is it shows: '1 WORKAROUND: Set the cell Category to Number prior to inserting numbers. ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: libreoffice-calc 1:3.5.7-0ubuntu5 ProcVersionSignature: Ubuntu 3.2.0-60.91-generic 3.2.55 Uname: Linux 3.2.0-60-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.0.1-0ubuntu17.6 Architecture: amd64 Date: Thu Apr 10 14:10:51 2014 InstallationMedia: Ubuntu 12.04.1 LTS "Precise Pangolin" - Release amd64+mac (20120823.1) MarkForUpload: True SourcePackage: libreoffice UpgradeStatus: No upgrade log present (probably fresh install) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1305877/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
