Revision as of 15:00, 26 November 2013 (view source) Elish (Talk | contribs) (add bug 105612) ← Older edit		Revision as of 15:05, 26 November 2013 (view source) Elish (Talk | contribs) (replace description with reference) Newer edit →
Line 89:		Line 89:
−	Formerly bug 105612	+	Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=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 "&"  -->  "&amp;" "<"  -->  "&lt;" ">"  -->  "&gt;"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]]	+	See Bugzilla description.

---

Revision as of 15:05, 26 November 2013

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 [1]

See Bugzilla description.