https://bugs.freedesktop.org/show_bug.cgi?id=63446
Priority: medium
Bug ID: 63446
Assignee: [email protected]
Summary: FORMATTING: formulas computed from currency cells
always yield currency formatting
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
Formulas computed from currency cells always yield a currency-formatted value.
Attempts to change the formatting of the cell to "number" fail.
For instance, I was attempting to compute the percent increase in the value of
an investment over a period.
A1 = 01/01/2013 B1 = $1000
A2 = 02/03/2013 B2 = $1003
then let C2 have the formula "=(B2-B1)/(A2-A1)"
the cell C2 ends up formatted as currency, when of course those units don't
apply here.
Hopefully I've narrowed it down to a reproducible scenario. I don't know
whether the problem applies outside of just currency.
Thanks for the amazing work you do!! :)
--
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
