https://bugs.freedesktop.org/show_bug.cgi?id=40975
Summary: Add "differentiation" function to Calc
Product: LibreOffice
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: enhancement
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Well, I was thinking last night about this feature. And I think it could be
very useful.
For those who don't know what I'm talking about:
http://en.wikipedia.org/wiki/Numerical_differentiation
It could work *only* on cells with formulaes, in this way:
Supose
A1 = 5
B1 = 6
C1 = 2.5
D1= A1*B1^2*ln(C1) = 164.93....
then, one could add de "diff" function
A2 = diff(D1,A1) = 32.99 (becase the result should be the evaluation of
B1^2*ln(C1))
B2 = diff(D1,B1) = 54.98 (because the result should be 2*A1*B1*ln(C1)
and so on...
And it doesn't need to end there, there could be higher order derivatives, for
example
B3 = diff(D1,B1,2) = 9.16 (= 2*A1*ln(C1) )
C3 = diff(D1,C1,3) = 3.84 (2*A1*B1/C1^3)
What do you think? I'm one of those who would like to have this feature a lot.
--
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
