https://bugs.freedesktop.org/show_bug.cgi?id=60775
Priority: medium
Bug ID: 60775
Assignee: [email protected]
Summary: FORMATTING division of currency values is not a
currency value
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 74736
--> https://bugs.freedesktop.org/attachment.cgi?id=74736&action=edit
reproduction example
Only cells A2 and B2 have currency format. *ALL* other cells have "Number /
Standard" format.
Cell C2, formula "=B2*2" displays as currency. Nice feature, do the right thing
by default.
Cell E2, formula "=A2/C2" displays as scalar (unitless, not currency). Nice,
still does the right thing by default: it recognises that division of currency
values is not a currency value.
Cell D2, formula "=A2/(2*B2)", that is take the formula in E2 and expand the
formula of C2 in it. It displays as currency! This is wrong. It should display
the same as E2, that is unitless.
A similar situation arises with cells F2, H2 and G2.
--
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
