Eike Rathke, thanks for taking a quick look at this. Given when one comes from using Excel, where if one converted the Category from a Text to a Number, no apostrophe is appended, and how the LO code had designed an apostrophe in, this would be an "Excel functionality compatibility expectations" report. Hence, would the WORKAROUND you documented in https://bugs.freedesktop.org/show_bug.cgi?id=77317#c2 be documented on the LO wiki at http://help.libreoffice.org/Main_Page ?
m.a.riosv, suggesting the original reporter create now a third report (one downstream, this one, and your suggested third) because they didn't know it's an enhancement vs. a bug is a terrible habit of the OpenOffice.org bugzilla I've seen happen to others and personally experienced, and that we here at LibreOffice would not want to replicate. Hence, I've gone ahead and marked this lowest enhancement given the advised WORKAROUNDs. Thank you for your understanding. -- 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
