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 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 : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
