summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)Author
2020-12-23Fix a "D'oh! you found a bug"Olivier Hallot
+ Some refactor on the pages. Change-Id: Iec37d94dfa40292eeaae3dae3cf6ab1189fa8d2a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/108009 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-12-10Related to: tdf#138662 improve help for renaming Calc sheetsSeth Chaiklin
* move <tip> and <note> to better location * move prefix explanation to better location with own <h2> - drop links to page that does not give any help about prefixes and add menu command sequence to get to the relevant place. * Revise explanation about naming (drop select, add double click) + add explanation about single quote restrictions. - drop warning about WindowManager (which was added in 2006) + add <literal> to restricted characters + add new <h2> headings to clarify page content * convert one "note" to a paragraph under a new heading * where paragraphs were changed, add <menuitem> as apppropriate * update to <tip>,<note>,<h1> Change-Id: I8a0e97b871331e0e3300a68252ae4096500aeeb1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107380 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> (cherry picked from commit 13cd181da4668aba0ba1e60c928d91c4892754db) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107491 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-12-09tdf#95147 Add note to use Optimal Height with wrapping in XLS filesgar Soul
Change-Id: Ia7a0f3a1cdbb514f95a19cf1496b0b82bd1626cd Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107308 Tested-by: Jenkins Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> (cherry picked from commit a097662d6678263bb91b6a1dc1f5494fbf47bf38) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107483 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-12-01tdf#134602 repair menu sequence for Freezing Rows or ColumnsSeth Chaiklin
* change View - Freeze Cells - Freeze Rows and Columns --> View - Freeze Rows and Columns * update to <h1> Change-Id: I3d4b29cbabe5195c10d95fe7da56f1129befe6e9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/106934 Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Tested-by: Jenkins (cherry picked from commit f6a5ead66ece37829ee11dd6f29bc1450f235462) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/106942 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-11-19We’re stuck with these unfortunatelyAdolfo Jayme Barrientos
Change-Id: Ic6350bf8490a88dec55d453de849c3eb697ad9db
2020-11-20tdf#114660 add explanation about setting regex option in Calc help exampleSeth Chaiklin
Change-Id: I6da4f95cb4cdb09a4d2ccdbf35fab7f5f5db1102 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/106137 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
2020-11-16tdf#113804 add explanation about Hanging Indent .unoSeth Chaiklin
( swriter/guide/indenting.xhp ) + add explanation about Hanging indent .uno * correction to menu sequence for editing Paragraph Style + add subheadings for "Positioning" and "Hanging indent" + add icon table for Hanging Indent + Mention .uno possibilities for adding buttons, menu items and shortcut keys, with links to relevant pages. * update to <h1>,<tip>,<note>,<relatedtopics> ( shared/02/02130000.xhp ) * rename "einzvermindern" to "indentdecrease" * rename "syeinzvermindern" to "indentdecreaseicon" + add variable "decreaseindent_h1" to <h1> header for embedding + add related topics section with links to increase and guide * change icon width/height to 1cm * update to <h1> ( shared/02/02140000.xhp ) * rename "einzerhoehen" to "indentincrease" * rename "syeinzerhoehen" to "indentincreaseicon" + add variable "increaseindent_h1" to <h1> header for embedding + add related topics section with links to decrease and guide * change icon width/height to 1cm * update to <h1> ( swriter/main0202.xhp ) * update to renamed select IDs from shared/02/02130000.xhp and shared/02/02140000.xhp * change icon width/height to 1cm * update to <h1>,<h2> ( scalc/main0202.xhp ) * update to renamed select IDs from shared/02/02130000.xhp and shared/02/02140000.xhp Change-Id: Ib6dc0ba01a459ae3b47d45178f7c7ba5895a3792 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/105543 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
2020-11-14tdf#103419 add missing functions to "Logical" category help page in CalcSeth Chaiklin
( scalc/01/04060105.xhp ) embed headers and link to SWITCH and IFS embed full sections for IFERROR and IFNA update select ID to "logical" rename variable ID "logischtext" --> "logicaltext" (only embedded in scalc/01/04060100.xhp ) ( scalc/00/00000404.xhp ) rename variable ID "eikalo" --> "logical" only embedded in scalc/01/04060105.xhp ) ( scalc/01/04060100.xhp ) update select ID to "logicaltext" update to <h1>,some <h2> Change-Id: I1764301fa43bd564831b7de613a3c8acbcf0c3dc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/105364 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
2020-11-10Remove note on ADD for DURATIONOlivier Hallot
Change-Id: Ib78b9f2ee12b6c5fa58acafef75d60f69490745d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/105531 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-11-10tdf#132643 Translate German section IDsJohnny_M
Change-Id: I98804c7621f2272615b37b324092a85402d8d84e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/105113 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-11-09tdf#132643 Translate German section IDsJohnny_M
Change-Id: Iecf08159e31b821c65b1396592172490d3710b9a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/105117 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-11-09tdf#132643 Translate German section IDsJohnny_M
Change-Id: Iedb30a66e63bfde10e3514008aec3763ecaaec2f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/105111 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-11-09tdf#132643 Translate German section IDsJohnny_M
Change-Id: Id742ad4c9850a88d6d8d1925e2d0088f76ec8717 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/105108 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-31tdf#137724 repair access command to Basic Macro editing in CalcSeth Chaiklin
* change two menu command sequences + add step about selecting where Module is stored. - remove a word from a menu sequence + <menuitem> Change-Id: I694e544de5977a1ca74b5a3ae572a944f148b830 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104951 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
2020-10-29tdf#137277 add note about truncated lists in Excel exportSeth Chaiklin
- remove all colspan="" rowspan="" in <tablecell> + <h1>,some <h2> Change-Id: I07430cde51ed1d4faeac2569b9e4066dcf290865 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104952 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
2020-10-29tdf#132643 Translate German section IDsJohnny_M
Change-Id: I453659d2f1edbb4bf7cac1f316a88a6942ffdc5e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/105003 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-29tdf#132643 Translate German section IDsJohnny_M
Change-Id: I417cc07fdbd0e20887956db75e68e623704ff8d5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104999 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-29tdf#132643 Translate German section IDsJohnny_M
Change-Id: Ie51d4d2af866b062813d3a733ebf5161c9cbc278 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/105002 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-28tdf#132643 Translate German section IDsJohnny_M
Change-Id: I368e64b51c820d66104fde7cbbec80ba93ef813c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104871 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-28tdf#132643 Translate German section IDsJohnny_M
Change-Id: I2ac3ce76e1a8f6f6f4937687041f817848183a7b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104873 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-28tdf#132643 Translate German section IDsJohnny_M
Change-Id: Ibe35e3fe95f1e9a62c2bf364eeb9350d62c7c81a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104755 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-24tdf#132643 Translate German section IDsJohnny_M
Change-Id: I665a4321420c7f6da3ac1e645d37de2fe95a7d9f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104184 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-24tdf#132643 Translate German section IDsJohnny_M
Change-Id: Ic363b3163b757f11cdd8905e9eccfedf7acfb10e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104752 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-23tdf#132643 Translate German section IDsJohnny_M
Change-Id: I2b0b64ec22dc60d0c077ed8d7e241f077fe8ba84 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104185 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-23tdf#132643 Translate German section IDsJohnny_M
Change-Id: Iece9a1f5185c88dd22fbaf53517bf96b7a1d83fa Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104146 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-22tdf#132643 Translate German section IDsJohnny_M
Change-Id: I1f7872c513d4156454f3aa9f1d2d8c016e510791 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104143 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-20tdf#137569 Fix the capitalization of the kilobyte symbolAdolfo Jayme Barrientos
Change-Id: I1c3bad6a4eed2293fb1dd29344cf0f1369c0c40b
2020-10-05Fix duplicate information on AVERAGEIFOlivier Hallot
Change-Id: I7779c46a665fd1a23012da78c340258675226a3c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103973 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-03tdf#132643 Translate German section IDsJohnny_M
Change-Id: I8f0750d908edeb34f7d2b96ee251d73ce7cee042 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103898 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-03tdf#132643 Translate German section IDsJohnny_M
Change-Id: I297e273038edf30b33e37dd05aaccde1d854c9f0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103896 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-01Inform user on volatile functionsOlivier Hallot
Change-Id: I31f05cc446ecab2bba698660d31790652298578b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103634 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-09-26tdf#132643 Translate German section IDsJohnny_M
Change-Id: Iaec59772e78095a10c4c28e246e77c0469723cbc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103480 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-09-26tdf#132643 Translate German section IDsJohnny_M
Change-Id: Ifb561c069a27e71c66652289ffa4099ba4ec7e68 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103477 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-09-26tdf#132643 Translate German section IDsJohnny_M
Change-Id: Ic553ccd8293161d20554df24884ca164fd59b76d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103476 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-09-22tdf#136071 (related) Remove Spacing submenu from Calc Format menu referenceGabor Kelemen
Change-Id: I474811cc3ea234a38537fa2bfed577ae6570ae90 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103126 Tested-by: Jenkins Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2020-09-08tdf#136510 New Writer table functions PRODUCT, ABS.Olivier Hallot
PRODUCT, ABS, COUNT, SIGN Change-Id: I14d33cbb101ee7146bc54d73121805c883dfe7bc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/102248 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-09-02tdf#136387 POWER(0,0) = 1Olivier Hallot
Change-Id: Ie39042b7c42c350c0c054ced9336613c8704cb7b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101925 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-09-02tdf#136128 Add bookmark for calc formula structOlivier Hallot
Change-Id: Idba9bddf4aba7ae8a0c740d6223b7913ecf99946 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101898 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-08-26Clarify use of pivot table data hierarchyOlivier Hallot
After dicussion in documentation mailing list: https://listarchives.libreoffice.org/global/documentation/2020/msg01686.html Change-Id: I86f659ea35b15d6b7032d0ca6c7890c172fc2861 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101409 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-08-25Fix typoAndrea Gelmini
Change-Id: Ie1578d623ae891994611e43843fb41e7f47bc4d6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101239 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-08-20Add Calc XML source screenshotOlivier Hallot
Change-Id: Ie39d4933a568e511b243b54a1801db869b2f74f2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101035 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-08-15tdf#132643 Translate German section IDsJohnny_M
Change-Id: I758bef77068cda5d0daee5bee9a42a82e9c10c5a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/100771 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-08-14tdf#132643 Translate German section IDsJohnny_M
Change-Id: I745b5e1b19df017b8ffdff6b77959df4f297daf7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/100739 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-08-08tdf#132643 Translate German section IDsJohnny_M
Change-Id: If138eff022dc58dda7c6f6f7d9bb749a0f717684 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/100341 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-08-07tdf#132643 Translate German section IDsJohnny_M
Change-Id: I80cb649d0f6a5953b9e61e43cd41b410d7455504 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/100242 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-08-03Fix tag contentsOlivier Hallot
Found you finally... Change-Id: I71e11b570e31ad1cc470dfea3e54935e000d80f0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/100011 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-07-28tdf#132643 Translate German section IDsJohnny_M
Change-Id: I480cf0609708d48739ea03cc5c882676373ea7f0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/99619 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-07-26Create help page for submenu SpacingIlmari Lauhakangas
Change-Id: I0858a71de5dbbb6e2d1033add3d69d00ad46372f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/99383 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-07-20tdf#132052 Finding currency symbols with Formatted DisplayIlmari Lauhakangas
Change-Id: If0e853f247c262e5369b96f1688250bbd6e17d64 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/99103 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-07-16tdf#126142 Update ImageMap menu item locationsIlmari Lauhakangas
Change-Id: I36b83fd50c53b144c68ed794d1f1516a6984826c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/98855 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
generated by cgit (git 2.34.1) at 2024-07-11 04:06:51 +0000