summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)Author
2017-01-02Fix validation errors against xmlhelp.dtdAndras Timar
Change-Id: I453fb62f45b445b360d4722db83023a633053fb8 Reviewed-on: https://gerrit.libreoffice.org/32437 Reviewed-by: Andras Timar <andras.timar@collabora.com> Tested-by: Andras Timar <andras.timar@collabora.com> Reviewed-on: https://gerrit.libreoffice.org/32440 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2016-12-08tdf#104410 'Insert - Names' moved and renamedGabor Kelemen
Now this menu item is 'Sheet - Named Ranges and Expressions' Change-Id: I82113ef2e969cd2409fe114a51789e030752cdc0 Reviewed-on: https://gerrit.libreoffice.org/31700 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com> (cherry picked from commit eb91fb0313b9e9f3b1276502aebf77ca8ff6c115) Reviewed-on: https://gerrit.libreoffice.org/31742 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2016-11-30tdf#103241 Link XIRR and IRR as well as XNPV and NPV to each otherGabor Kelemen
Change-Id: I3a2697d8a71d78042721ff963476e4f592cb7e62 Reviewed-on: https://gerrit.libreoffice.org/31191 Reviewed-by: Andras Timar <andras.timar@collabora.com> Tested-by: Andras Timar <andras.timar@collabora.com> Reviewed-on: https://gerrit.libreoffice.org/31422
2016-11-27tdf#103968 'Link to External Data' is now in the Sheet menuGabor Kelemen
Change-Id: If8b69923ff8e6e9ed2ab03c72330665c6ef788d5 Reviewed-on: https://gerrit.libreoffice.org/31189 Reviewed-by: Andras Timar <andras.timar@collabora.com> Tested-by: Andras Timar <andras.timar@collabora.com> (cherry picked from commit 565f827138ee50a0754de1e0c9d9d16feb28076f) Reviewed-on: https://gerrit.libreoffice.org/31260 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2016-11-11small refinements and cosmetic changestagezi
corrected mistakes in the examples pushed back signs of equality from numbers made refinements warning of error Change-Id: I07194c563cf22d5b1b8254f77579f12461362a15 Reviewed-on: https://gerrit.libreoffice.org/30782 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2016-11-10Remove embeds of the description of the Edit - Plug-in menu itemGabor Kelemen
Change-Id: I57c83a56de0fe124f168adbcb7c4a3fdbd45d60d Reviewed-on: https://gerrit.libreoffice.org/30734 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2016-11-08fix invalid xmlAndras Timar
Change-Id: I15ed980578006e5ef55e0983d1683b001baa39f2
2016-11-08tdf#103397 - added example for Transpose functionJoel Madero
Added a simple example to the help for transpose() function Added tablehead style to example rows/columns Change-Id: I464983d480cb237a53e033005057a1faef0b9193 Reviewed-on: https://gerrit.libreoffice.org/30334 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2016-11-06tdf#103244 adjust menu path to Tools - Protect Sheet/SpreadsheetStanislav Horacek
Change-Id: I5993052af55e681c19b15f8e08f22b36d15e1e65 Reviewed-on: https://gerrit.libreoffice.org/30614 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2016-10-31update description of Find and Replace dialogStanislav Horacek
Change-Id: I40af15d57e568eebdb5fe145e6a8bc9c8d6845b0 Reviewed-on: https://gerrit.libreoffice.org/30396 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2016-10-25tdf#80439 add bookmark for WORKDAYS.INTLOlivier Hallot
Change-Id: Ie037f01f97d81bf194ad1b774dd3f13d6f9e86d9 Reviewed-on: https://gerrit.libreoffice.org/30275 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2016-10-24tdf#80439 Help pages for (NET)WORKDAYS.INTLChandanathil P. Geevan
removed useless file replaced commas with semicolons in function expression Change-Id: I76ce8945d7f5d51f7b356dc8063db1b4623e905b Reviewed-on: https://gerrit.libreoffice.org/30217 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2016-10-24update help ids for function panel .ui conversionCaolán McNamara
Change-Id: Ie6623190ca919e7e4cf0d76ba94fd67056a09f3e
2016-10-22tdf#103398 Missing space after word and upper case to begin a sentenceAdolfo Jayme Barrientos
Change-Id: I4152eddf04392bb54135e6314884464385c8d6c8
2016-10-12fix typo, s/Number 0/Number30/Eike Rathke
Change-Id: I32b5f02e4732bea036e4ca76f24f6ffe85dc0736
2016-10-07update help ids for calc navigator .ui conversionCaolán McNamara
Change-Id: I9d712222a91bc1c9fbef6c4bd92c10d46f59090c
2016-09-27Improved topic relations for a selected set of pagesJohnny_M
Following pages are affected by this update: 1. "Functions by Category" (https://help.libreoffice.org/Calc/Functions_by_Category): - Added a variable to its heading, so that it can be referenced from other places - Removed self-referece in its "Related Topics" (it was turned into the above heading reference instead, thereby also correcting the remote HTTP page reference to local help file referece). Note: Pages already using the reference will auto-ajust (e.g. "Related Topics" of https://help.libreoffice.org/Calc/Statistical_Functions_Part_One) - Corrected "Operators" reference location by moving it into "Related Topics" 2. "Statistics Functions" (https://help.libreoffice.org/Calc/Statistics_Functions): - Added a variable to its heading, so that it can be referenced from other places (point 6 below) - Cleaned up references by adding a "Related Topics" section - Using links to heading variables in "Related Topics", for improved heading string consistency 3. "Text Functions" (https://help.libreoffice.org/Calc/Text_Functions): - Added a variable to its heading, so that it can be referenced from other places (point 5 below) 4. "Add-in Functions" (https://help.libreoffice.org/Calc/Add-in_Functions): - Added a variable to its heading, so that it can be referenced from other places (points 5 and 6 below) 5. "Add-in Functions, List of Analysis Functions Part One": - Added a variable to its heading, so that it can be referenced from other places (point 6 below) - Moved "Related Topics" chapter to the bottom of the page - Using links to heading variables in "Related Topics", for improved heading string consistency 6. "Add-in Functions, List of Analysis Functions Part Two": - Added a variable to its heading, so that it can be referenced from other places (points 2 and 5 above) - Moved "Related Topics" chapter to the bottom of the page - Using links to heading variables in "Related Topics", for improved heading string consistency The updated pages were tested as described in https://wiki.documentfoundation.org/HelpContent#Without_the_LibreOffice_Core_Repo on 32-bit Debian Linux with: Version: 5.3.0.0.alpha0+ Build ID: d15082cac2306fb9562ff126eb5827b7b9eee1e1 CPU Threads: 2; OS Version: Linux 4.6; UI Render: default; TinderBox: Linux-rpm_deb-x86@71-TDF, Branch:master, Time: 2016-09-19_05:41:30 Locale: en-US (en_US.UTF-8); Calc: group Change-Id: Icbb3725fd16d3ff76e5e4244c2284349332cffb7 Reviewed-on: https://gerrit.libreoffice.org/29306 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-09-20tdf#97105 Fix location of the Freze Rows and Columns menu itemGabor Kelemen
This is now under View -> Freeze Cells Change-Id: I6968ee93a1d2f12451791b297b9497eae6e93cd6 Reviewed-on: https://gerrit.libreoffice.org/29024 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2016-09-19tdf#97823 Change SearchCriteria parameter of HLOOKUPGabor Kelemen
VLOOKUP uses singular, as it looks for one value. Change it at HLOOKUP so it's both grammatically correct and matches the parameter in the linked VLOOKUP description. Change-Id: I4b8247ccb90fb726e3526675b4eba2f6fb51c29e Reviewed-on: https://gerrit.libreoffice.org/29014 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2016-09-19tdf#97823 Change VLOOKUP parameter SortOrder to SortedGabor Kelemen
Sync with HLOOKUP's Sorted parameter. This is a boolean indicating if the data is sorted or not, not the order like ascending or descending. Change-Id: Ic48de6597c6b1997502c4dffb4a5bb15cbe49d74 Reviewed-on: https://gerrit.libreoffice.org/29013 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2016-09-19Add couple of screenshots to help filesKatarina Behrens
Change-Id: I5cfe4c7bb48c588aaecb1e9299e8e2b59c680fda Reviewed-on: https://gerrit.libreoffice.org/28613 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2016-09-19tdf#97821 Add section anchors to VLOOKUP/HLOOKUP linksGabor Kelemen
The missing anchors caused the links to not work Change-Id: I4af8d0467cec347dee535f510133819987e88491 Reviewed-on: https://gerrit.libreoffice.org/29010 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2016-09-17tdf#100353 describe fourth argument of NETWORKDAYS functionStanislav Horacek
Change-Id: I970483f5bc0e8d2d6f172b7876d45cf23ba26e59 Reviewed-on: https://gerrit.libreoffice.org/28967 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-09-17tdf#99885 Fix example on using the AGGREGATE functionGabor Kelemen
Change-Id: I27b783c937c7ad44839803f3fd7810a4d03a3d87 Reviewed-on: https://gerrit.libreoffice.org/28936 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-09-16tdf#102219 Correct shortcuts for navigator and referencesYousuf Philips
Change-Id: I3b2a35a05597e6002668e8c4a2afea207a9242bc Reviewed-on: https://gerrit.libreoffice.org/28943 Reviewed-by: Yousuf Philips <philipz85@hotmail.com> Tested-by: Yousuf Philips <philipz85@hotmail.com>
2016-09-15tdf#101723: Wrong parameter reference in COUNTIFS explanationGabor Kelemen
Copy-paste error, sync with function description: Criterion_range2 -> Range2, Criterion_range1 -> Range1 Change-Id: I7c6a200072703944f013f67e220150abaede9418 Reviewed-on: https://gerrit.libreoffice.org/28924 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2016-09-15tdf#102206 Change suffixes of LCM_ADD and GCD_ADD to _EXCEL2003Gabor Kelemen
Change-Id: I8004ad5eb82e3c1d522b655f8533750d87a64bd3 Reviewed-on: https://gerrit.libreoffice.org/28927 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2016-09-15Change file extensions in examples: sxw -> odt, sxc -> odsGabor Kelemen
Some examples still used the old StarOffice extensions. Change-Id: Id6f7a28f0ff8511181f3641d8ad9f6f5896cef68 Reviewed-on: https://gerrit.libreoffice.org/28925 Reviewed-by: Michael Stahl <mstahl@redhat.com> Tested-by: Michael Stahl <mstahl@redhat.com>
2016-09-10replace "also :" by "also:"Christian Lohmaier
reported via pootle feedback Change-Id: I075ba046e72791ac44d37580972ee270134c4a35 Reviewed-on: https://gerrit.libreoffice.org/28797 Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> Tested-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
2016-09-09tdf#100990 correct example for RATE functionStanislav Horacek
Change-Id: I8161bd5b805ffc0e852c2d2516e48eba8bdf10cd Reviewed-on: https://gerrit.libreoffice.org/28745 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-09-08tdf#101805 correct documentation for ERF.PRECISE functionStanislav Horacek
Change-Id: Ic621f1e60f41ebcda5b3f390713da4315cf68500 Reviewed-on: https://gerrit.libreoffice.org/28735 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-08-31change bad example for "Convert only if unambiguous" to something betterEike Rathke
Why is this even in the OpenCL_options help file? Change-Id: I319b59cea3d7f56b58de95292ca53b708e7e23c7
2016-08-18tdf#30456 Add help to Merge Cells dialogLaurent Balland-Poirier
Describe the three options that will be introduced with commit: https://gerrit.libreoffice.org/27463/ Change-Id: Iefe1b887d28d1845755e5beeadfa6d829c8d4acf Reviewed-on: https://gerrit.libreoffice.org/27467 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2016-08-17tdf#94553 fix nested lists in wikihelpAkash Deshpande
The problem was that only the first element in a nested list was getting the extra '#' character Added a re.sub statment to ensure all elements inside a nested list have this to ensure proper display Also backing out temporary/FIXME changes in the xhp files. The run is now free of warnings with the desired changes showing up for 'Using Gluepoints' page, which has a nested list Change-Id: I4009408ee11e191cbd5e1560ca1d08f3e7b5c630 Reviewed-on: https://gerrit.libreoffice.org/28107 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-08-11tdf#97923 adjust menu path to Insert/Delete Page BreakStanislav Horacek
Change-Id: I9a771b814452353da48dcbb19f39e4ff1d9770b4 Reviewed-on: https://gerrit.libreoffice.org/27994 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2016-08-09clarify on CEILING,CEILING.MATH,CEILING.XCL and FLOOR,FLOOR.MATH,FLOOR.XCLEike Rathke
Change-Id: I557b2be54fad33e540017e093d3261e430e9a152
2016-07-31mark see also link as translatableStanislav Horacek
Change-Id: I0ca1ff39e46fceb8b86d1551cf02540b471d3e49 Reviewed-on: https://gerrit.libreoffice.org/27743 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2016-07-31add missing commasStanislav Horacek
Change-Id: I694c61ec62ebac77a4499a82da9a15b8bc1c5aeb Reviewed-on: https://gerrit.libreoffice.org/27742 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2016-07-25FORECAST.ETS.*: improve description of aggregation argumentStanislav Horacek
Change-Id: I1192fdeb6249cb63d45a40c099b47685a0dd51f8 Reviewed-on: https://gerrit.libreoffice.org/27472 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-07-25fix spelling of "coefficient"Stanislav Horacek
Change-Id: Id988f9127d8d7af2dbd72ec899168d21b7d2923b Reviewed-on: https://gerrit.libreoffice.org/27481 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-07-25FORECAST.ETS.* confidence level: use precise argument nameStanislav Horacek
Change-Id: I4c2d43055b7a85bc39fa22e0721ba9aa0bd448b1 Reviewed-on: https://gerrit.libreoffice.org/27471 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-07-25Help index entries are in pluralStanislav Horacek
Change-Id: I6618b16d1669c65c2204d80d4c7632a21e7befea Reviewed-on: https://gerrit.libreoffice.org/27490 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
2016-07-25use consistent wording in data analysis functionsStanislav Horacek
Change-Id: Ic8bd4f8be1b3a5836e32f62fc5d102343f4ff34a Reviewed-on: https://gerrit.libreoffice.org/27489 Reviewed-by: jan iversen <jani@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
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-07-22tdf#92825 adjust menu path for AutoCalculateStanislav Horacek
Change-Id: I7a18a0434d92db015721ef7e523aebaf76b3c7af Reviewed-on: https://gerrit.libreoffice.org/27448 Reviewed-by: Samuel Mehrbrodt <Samuel.Mehrbrodt@cib.de> Tested-by: Samuel Mehrbrodt <Samuel.Mehrbrodt@cib.de>
2016-07-12(Regular) tooltips can no longer be disabled…Adolfo Jayme Barrientos
… so this is always true. Change-Id: I1154f86cd7dde358a669f6a3020119e9685ac83a
2016-06-22Replace ASCII approximation of trademark symbol with real characterAdolfo Jayme Barrientos
Change-Id: I70c466baaaa8e2fbcba8c4c36fd4df6f14cda22b
2016-06-21missing paragraph roleAndras Timar
Change-Id: I7f3e30a07bbdc8a9dcb8c63519ba1a78c1ada0dc
2016-06-20“Page Break Preview” → “Page Break” in CalcAdolfo Jayme Barrientos
Change-Id: Ic0d6cbe429305760a21ebc9fdbee67f0d752fe23
2016-06-19tdf#100478 Correct the syntax of two examples of the N formulaAdolfo Jayme Barrientos
Change-Id: If97787808183045e3a9573cf1a26ed3e923f3bdb
generated by cgit (git 2.34.1) at 2025-02-10 03:37:18 +0000