[Libreoffice] [PATCH] CSC, SEC, CSCH & SECH Help missing, How to add one? ref: bug fdo#44792

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Please find the patch attached.

Best regards

Olivier

Em 30-01-2012 05:56, Jan Holesovsky escreveu:
> Hi Olivier,
>
> Olivier Hallot píše v Pá 27. 01. 2012 v 12:14 -0200:
>
> > How can I write a help file to fix
> >
> > https://bugs.freedesktop.org/show_bug.cgi?id=44792
> >
> > (help for new math function CSC, CSCH, SEC, SECH..)
> >
> > I can write it easily, but I need a tool to generate the xml for the
> > help file.
>
> The best is to edit it just with a plain text editor, like vim or emacs
> (or your favorite tool), so that you avoid the xml editor messing with
> the rest of the file.  Of course, maybe there are good xml editors out
> there that do not modify the part of the file you don't touch, but I
> don't have any experience with any myself.
>
> > My plan is to add the help in the file
> >
> > /help/helpcontent2/source/text/scalc/01/04060106.xhp
> >
> > where other mathematical functions are described (SIN, COS, etc...)
>
> Sounds like a good place to edit; I'd just copy & paste eg. the SIN
> description, and modify it for CSC etc.
>
> The paragraph id's should be distinct in at least the file, and you
> probably also want to test the hid/SC_HID_FUNC_* where it is used (as
> the help identifier for the other functions), and if it works for your
> new entries.
>
> There might be other catches I don't see without actually trying that,
> hopefully not ;-)  But if they are, please share them with the list.
>
> Thanks for looking into this!
>
> Regards,
> Kendy

- -- 
Olivier Hallot
Founder, Board of Directors Member - The Document Foundation
LibreOffice translation leader for Brazilian Portuguese
+55-21-8822-8812
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJPJqU/AAoJEJp3R7nH3vLxHcYH/i3HVPA2pfGop5l5yDvffq6S
NLOuLIGhl3uml4pLkAPu/tMqUKvnop+Jsl1RB3hS0ZXgiNTv7ARB+Zm1xGVR7s1i
JQ5vEHdk6pT4LYvJh3rJ/ydrrJZ0UZ1YOpNjkIeRLCHBuTHX7+Nakt1UzZhwR2Go
PLh2NUqCvp1oW7Sf4iUTus0VA9DfbjDc5FD4Da/n2ZiB0CxrMykJUsa2gmjVAlOC
yP2dAWixF/YaU+rysRNMqhmJpOmkS2d25dRD76vctq23joJBC8GZXlu+AjxNdPGy
lp6dkaY+zx99FqmEz+YNaO8D5zX8razuuhFtMgMNOcwuMPn1+BS0IM+lPSGkYlE=
=1xkn
-----END PGP SIGNATURE-----

From ae40a9269b58c78534c6732acd1b47bd3b785b1d Mon Sep 17 00:00:00 2001
From: Olivier Hallot <olivier.hallot@alta.org.br>
Date: Mon, 30 Jan 2012 12:08:00 -0200
Subject: [PATCH] fix for fdo#44972, LOCALHELP for CSC,CSCH,SEC,SECH

LOCALHELP missing for the new Calc functions: SEC, CSC, SECH, CSCH
---
 helpcontent2/source/text/scalc/01/04060106.xhp |   74 ++++++++++++++++++++++++
 1 files changed, 74 insertions(+), 0 deletions(-)

diff --git a/helpcontent2/source/text/scalc/01/04060106.xhp 
b/helpcontent2/source/text/scalc/01/04060106.xhp
index 6e7ef0f..a272e1d 100644
--- a/helpcontent2/source/text/scalc/01/04060106.xhp
+++ b/helpcontent2/source/text/scalc/01/04060106.xhp
@@ -335,6 +335,43 @@ oldref="183">Example</paragraph>
 <item type="input">=COTH(1)</item> returns the hyperbolic cotangent of 1, approximately 
1.3130.</paragraph><comment>see also COSH, SINH, TANH,     
 ACOSH, ASINH, ATANH, ACOTH,   </comment>
 </section>
+<section id="Section64">
+<bookmark xml-lang="en-US" branch="index" id="bm_id6110552"><bookmark_value>CSC 
function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSECANT" id="bm_id5645316" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id9523234" role="heading" level="2" l10n="U"
+oldref="149">CSC</paragraph>
+<paragraph xml-lang="en-US" id="par_id4896433" role="paragraph" l10n="CHG" oldref="150"><ahelp 
hid="HID_FUNC_COSECANT">Returns the cosecant of the given angle (in radians). The cosecant is the 
inverse of the sine (= 1/sin(x))</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3534032" role="heading" level="3" l10n="U"
+oldref="151">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id4571344" role="code" l10n="U" 
oldref="152">CSC(Number)</paragraph>
+<paragraph xml-lang="en-US" id="par_id9859164" role="paragraph" l10n="CHG" oldref="153"> Returns 
the (trigonometric) cosecant of <emph>Number</emph>, the angle in radians.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3428494" role="paragraph" l10n="NEW">To return the cosecant 
of an angle in degrees, use the RADIANS function.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2577161" role="heading" level="3" l10n="U"
+oldref="154">Examples</paragraph>
+<paragraph xml-lang="en-US" id="par_id3736803" role="paragraph" l10n="U" oldref="155">
+<item type="input">=CSC(PI()/4)</item> returns approximately 1.4142135624, the inverse of the sine 
of PI/4 radians.</paragraph>
+<paragraph xml-lang="en-US" id="par_id6016818" role="paragraph" l10n="U" oldref="156">
+<item type="input">=CSC(RADIANS(30))</item> returns 2, the cosecant of 30 
degrees.</paragraph><comment>see also SIN, TAN, COT, SEC,
+ACOS, ASIN, ATAN, ATAN2, ACOT  </comment>
+</section>
+<section id="Section66">
+<bookmark xml-lang="en-US" branch="index" id="bm_id9288877"><bookmark_value>CSCH 
function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSECANTHYP" id="bm_id9532490" 
localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id4325650" role="heading" level="2" l10n="U"
+oldref="159">CSCH</paragraph>
+<paragraph xml-lang="en-US" id="par_id579916" role="paragraph" l10n="U" oldref="160"><ahelp 
hid="HID_FUNC_COSECANTHYP">Returns the hyperbolic cosecant of a number.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id5336768" role="heading" level="3" l10n="U"
+oldref="161">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3108851" role="code" l10n="U" 
oldref="162">CSCH(Number)</paragraph>
+<paragraph xml-lang="en-US" id="par_id1394188" role="paragraph" l10n="CHG" oldref="163">Returns 
the hyperbolic cosecant of <emph>Number</emph>. The hyperbolic cosecant is the inverse of the 
hyperbolic sine (= 1/sinh(x)) </paragraph>
+<paragraph xml-lang="en-US" id="hd_id6037477" role="heading" level="3" l10n="U"
+oldref="164">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id5426085" role="paragraph" l10n="CHG" oldref="165">
+<item type="input">=CSCH(1)</item> returns approximately 0.8509181282, the hyperbolic cosecant of 
1.</paragraph><comment>see also SINH, TANH, COTH, SECH,     
+ACOSH, ASINH, ATANH, ACOTH,   </comment>
+</section>
 <section id="Section48">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3145314"><bookmark_value>DEGREES 
function</bookmark_value>
 <bookmark_value>converting;radians, into degrees</bookmark_value>
@@ -934,6 +971,43 @@ oldref="146">Example</paragraph>
 <item type="input">=ROUNDUP(987.65;-2)</item> returns 1000.</paragraph><comment>see also INT, 
TRUNC, ROUND, ROUNDDOWN,    
 CEILING, FLOOR, EVEN, ODD, MROUND</comment>
 </section>
+<section id="Section63">
+<bookmark xml-lang="en-US" branch="index" id="bm_id5256537"><bookmark_value>SEC 
function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SECANT" id="bm_id6577644" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id5187204" role="heading" level="2" l10n="U"
+oldref="149">SEC</paragraph>
+<paragraph xml-lang="en-US" id="par_id9954962" role="paragraph" l10n="CHG" oldref="150"><ahelp 
hid="HID_FUNC_SECANT">Returns the secant of the given angle (in radians). The secant is the inverse 
of the cosine (= 1/cos(x))</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id422243" role="heading" level="3" l10n="U"
+oldref="151">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2055913" role="code" l10n="U" 
oldref="152">SEC(Number)</paragraph>
+<paragraph xml-lang="en-US" id="par_id9568170" role="paragraph" l10n="CHG" oldref="153"> Returns 
the (trigonometric) secant of <emph>Number</emph>, the angle in radians.</paragraph>
+<paragraph xml-lang="en-US" id="par_id9047465" role="paragraph" l10n="NEW">To return the secant of 
an angle in degrees, use the RADIANS function.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id9878918" role="heading" level="3" l10n="U"
+oldref="154">Examples</paragraph>
+<paragraph xml-lang="en-US" id="par_id6935513" role="paragraph" l10n="U" oldref="155">
+<item type="input">=SEC(PI()/4)</item> returns approximately 1.4142135624, the inverse of the 
cosine of PI/4 radians.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3954287" role="paragraph" l10n="U" oldref="156">
+<item type="input">=SEC(RADIANS(60))</item> returns 2, the secant of 60 
degrees.</paragraph><comment>see also SIN, TAN, COT, CSC,
+ACOS, ASIN, ATAN, ATAN2, ACOT  </comment>
+</section>
+<section id="Section65">
+<bookmark xml-lang="en-US" branch="index" id="bm_id840005"><bookmark_value>SECH 
function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SECANTHYP" id="bm_id6301347" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id8661934" role="heading" level="2" l10n="U"
+oldref="159">SECH</paragraph>
+<paragraph xml-lang="en-US" id="par_id408174" role="paragraph" l10n="U" oldref="160"><ahelp 
hid="HID_FUNC_SECANTHYP">Returns the hyperbolic secant of a number.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id875988" role="heading" level="3" l10n="U"
+oldref="161">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id4985391" role="code" l10n="U" 
oldref="162">SECH(Number)</paragraph>
+<paragraph xml-lang="en-US" id="par_id1952124" role="paragraph" l10n="CHG" oldref="163">Returns 
the hyperbolic secant of <emph>Number</emph>. The hyperbolic secant is the inverse of the 
hyperbolic cosine (= 1/cosh(x)) </paragraph>
+<paragraph xml-lang="en-US" id="hd_id9838764" role="heading" level="3" l10n="U"
+oldref="164">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id1187764" role="paragraph" l10n="CHG" oldref="165">
+<item type="input">=SECH(0)</item> returns 1, the hyperbolic secant of 0.</paragraph><comment>see 
also SINH, TANH, COTH, CSCH,     
+ACOSH, ASINH, ATANH, ACOTH,   </comment>
+</section>
 <section id="Section18">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3144877"><bookmark_value>SIN 
function</bookmark_value>
 </bookmark>
-- 
1.7.5.4