Difference between revisions of "Extensions/Ideas/Calc"
(add bug 117659) |
(add bug 105612) |
||
Line 85: | Line 85: | ||
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 | 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 | ||
− | [[Category:Extensions]] | + | |
+ | == Provide a RICHTEXT() function for dynamic text formatting of formula output in cells== | ||
+ | |||
+ | |||
+ | Formerly bug 105612 | ||
+ | |||
+ | Provide a function called 'RICHTEXT()' for use in cell formulas in OOo Calc ,that will take one string argument possibly containing html-like tags, andreturn the plain text stripped of all the tags -- and, when used as atop-level function in a cell formula, will cause the returned text to beformatted inside the cell according to those HTML-like tags. For example, a cellwith the following cell formula would then show the text "Title (subtitle)" withnice bold/italic formatting: =RICHTEXT("<b>Title</b> (<i>subtitle</i>)")The internal value of the cell, for example when referenced by another formula,would however just be the plain string "Title (subtitle)".At a minimum, the tags <b>, <i>, <u>, <color> and <size> (or however you wish toname them) should be supported.This would allow for much much greater flexibility and convenience for designingvisually pleasing dynamic spreadsheets, compared to the rather limited andreally cumbersome to use 'STYLE()' function and 'conditional formatting' feature.(Note: Maybe it would then make sense to also introduce a 'MASK()' function,that will augment a given string in such a way that 'RICHTEXT()' won't interpretany part of it as formatting tags -- for example, by making the replacements "&" --> "&" "<" --> "<" ">" --> ">"which 'RICHTEXT()' would then convert back to the original characters in it'splain text output. This would then allow to safely write, for example: =RICHTEXT("<b>For bold text use the tag:</b> " & MASK("<b>")which would display the string "For bold text use the tag: <b>" inside the cell,with partially bold formatting of course.)[[Category:Extensions]] |
Revision as of 15:00, 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
Provide a function called 'RICHTEXT()' for use in cell formulas in OOo Calc ,that will take one string argument possibly containing html-like tags, andreturn the plain text stripped of all the tags -- and, when used as atop-level function in a cell formula, will cause the returned text to beformatted inside the cell according to those HTML-like tags. For example, a cellwith the following cell formula would then show the text "Title (subtitle)" withnice bold/italic formatting: =RICHTEXT("Title (subtitle)")The internal value of the cell, for example when referenced by another formula,would however just be the plain string "Title (subtitle)".At a minimum, the tags , , , <color> and <size> (or however you wish toname them) should be supported.This would allow for much much greater flexibility and convenience for designingvisually pleasing dynamic spreadsheets, compared to the rather limited andreally cumbersome to use 'STYLE()' function and 'conditional formatting' feature.(Note: Maybe it would then make sense to also introduce a 'MASK()' function,that will augment a given string in such a way that 'RICHTEXT()' won't interpretany part of it as formatting tags -- for example, by making the replacements "&" --> "&" "<" --> "<" ">" --> ">"which 'RICHTEXT()' would then convert back to the original characters in it'splain text output. This would then allow to safely write, for example: =RICHTEXT("<b>For bold text use the tag:</b> " & MASK("<b>")which would display the string "For bold text use the tag: <b>" inside the cell,with partially bold formatting of course.)