https://bugs.freedesktop.org/show_bug.cgi?id=77317
Priority: medium
Bug ID: 77317
Assignee: [email protected]
Summary: EDITING: ' prepended when applying Number or
Scientific format to Text formatted cell with a number
in it
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
