https://bugs.documentfoundation.org/show_bug.cgi?id=94104
Bug ID: 94104
Summary: Editing
Product: LibreOffice
Version: unspecified
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: bo...@dsa-net.dk
Created attachment 118581
--> https://bugs.documentfoundation.org/attachment.cgi?id=118581&action=edit
Numbers with extra character
Copying data with numbers nn.mm into a spredsheet. OK
Converting cells with numbers nn.mm to nn,mm Most cells behave OK but some
rows
behave ackward. Having an extra ' in front of the amounts
The purpose of converting from english nn.mm to the danish nn,mm is to
prepare for making eg SUM(A1:A15)/TAEL(A1:A15) Average
in the danish version of Libre Office. This needs the ,-version
It is necessary to manually remove the ' in the cells in question, before the
calculation is functioning.
There is no unambiguous behaviour with faulty numbers in certain cells, or
certain rows.
Immediately after the transforming from . to , there is no fault to be seen,
but the calculation fails. After some searching in the faulty cells the numbers
change from nn,mm to 'nn,mm and reveals the misbehaveour !
Attached you have an example of a PrintScreen.
Yours Sincerely
B. Reimann
--
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
