Launchpad has imported 2 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=77317.
If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.
On 2014-04-11T09:08:15+00:00 Michael Doube wrote:
This is a simple bug in Calc which can be replicated by doing the
following:
1. Set a cell format to Text
2. enter a numerical value into the cell (e.g. 1 or 1E1)
3. Set the cell format to Number or Scientific
4. Note that the cell data is left justified and has a ' prepended to it in the
input line, which is not visible in the cell itself
This means that the cell value still interpreted as text and not as a
number, so it's impossible to plot it in a chart or do arithmetic with
it.
I hit this the first time when copying some data from a website into
Calc. The numerical values were not recognised and were automatially
pasted into Text formatted cells (OK, that's understandable). BUT:
changing the values to Number or Scientific format didn't change the
underlying datatype of the cell from characters to numbers.
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1305877/comments/3
On 2014-04-11T09:08:54+00:00 Michael Doube wrote:
Downstream bug report:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1305877
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1305877/comments/4
** Changed in: df-libreoffice
Status: Unknown => New
** Changed in: df-libreoffice
Importance: Unknown => Medium
--
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 Number Category to Text Category cell with a
number in it
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1305877/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs