https://bugs.freedesktop.org/show_bug.cgi?id=42518
Bug #: 42518
Summary: TABLE: Bad results calculated for formula in table
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.3.3 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Writer
AssignedTo: [email protected]
ReportedBy: [email protected]
Problem description:
Using incorrect/unexpected number format in a formula in a table
results in incorrect results instead of an error message.
Steps to reproduce:
1. Create table with at least two fields. Set language as "German
(Germany)". Set cell format as "Number", Number format "general".
2. Enter "100" in first cell.
3. Enter formula "=<A1>*0.19" in second cell.
Current behavior:
The formula will calculate the result as "1900".
Expected behavior:
The result should be "19".
The preoblem results froim the fact that due to the German environment
the expected number format uses ',' instead of '.' as decimal point.
Writing the formula as "=<A1>*0,19" gives the correct result.
The real bad problem is that the incorrect format goes through
undetected, and results in incorrect values being calculated.
There should be an error raised for invalid number formats.
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Linux x86_64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
