Public bug reported: When I paste some numerical data the cell format is set to "Text". ALternatively I could type some number into a cell with Text format.
When I change the format to "Scientific" or "Number", a ' gets prepended to the cell content and is therefore not recognised as a number. To replicate: Open calc Set the cell format to 'Text' Enter into the cell a numerical value, such as 1 or 1E1 Change the format to Number or Scientific Note that the cell is shown as left-justified and without an extra ', and in the function bar it is shown with a ' prepended (e.g. '1 or '1E1). This bug only occurs when the cell format is set to Text prior to the content being added. 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) ** Affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug precise running-unity ** Summary changed: - ' prepended when applying Scientific format to cell + ' prepended when applying Scientific or Number format to Text format cell -- 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: ' prepended when applying Scientific or Number format to Text format cell To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1305877/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs