Apache OpenOffice Wiki - User contributions [en]

Extensions/Ideas/Calc

2014-04-14T12:29:29Z

Elish: add bug 17881

{{DISPLAYTITLE:Ideas for Apache OpenOffice Calc, Writer}}

= Calc Add-ins =

== Function to return roots of quadratic equation ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=122171 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 [https://issues.apache.org/ooo/show_bug.cgi?id=122202 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 [https://issues.apache.org/ooo/show_bug.cgi?id=105612 bug 105612]

See Bugzilla description.

== ASAP Utilities ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=122837 bug 122837]

http://www.asap-utilities.com/about-asap-utilities.php

== Linear interpolation ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=95135 bug 95135]
See Bugzilla description.

== Statistical summary tool ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=89980 bug 89980]
See Bugzilla description.

== Image metadata function ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=112459 bug 112459]
See Bugzilla description.

== Series function ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=108640 bug 108640]
A function to create and print brief series in calc!

== Increased date range ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=92996 bug 92996]

Increase date handling range to year 1000 with option for users to enter date atwhich calendars changed between Julian and Gregorian and by how much (e.g. UK1752 by 30 days)

== RLPlot ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=81726 bug 81726]

http://rlplot.sourceforge.net/index.html

== CellMaster ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=123916 bug 123916]

http://www.cellmaster.com.au/Demo.html

== Quandl ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=122608 bug 122608]

== Functions to return first or last non null value ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=108441 bug 108441]

== Formula comparison ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=109178 bug 109178]

== Export as MediaWiki ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=102704 bug 102704]

== Copy/Paste CSV file ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=91425 bug 91425]

= Writer Add-ins =

== Revision history as auto generated index ==
Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=49963 bug 49963]

== Per-session statistics ==
Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=16121 bug 16121]

== PDF Merging ==
Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=75470 bug 75470]

== Report builder ==
Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=108115 bug 108115]

== transliteration ==
Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=17881 bug 17881]

Extensions/Ideas/Calc

2014-04-02T19:18:54Z

Elish: add bug 108115

Extensions/Ideas/Calc

2014-03-25T13:18:51Z

Elish: add bug 75470

Extensions/Ideas/Calc

2014-03-24T13:28:25Z

Elish: add bug 16121

Extensions/Ideas/Calc

2014-03-20T18:52:27Z

Elish:

Extensions/Ideas/Calc

2014-03-20T18:51:35Z

Elish:

{{DISPLAYTITLE:Ideas for Apache OpenOffice Calc}}

= Calc Add-ins =

== Function to return roots of quadratic equation ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=122171 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 [https://issues.apache.org/ooo/show_bug.cgi?id=122202 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 [https://issues.apache.org/ooo/show_bug.cgi?id=105612 bug 105612]

See Bugzilla description.

== ASAP Utilities ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=122837 bug 122837]

http://www.asap-utilities.com/about-asap-utilities.php

== Linear interpolation ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=95135 bug 95135]
See Bugzilla description.

== Statistical summary tool ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=89980 bug 89980]
See Bugzilla description.

== Image metadata function ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=112459 bug 112459]
See Bugzilla description.

== Series function ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=108640 bug 108640]
A function to create and print brief series in calc!

== Increased date range ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=92996 bug 92996]

Increase date handling range to year 1000 with option for users to enter date atwhich calendars changed between Julian and Gregorian and by how much (e.g. UK1752 by 30 days)

== RLPlot ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=81726 bug 81726]

http://rlplot.sourceforge.net/index.html

== CellMaster ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=123916 bug 123916]

http://www.cellmaster.com.au/Demo.html

== Quandl ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=122608 bug 122608]

== Functions to return first or last non null value ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=108441 bug 108441]

== Formula comparison ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=109178 bug 109178]

== Export as MediaWiki ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=102704 bug 102704]

== Copy/Paste CSV file ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=91425 bug 91425]

= Writer Add-ins =

== Revision history as auto generated index ==
Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=49963 bug 49963]

Extensions/Ideas/Calc

2014-01-16T12:53:41Z

Elish: add bug 91425

Extensions/Ideas/Calc

2014-01-14T13:28:00Z

Elish: add bug 102704

Extensions/Ideas/Calc

2014-01-13T17:20:28Z

Elish: add bug 109178

Extensions/Ideas/Calc

2014-01-10T12:17:03Z

Elish: add bug 108441

Extensions/Ideas/Calc

2014-01-07T18:58:41Z

Elish: add bug 122608

Extensions/Ideas/Calc

2013-12-27T09:23:15Z

Elish: add bug 123916

Extensions/Ideas/Calc

2013-12-25T18:26:32Z

Elish: add bug 81726

Extensions/Ideas/Calc

2013-12-25T13:54:14Z

Elish: /* Increased date range */

Extensions/Ideas/Calc

2013-12-25T13:53:40Z

Elish: add bug 92996

{{DISPLAYTITLE:Ideas for Apache OpenOffice Calc}}

= Calc Add-ins =

== Function to return roots of quadratic equation ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=122171 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 [https://issues.apache.org/ooo/show_bug.cgi?id=122202 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 [https://issues.apache.org/ooo/show_bug.cgi?id=105612 bug 105612]

See Bugzilla description.

== ASAP Utilities ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=122837 bug 122837]

http://www.asap-utilities.com/about-asap-utilities.php

== Linear interpolation ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=95135 bug 95135]
See Bugzilla description.

== Statistical summary tool ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=89980 bug 89980]
See Bugzilla description.

== Image metadata function ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=112459 bug 112459]
See Bugzilla description.

== Series function ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=108640 bug 108640]
A function to create and print brief series in calc!

== Increased date range ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=92996 bug 92996]

Increae date handling range to year 1000 with option for users to enter date atwhich calendars changed between Julian and Gregorian and by how much (e.g. UK1752 by 30 days)

Extensions/Ideas/Calc

2013-12-20T12:51:43Z

Elish: add bug 108640

Extensions/Ideas/Calc

2013-12-19T12:32:26Z

Elish: add bug 112459

Extensions/Ideas/Calc

2013-12-13T11:22:25Z

Elish: add bug 89980

Extensions/Ideas/Calc

2013-12-13T11:11:51Z

Elish: add bug 95135

Extensions/Ideas/Calc

2013-12-10T18:14:47Z

Elish: add bug 122837

Extensions/Ideas/Calc

2013-11-26T15:06:25Z

Elish: add bug number

Extensions/Ideas/Calc

2013-11-26T15:05:27Z

Elish: replace description with reference

Extensions/Ideas/Calc

2013-11-26T15:00:23Z

Elish: add bug 105612

{{DISPLAYTITLE:Ideas for Apache OpenOffice Calc}}

= Calc Add-ins =

== Function to return roots of quadratic equation ==

Formerly [https://issues.apache.org/ooo/show_bug.cgi?id=122171 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 [https://issues.apache.org/ooo/show_bug.cgi?id=122202 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("For bold text use the tag: " & MASK("")which would display the string "For bold text use the tag: " inside the cell,with partially bold formatting of course.)[[Category:Extensions]]

Extensions/Ideas/Calc

2013-10-06T07:24:39Z

Elish: add bug 117659

Extensions/Ideas/Calc

2013-05-24T14:31:03Z

Elish:

Extensions/Ideas/Calc

2013-05-14T15:31:46Z

Elish:

Extensions/Ideas/Calc

2013-05-14T15:30:11Z

Elish:

Extensions/Ideas/Calc

2013-05-13T19:32:31Z

Elish:

Extensions/Ideas/Calc

2013-05-13T12:21:09Z

Elish:

Extensions/Ideas/Calc

2013-05-13T12:17:50Z

Elish:

Extensions/Ideas/Calc

2013-05-12T15:22:53Z

Elish:

Extensions/Ideas/Calc

2013-05-12T09:28:43Z

Elish:

Extensions/Ideas/Calc

2013-05-12T09:02:47Z

Elish:

Extensions/Ideas/Calc

2013-05-12T09:01:11Z

Elish:

Extensions/Ideas/Calc

2013-05-11T18:50:10Z

Elish:

Function to return roots of quadratic equation (formerly bug 122171) 
Numerical integration - Simpson's rules (formerly bug 122202)

Extensions/Ideas/Calc

2013-05-11T18:49:21Z

Elish:

Function to return roots of quadratic equation (formerly bug 122171)
Numerical integration - Simpson's rules (formerly bug 122202)

Extensions/Ideas/Calc

2013-05-11T18:45:44Z

Elish: Created page with "Function to return roots of quadratic equation (formerly bug 122171)"

Function to return roots of quadratic equation (formerly bug 122171)