summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060185.xhp
AgeCommit message (Collapse)Author
2022-12-19Fix duplicate IDs in non-localized contentIlmari Lauhakangas
Change-Id: I759b05a2ba10671700c9222f54e61edf39f5baff Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144538 Tested-by: Jenkins Tested-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2022-12-07tdf#152323 drop name attribute from <link> elementsIlmari Lauhakangas
Replacement done with find . -name \*.xhp -print0 |xargs -0 -P 0 perl -CS -pi -e \ 's#(<link[^>]*?) +name *="[^"]*" *( [^>]+|) *>#$1$2>#g' (note some inconsistencies with space between name and = and also having empty value, and some more complicated expression to also clear up double space before/after the attribute) translation files will be prepped with: find */helpcontent2 -name \*.po -print0 |xargs -0 -P 0 perl -CS -pi -e \ $'s#(<link[^>]*?) +name=(?:\\\\"[^"]*\\\\"|\'[^\']*\') *( [^>]+|) *(/?>)#$1$2$3#g unless /^#/' (note that not all languages use the " as quote character for the attributes, but that also single quotes appera in the po file. Hence the use of the shell $'string' syntax to be able to quote ' as \' It also requires to quote the backslash, so that it needs to be escaped once for the shell, then another time for perl. Also don't work on obsolete strings (those are prefixed with #~ in the po files) Also note that <link..></link> gets turned into <link ../> during translation extraction (along with removal of the space between the attribute name and the value), so the pattern needs to be slightly different here) Change-Id: I95e53a08e6b0095cd894109ea0de154cc4859d8f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143713 Tested-by: Jenkins Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
2022-01-01tdf#94537 COM.MICROSOFT.* namespace informationOlivier Hallot
+ Covered all COM.MICROSOFT namespace of wiki page in the bug report. + refactor of other info such as release number availability. + Muted l10N in a table and drop duplication. Change-Id: Id77f9657f164193d5e672e9edf82a2170b5f4040 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127817 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2021-12-31tdf#94537 Inform user of non-ODFF functions (part)Olivier Hallot
Open for discussion and contents improvement, other patches will follow once this is approved. - used embed to reduce translation workload - un-localize function name space Change-Id: Iab42e87754d5b9b0c3d2a248af82e297ec73ea7c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127751 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-04-15Fix sort order of Calc functionsOlivier Hallot
Change-Id: I8237b0d52b8b0f29fc35196d34648ed7b51669d1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114113 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-03-27tdf#137715 add "text in data range" note to statistical functionsSeth Chaiklin
( scalc/01/04060181.xhp ) COUNT ( scalc/01/04060182.xhp ) FTEST, GEOMEAN, HARMEAN, TRIMMEAN, ZTEST ( scalc/01/04060183.xhp ) KURT, LARGE, SMALL ( scalc/01/04060185.xhp ) DEVSQ, STDEVP, VAR, VARP, RANK, SKEW, STDEV ( scalc/01/func_skewp.xhp ) SKEWP Change-Id: I4ddfadff93bb39ff426f8d6887009cdf6c261e08 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113218 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
2020-06-01(04060185.xhp) Include square brackets in syntax sections to indicate ↵Steve Fanning
optional parameters. Change-Id: I8d099d9babe118c7592b060027dd037e9fbdadaf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95245 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-30Remove empty heading.Olivier Hallot
Change-Id: Icca557cbe9ebcfe5004e1707835ecf4fdfbd5a05 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91365 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-26tdf#131361 Adjust number of function parameters (3)Steve Fanning
Fix for STDEV, STDEV.P, STDEV.S, STDEVA, STDEVP, STDEVPA, VAR, VAR.P, VAR.S, VARA, VARP, VARPA, AND, OR, XOR, SUMPRODUCT, CONCATENATE Change-Id: I869f6d7fc687e645b9ee8c0ca36ff690c4108db3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91103 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-26tdf#131361 Adjust number of function parameters (2)Steve Fanning
Fixes for MAX, MAXA, MEDIAN, MIN, MINA, MODE, MODE.MULT MODE.SNGL, SKEW, SKEWP Change-Id: I2a8727611cf0f9cfeed9f7dbcd88751c81090e46 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91077 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-25tdf#131361 Adjust number of function parametersSteve Fanning
Fixes for SUM, SUMSQ, NPV, AVEDEV, AVERAGE, AVERAGEA COUNT, COUNTA, DEVSQ, KURT Change-Id: I1227064ed343ccccd5a339cce7425b5143072537 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91013 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-04-27tdf#123803 Add release info in Calc functionsOlivier Hallot
Change-Id: I0476c79fe5407c3e7252ef16da4110a026b29fa8 Note: some Calc functions still lack help pages. Reviewed-on: https://gerrit.libreoffice.org/71331 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-10-02Reduce L10N workload for repetitive stringsOlivier Hallot
Change 'Syntax' and 'Examples' heading into an embedded string translated only once. Change-Id: Iac2eef8fedbaa4461aa2f941af7f065a3b16fb2d Reviewed-on: https://gerrit.libreoffice.org/61143 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-23Improve formatting in help text.Sophia Schröder
Change-Id: I873128ed6353caf37f063a87361bd0a6f7c79f96 Reviewed-on: https://gerrit.libreoffice.org/53321 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-16replace http links with https equivalentsdennisroczek
* mainly http://wiki.documentfoundation.org * http://en.wikipedia.org * http://api.libreoffice.org Change-Id: I3587d8d5e6a6de4a7c7013920b9e135e4adc977c Reviewed-on: https://gerrit.libreoffice.org/52354 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-12tdf#94438 Fix dup bookmark branchesOlivier Hallot
Part 1, Calc files Change-Id: I9a3c1d8f6afac7e693590be9220e811b07d6fd28 Reviewed-on: https://gerrit.libreoffice.org/52793 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-05-30Mass remove excess spaces from inside tagsGabor Kelemen
This is fallout from the l10n and oldref attribute removal. Some tags were broken into two rows and the second was indented with spaces. The line break was removed along the tags, but those spaces were not. Command I used to catch these: find source/text/ -name "*xhp" | xargs sed -i -e 's#\" *>#\">#g' Change-Id: I6f9bad46cbfb7416950bee8230e358a3dd851def Reviewed-on: https://gerrit.libreoffice.org/37791 Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> Tested-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
2017-05-09remove obsolete oldref attribute (removes one context line in pot)Christian Lohmaier
also remove obsolete l10n attribute (doesn't affect translations/pot) Change-Id: I809866ea7b16cb1cacad9efacb6fdeebae38ea9f
2016-07-24fix function name in syntax for FORECAST.LINEARStanislav Horacek
Change-Id: Ibbaadef2e51ad71d819df993ccbee9b124243054 Reviewed-on: https://gerrit.libreoffice.org/27466 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-03-09"embed" is not a valid child of "paragraph"Christian Lohmaier
Change-Id: Ic0b57adaaa4124f22a669e5df0c95c3fd03e606e
2016-03-09tdf#97021 Help pages for FORECAST.ETS functionsOlivier Hallot
Write help page for FORECAST.ETS.* Calc functions Change-Id: I4fc3a0f18bb09e033b011206c41bec841e0d01f5 Reviewed-on: https://gerrit.libreoffice.org/23093 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2016-02-16tdf#95281 Help page for the SKEWP functionOlivier Hallot
Write help page for SKEWP spreadsheet function Change-Id: Ib7fc372bc2be4c55663a6ab58f488aa204631d20 Reviewed-on: https://gerrit.libreoffice.org/22322 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
2015-01-22T.INV returns one-tailed, not two-tailed valuesStanislav Horacek
Change-Id: Icc5b44667068543c4513410c954370895f2a3820 Reviewed-on: https://gerrit.libreoffice.org/14093 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2015-01-05correct title for RANK.EQ functionStanislav Horacek
Change-Id: I6a438a909f082f16821b942ccdacdd5cc3374800 Reviewed-on: https://gerrit.libreoffice.org/13756 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
2014-09-21Correct typo of STEYX exampleLaurent Balland-Poirier
Change-Id: I4864cb3366dd12f2484b614e9ca418cad2440a71 Reviewed-on: https://gerrit.libreoffice.org/11556 Reviewed-by: Joren De Cuyper <jorendc@libreoffice.org> Tested-by: Joren De Cuyper <jorendc@libreoffice.org>
2014-09-05Fix fdo#80435: help pages for Calc new functionsOlivier Hallot
Quartile, percentile, percentrank, rank. Change-Id: I0cbc75a1f915898839223ab72be471926ab025c4 Reviewed-on: https://gerrit.libreoffice.org/11142 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2014-07-27Fix fdo#80444: Help pages fo STDEV functionsOlivier Hallot
help page for STDEV.P and STDEV.S Change-Id: Iab0cd53f0cdda84e1331a204c74f08c154e9589b Reviewed-on: https://gerrit.libreoffice.org/10568 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
2014-07-27Fix fdo#80445, help pages for VAR functionsOlivier Hallot
VAR.P and VAR.S Change-Id: I6c7204c425678810b6383c59f3c6d2e791c26977 Reviewed-on: https://gerrit.libreoffice.org/10560 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
2014-07-21Fix fdo#80433 help pages for new T functionsOlivier Hallot
T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T and T.TEST Change-Id: I65fc995e0131cfcc528d64984ceafed25cd74fbc Reviewed-on: https://gerrit.libreoffice.org/10426 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2014-07-21Fix fdo#80451: New DIST functions from ExcelOlivier Hallot
EXPON.DIST, HYPGEOM.DIST, POISSON.DIST and WEIBULL.DIST Change-Id: I10ca3013e430c53a03d4795d0c47cbaaeb7b9adb Reviewed-on: https://gerrit.libreoffice.org/10423 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2014-06-27Fix fdo#80432. Help entries for NORM functionsOlivier Hallot
Write help pages for LOGNORM.DIST, LOGNORM.INV, NORM.DIST, NORM.INV, NORM.S.DIST and NORM.S.INV spreadsheet functions Change-Id: I00f92dd339c6485f2f7b809f2e441241cde5a9d7 Reviewed-on: https://gerrit.libreoffice.org/9925 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2014-02-04STDEVP and STDEVPA functions are based on an entire populationStanislav Horacek
Change-Id: Ieb1aa2e956061ce72afc2d5d804b95dabd20c4c8 Reviewed-on: https://gerrit.libreoffice.org/7552 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2012-12-13re-base on ALv2 code. Includes:Michael Meeks
Patch contributed by Oliver Rainer-Wittmann i#118572 - remove ui string and help content regarding usage of Java Mail in Writer's Mail Merge as Java Mail is not used. http://svn.apache.org/viewvc?view=revision&revision=1197035 Patches contributed by Herbert Duerr updated help text for regexp word boundaries http://svn.apache.org/viewvc?view=revision&revision=1228026 improved help text for word boundary regexp expression \b http://svn.apache.org/viewvc?view=revision&revision=1234738 Patches contributed by Jurgen Schmidt remove onlineregistration with dependencies http://svn.apache.org/viewvc?view=revision&revision=1240245 Patch contributed by Regina Henschel Extended tips for corner and cap style http://svn.apache.org/viewvc?view=revision&revision=1242287 * re-enable on-line update help, remove obsolete on-line purchasing.
2012-10-16move help structure one directory upNorbert Thiebaud
Change-Id: Ie970e39fbb6795a92d9fdd13510409d7dcd071bc