Ideas for Apache OpenOffice Calc, Writer
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
- 1.13 ASAP Utilities
- 1.14 Linear interpolation
- 1.15 Statistical summary tool
- 1.16 Image metadata function
- 1.17 Series function
- 1.18 Increased date range
- 1.19 RLPlot
- 1.20 CellMaster
- 1.21 Quandl
- 1.22 Functions to return first or last non null value
- 1.23 Formula comparison
- 1.24 Export as MediaWiki
- 1.25 Copy/Paste CSV file
- 2 Writer Add-ins
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.
ASAP Utilities
Formerly bug 122837
http://www.asap-utilities.com/about-asap-utilities.php
Linear interpolation
Formerly bug 95135 See Bugzilla description.
Statistical summary tool
Formerly bug 89980 See Bugzilla description.
Image metadata function
Formerly bug 112459 See Bugzilla description.
Series function
Formerly bug 108640 A function to create and print brief series in calc!
Increased date range
Formerly 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 bug 81726
http://rlplot.sourceforge.net/index.html
CellMaster
Formerly bug 123916
http://www.cellmaster.com.au/Demo.html
Quandl
Formerly bug 122608
Functions to return first or last non null value
Formerly bug 108441
Formula comparison
Formerly bug 109178
Export as MediaWiki
Formerly bug 102704
Copy/Paste CSV file
Formerly bug 91425
Writer Add-ins
Revision history as auto generated index
Formerly bug 49963
Per-session statistics
Formerly bug 16121
PDF Merging
Formerly bug 75470
Report builder
Formerly bug 108115
transliteration
Formerly bug 17881