Bug 63446

Summary: FORMATTING: formulas computed from currency cells always yield currency formatting
Product: LibreOffice Reporter: Scott Quick <scott.quick.001>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: jmadero.dev
Priority: medium    
Version: 4.0.2.2 release   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Scott Quick 2013-04-12 02:23:36 UTC 
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!! :)
Comment 1 Joel Madero 2013-04-18 02:53:21 UTC 

*** This bug has been marked as a duplicate of bug 60775 ***