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
