Difference between revisions of "Extensions/Ideas/Calc"

From Apache OpenOffice Wiki
Jump to: navigation, search
(add bug 105612)
(+cat)
 
(22 intermediate revisions by one other user not shown)
Line 1: Line 1:
−
{{DISPLAYTITLE:Ideas for Apache OpenOffice Calc}}
+
{{DISPLAYTITLE:Ideas for Apache OpenOffice Calc, Writer}}
  
 
= Calc Add-ins =
 
= Calc Add-ins =
Line 88: Line 88:
 
== Provide a RICHTEXT() function for dynamic text formatting of formula output in cells==
 
== 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]
  
−
Formerly bug 105612
+
See Bugzilla description.
  
−
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]]
+
== 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]
 +
 
 +
[[Category:Extensions]]

Latest revision as of 17:16, 14 July 2014


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

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Extensions/Ideas/Calc&oldid=235432"
Personal tools