https://bugs.documentfoundation.org/show_bug.cgi?id=97258
Bug ID: 97258
Summary: Crazy behaviour when pasting percentage numbers from
text files
Product: LibreOffice
Version: 3.5.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: leprech...@email.it
I have LO 3.5.7.2 in an Ubuntu 12.04 32 bit platform, installed from standard
repositories.
I pasted a percentage copied from a pdf (or from a rough text file) into a
cell. Suppose A1.
Something like this:
13%
There is no white spaces nor form feeds into the cell, I carefully checked.
I can make arithmetic with this cell (f.i. =A1*2 gives 0,26).
If I format the cell as a percentage, LO adds a ' at the start of the cell:
'13%
transforming thus this cell into a text. This cell become unusable, arithmetic
doesn't recognise it as a number. Text to number extension say "nothing to do".
I have to erase the ' by hand as the sole solution.
If I don't format the cell as a %, I can't modify the precision of the number
(number of digits after the , (Italian) or . (English). So, apparently, from an
arithmetic point of view, LO treats this cell as a percentage, but is is unable
to modify precision, considering it as text from a different point of view.
This doesn't happens if I input the same string (13%) from the keyboard.
You can imagine when a user like me have to paste a huge range of such data.
No way to transform the whole range into a range of % cells, but changing every
cell one by one by hand. Search and replace doesn't find the ' at the beginning
of the cell, and Text to number extension is unable to detect the '13% as a
string, and writes "nothing to do".
This behaviour is crazy and incoherent.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
