summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)AuthorFilesLines
28 hourstdf#137649 Fix LOGNORM.INV optional argumentsOlivier Hallot1-3/+3
Change-Id: Ia239d14508c1bb6e86d3d4b1d67f50de0fdb5afc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136498 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
3 daystdf#149218 Add pivot table formatting help pageOlivier Hallot9-35/+101
Change-Id: I807b0e62998bac85cf0cf348d57cb1f99b1dc742 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136411 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
5 daysFix typoAndrea Gelmini1-1/+1
Change-Id: I7c898cbd8890c82c3ebcb0d3d0d4d22096b6f1d4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136400 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
5 daysFix (BIN|OCT|DEC|HEX)2(BIN|OCT|DEC|HEX) to mention string argumentsMike Kaganski2-43/+43
... and return types, and also fix the conceptually incorrect examples Change-Id: I9953d546c0c6ee8f224b866643f6975e538f44f5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136378 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
7 daysNumeral systems are "based" on digits, not numbers nor charactersMike Kaganski1-4/+4
Change-Id: I9c411fe39e81d734d68c9e98253b3d125978f3bc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136239 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
7 daysDrop this nonsenseMike Kaganski1-1/+1
Phrases like this look like an explanation form a clueless person. The help should rely on basics (like differentiating text from names), and not suggest to "place the number in quotation marks" when the argument is documented to be a text. If needed, the word "text" may link to a glossary article with syntax explanation. Change-Id: I32e7a3c68659f74db6bc30c5a3fa9acdd158acb4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136238 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
8 daystdf#149393 cross-ref DECIMAL <-> BASE functionsOlivier Hallot2-5/+11
Change-Id: I5f8a2e5d93ca0d723a6adfc31aa6cd3fcc7568c5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136085 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
10 daystdf#149301 Update Navigator terminologyOlivier Hallot1-45/+24
+ Refactor, simplification of <switch> + Removed duplicated hid bookmark for Contents + Update icons and <alt> text + added some of the comments of tdf#178755 Change-Id: Ifaba80d212828e47d99275a9b0a1681eb3bc3430 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136105 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
10 daysUpdate tdf#129679Laurent Balland1-41/+36
Remove Apache license as it is a new file Add some details. Change-Id: I9cf2b707d32772017ab56f093115419ca020398a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136106 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-15Fix some function descriptionsMike Kaganski1-4/+4
Change-Id: I85bd929ab1febed3f1567a911ee188e134afe847 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135876 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2022-06-11Add info on sparkline custom vertical max/minOlivier Hallot1-1/+1
Change-Id: I5e87f7036eb34b1d5cbd0c635b319417981a16b3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135639 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-11Relates tdf#36466 - Update help about copying visible cells onlyDietrich Schulten1-1/+1
Change-Id: Ia33f942232b73aaad53bb34a5e02b4c457a0d8bc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135541 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-08Fix sentence about solver settingsRafael Lima1-1/+1
As pointed out by Adolfo in change 40ee3181de08d372b5a25bb691644a94d3ffe9bd, the word "beware" was used incorrectly. This patch fixes it. Change-Id: I3b2dd94b04b9c9c5ca5dc9c0b4c99a8e1c048941 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135384 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-06-07Related tdf#38948 Warn that Calc Solver does not save model to fileRafael Lima1-1/+1
Based on Comment 36 from bug 38948, the help should make it clearer that Solver models are not saved to the file by LO Calc. This patch changes the current <note> into a <warning> and makes it clearer that solver settings are not saved. Change-Id: Ie1cdf5a82c105c371e05b85ccad6736ed5e74a3f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135272 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-07Include metacharacters fragment in ICU regexp URIEike Rathke1-1/+1
So it leads to Regular Expression Metacharacters instead of just the page that starts with all sort of developer information not relevant to users. Change-Id: Id1efca75302d023a83b45a4bc81654ffe8c2980f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135471 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2022-06-06tdf#148817 Sparklines Help page.Olivier Hallot2-0/+92
+ add bookmark entry + update Calc Insert menu help page Change-Id: I76315d7c35a2a98731ef92d9090ebcba41f9e004 Co-authored-by: Tomaž Vajngerl <quikee@gmail.com> Co-authored-by: Roman Kuznetsov <antilibreoffice@gmail.com> Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135324 Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-06-02tdf#129674 Add index bookmarkOlivier Hallot1-6/+9
+ refactor help page Change-Id: I236737649aa20019db33b10e107cba15a20db342 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135305 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-02Fix broken links in CEILING functions help pageOlivier Hallot1-2/+2
Address comments from https://gerrit.libreoffice.org/c/help/+/92097 Change-Id: Id4ad0b4ed3d609f9e1ddb2482afd00f318d813bc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135306 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-06-02tdf#129674 New command Go to SheetLaurent BP1-0/+44
Add help to "Go to Sheet" dialog Change-Id: Iede0523d0272b32b9b87489129bca0136d601a65 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/134951 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-04-05Minor string fixesAdolfo Jayme Barrientos1-1/+1
Change-Id: If1f76eacb11216a0b647948e956c7c99711f4c35
2022-03-24Fixes in textOlivier Hallot1-1/+1
Change-Id: Id37c002443c34d06e4daad777127edc8e20c2476 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/131869 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-03-15Update Calc Tools menu with Forms submenuOlivier Hallot2-0/+6
Change-Id: I5524b4ba2674167a162133b9ff99677f2f59cfc3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/131607 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-03-15Revert "Update Clac Tools menu with Forms submenu"Stephan Bergmann2-6/+0
This reverts commit 31f0c48d3bc30742d49af32ac9686d71f8aa7215, because it broke the build, presumably because it forgot to add helpcontent2/source/text/shared/menu/forms.xhp as a new file. Change-Id: Ie51a7683f254b0439bbbc2e563ba943b8f98e02a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/131486 Tested-by: Jenkins Reviewed-by: Stephan Bergmann <sbergman@redhat.com>
2022-03-15Update Clac Tools menu with Forms submenuOlivier Hallot2-0/+6
Change-Id: Ib8ac1f43116592ea569d88d16f84db44b0333286 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/131567 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-03-15Update Calc's Tools menu Help pageOlivier Hallot1-0/+6
Change-Id: I9f52bd1636a472fc02924c1adf6685358b504e47 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/131555 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-03-15tdf#147977 Add Share Spreadsheet help pageOlivier Hallot3-1/+54
Change-Id: Ic4d77dd4b33d3e0bd74c48a195a3d97b2ad647e4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/131553 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-02-26Fix typosAndrea Gelmini2-2/+2
Change-Id: I429340ab93861fe38c80bdcd97daf0dbd661ab84 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/130536 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-02-23tdf#145898 Formula to Value and Recalculate HardOlivier Hallot6-17/+100
Review of the Data - Calculate submenu - Added Recalculate Hard page - Added Formula to value page - Links and embed for navigation - Some precisions regarding non-volatile functions Change-Id: Ic39b61feb851b9cc7c8cb2ae6907651a64a81a6e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/130180 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2022-02-12tdf#137259 Update BETAINV and BETA.INV descriptionOlivier Hallot1-20/+18
Patch set 2 The namespace information was by tdf#94537 Change-Id: Ic107bdf1a15b762fe8962ae68d536df3acc8b7da Reviewed-on: https://gerrit.libreoffice.org/c/help/+/129821 Tested-by: Jenkins Reviewed-by: Steve Fanning <stevemfanning@yahoo.co.uk> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-02-05Drop last 00/00000004.xhp#wie and simplify XSLTOlivier Hallot1-39/+37
Change-Id: I85d2da067db208f806b78020a9ca95889444ce0d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/129519 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-02-02tdf#147134 Fix help page on edit pivot tableOlivier Hallot1-2/+2
Change-Id: I9eafeead4048bbc2c2d83ed239ae120980b4e89e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/129377 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-31Improve recently touched string, we’re gonna retranslate it anywayAdolfo Jayme Barrientos1-2/+2
Change-Id: Ieea3aa49cd9d3838c97fc288c3ee2a2d73138174
2022-01-31tdf#67026 Limitation of Calc precision documentedOlivier Hallot2-1/+109
Contents borrowed from M. Kaganski FAQ page at https://wiki.documentfoundation.org/Faq/Calc/Accuracy Change-Id: I89ba43c78d10ed4671b66ba0acc7df2e9947783a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128359 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-27tdf#147011 Fix text on entering data in CalcOlivier Hallot1-8/+8
Change-Id: I713351de49059b643acceae8ce0f65f664829980 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128962 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-01-25Fix typoAndrea Gelmini1-1/+1
Change-Id: Id60e34680e07b3d2842e0540eea4d9cdc07a6baa Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128941 Tested-by: Jenkins Reviewed-by: Andrea Gelmini <andrea.gelmini@gelma.net>
2022-01-25tdf#139735 Change all "Link to External Data" to "External Links"Jeff Huang4-5/+5
According to https://bugs.documentfoundation.org/show_bug.cgi?id=139735#c4 , this patch change all of "Link to External Data" sentence to "External Links". Change-Id: I654a6666d8eeac76589bcd205cb8edf94c218a41 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128911 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-23HYPERLINK() clarify that it is not "CellText" but CellValueEike Rathke1-3/+3
i.e. the argument and thus function result does not have to be of type text. Change-Id: I8e1917ecc5f740f880b5321c4c91f7512c9e3245 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128844 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2022-01-22tdf#146778 Clarify the use of the "Interval" argumentRafael Lima1-4/+6
+ minor refactoring. Change-Id: I339ea6a2fbd94be3aa9fe756181e3a7b6a5cc604 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128677 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-19Fix typosAndrea Gelmini2-2/+2
Change-Id: Iadee715d8804c383e57de3fce7e7d1f8a78d826c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128618 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2022-01-19Fix typoAndrea Gelmini1-1/+1
Change-Id: Ieb8d249536a6aeba31b5c6b28bd2a01a0c84421b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128617 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2022-01-19tdf#145332 Improve help pages for TRUNC and ROUNDDOWNRafael Lima3-44/+113
Since TRUNC and ROUNDDOWN perform the same function, the help pages are now more consistent. The help pages were created in separate files. Change-Id: I68092c61f2cb80c66e798c188d9c4172de5d48c0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128244 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-19tdf#145060 Create help page for the Find toolbarRafael Lima1-0/+3
Change-Id: Ifad2102915236ffe2098b1aae15d3e5c39bb2921 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128079 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-13Fix typosAndrea Gelmini2-2/+2
Change-Id: I951914bd28c7cd4f49e2704f3393e91fb18e6cd0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128385 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-13tdf#91230 Improve description of Conditional FormattingRafael Lima1-6/+6
Change-Id: I536c959bec3ad94deb5e9893b956755d64f438f2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128337 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-13tdf#70551 Improve description of the WEEKS add-in functionRafael Lima1-4/+13
Change-Id: Ic4e234496a05fb1e88de88f554a2b5ae90244651 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128331 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-13tdf#80658 Calc stream Hlp page (part)Olivier Hallot1-1/+34
- Added contents to live data stream help page - Used some of Vipul Gupta contents from attachement in ticket - Still incomplete because the setup to work is non trivial Change-Id: I02bf8178859ddce7ce28082388d21e31853dac4e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128348 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-07tdf#145866 Fix information about accessing Function ListRafael Lima3-2/+2
Change-Id: Icfa91482c8260dc838e53eee5dafee54fca7a5b0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127953 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2022-01-06tdf#120247 Update CONVERT() Calc funct wrt ODFF1.3Olivier Hallot1-7/+8
Change-Id: I6c58f86c943cb41cb2f9161de630d3519aef9a86 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127945 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-04tdf#94537 OPT_* functions help ID'sOlivier Hallot4-8/+20
+ Added reference to not-ODFF + Changed suggested help ID's to match If275d804fc81b535c422a29ba594eb88ce5e70c0 Change-Id: I81664d85d8b589db86a51cecc759580a8086e336 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127897 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2022-01-02tdf#94537 ORG.LIBREOFFICE.* namespace informationOlivier Hallot10-18/+52
Change-Id: Ide646195514d45dec1b4b386890b1d64ae3b3138 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127840 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>