Difference between revisions of "Extensions/Ideas/Calc"
(replace description with reference) |
(add bug number) |
||
Line 89: | Line 89: | ||
− | Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=105612] | + | Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=105612 bug 105612] |
See Bugzilla description. | See Bugzilla description. |
Revision as of 15:06, 26 November 2013
Contents
- 1 Calc Add-ins
- 1.1 Function to return roots of quadratic equation
- 1.2 Numerical integration - Simpson's rules
- 1.3 Function to return astrological sign
- 1.4 Function to return calling code
- 1.5 Function to return chemical compound formula
- 1.6 Resistor color code calculator
- 1.7 Newton Raphson solver
- 1.8 Secant solver
- 1.9 Function to return RAL color
- 1.10 Thunderbird contacts
- 1.11 Create a function to find out the background color of a cell
- 1.12 Provide a RICHTEXT() function for dynamic text formatting of formula output in cells
Calc Add-ins
Function to return roots of quadratic equation
Formerly bug 122171
Quadratic equation ax^2+bx+c=0
Proposed added function:
- quadratic(a,b,c,1) will return (-b+sqrt(b^2-4ac))/(2a)
- quadratic(a,b,c,2) will return (-b-sqrt(b^2-4ac))/(2a)
- error if complex root
Numerical integration - Simpson's rules
Formerly bug 122202
Given: equally spaced x values, x0 till xn and respective function values in two columns
- Three points n=2: Simpson's 1/3 ruleFunction
Simp13 = (x2-x0)*(f(x0)+4f(x1)+f(x2))/6
- Four points n=3: Simpson's 3/8 ruleFunction
Simp38 = (x3-x0)*(f(x0)+3f(x1)+3f(x2)+f(x3))/8
- Five points n=4: Simpson's 1/3 rule on first and last three points
- Six points n=5: Simpson's 1/3 rule on first three points and Simpson's 3/8 rule on last last four points
- etc.
Function to return astrological sign
Proposed added function:
- astrosign(19/07/2013)=Cancer
Function to return calling code
Proposed added function:
- callcode(Colombia)=57
Function to return chemical compound formula
Proposed added function:
- chemform(water)=H2O
Resistor color code calculator
Proposed added function:
- rescol(brown,red,orange)=12000 (ohm)
Newton Raphson solver
Proposed added function: given f(x)=0, d/dx(f(x))
- newraph(x,f(x),d/dx(f(x)),eps)=x-f(x)/(d/dx(f(x))
eps=convergence criteria
Secant solver
Proposed added function: given f(x)=0 (unlike Newton Raphson, function derivative not given)
- secant(x_i-1,x_i,f(x),eps)=x_i-(f(x_i)*(x_i-1-x_i))/(f(x_i-1)-f(x_i))
eps=convergence criteria
Function to return RAL color
Proposed added function:
- ral(2004) will color selection in "pure orange"
see link: https://www.ral-farben.de/uebersicht-ral-classic-farben.html?&L=1
Thunderbird contacts
Extension to make a list of contacts in Thunderbird.
Create a function to find out the background color of a cell
I would like there to be a function that returns the background color of a cell. If the color is best described as an RGB set (0-255, or whatever), then there can be three arguments (location & RGB color).ie: bgcolor(row,column,RGBcolor) -returns the component (0-255) of the cell(row,column)so =color(25,16,RED) would return the RED component of cell(25,16). If the argument RED isn't a defined constant, simply establish a standard code (RED=1, GREEN=2, BLUE=3)Thanks,Will
Provide a RICHTEXT() function for dynamic text formatting of formula output in cells
Formerly bug 105612
See Bugzilla description.