Bug 63446 - FORMATTING: formulas computed from currency cells always yield currency formatting
Summary: FORMATTING: formulas computed from currency cells always yield currency forma...
Status: RESOLVED DUPLICATE of bug 60775
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.2.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-04-12 02:23 UTC by Scott Quick
Modified: 2013-04-18 02:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***