summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)Author
2025-01-17tdf#131927 Clarify criterion as string expression in SUMIFOlivier Hallot
Change-Id: I6f59f9042e444011d044eeefb2aeda29b00425c4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/180364 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2025-01-14tdf#162504 Add help page for Cell Appearance sidebar panelDione Maddern
Create new help page source/text/scalc/01/sidebar_cell_appearance.xhp - Add a new help page to document the features of the Cell Appearance sidebar panel in Calc - The head section from this page will be added to the Properties Sidebar page when help pages for all properties panels are complete. In /home/twistappel/libreoffice/helpcontent2/AllLangHelp_scalc.mk - Add the new help page source/text/scalc/01/sidebar_cell_appearance.xhp to the repository In source/text/scalc/01/05020000.xhp - Add variable tags to the main heading easier to make it easier embed in other pages. In /home/twistappel/libreoffice/helpcontent2/source/text/shared/01/05030500.xhp - Add variable and section tags to make content easier to embed in other pages. Change-Id: I7e61a7daea7a1759f88d6ff6cbfde4aec57da680 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/180244 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2025-01-07Fix XML tag positionOlivier Hallot
Change-Id: Iab81f4d3cd86848412c53639cce5c84fc73a646d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/179880 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2025-01-06tdf#160178 Add bookmarks to Pivot Table GoupingOlivier Hallot
Also fix the "How to get" section. Change-Id: I22d5d707397d37ceb7ad45a8c42b128146eb742e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/179846 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2025-01-06Fix typoOlivier Hallot
Change-Id: I4db29c5cc9fba1902f9cd1316096f9a8ea59d42d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/179842 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2025-01-06tdf#137419 Remove Data Provider help pageOlivier Hallot
Change-Id: I898f9165a27b009a379a1c3d59886981b6f9f2d5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/179810 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2024-12-19Mute L10N when <embedvar> is a singleton in textOlivier Hallot
+ some refactor Change-Id: I071758f139a7f6e9ab91ca277a420c8283b1eae0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/178833 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-12-16Mute L10N in Navigator context help page (IV)Olivier Hallot
+ Sort panel <-> deck terminology error, according to (1) + Changes in experimental mode warning, replacing explicit text by embeded one. (1) https://wiki.documentfoundation.org/File:LO-HIG_SideeBar-Terminology.png Change-Id: I8d7d4e899dadda56c2ef1b6290e74b09f7411f0b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/178527 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-12-11Fix typoAndrea Gelmini
Change-Id: I06f47ab3e8d6d9a1e4755964f6e577de08b4ce86 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/178263 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2024-12-10Fix localization in bookmarkOlivier Hallot
Change-Id: I17fb59061e3b4b0ee6e9ac14f6ddce3539ff0010 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/178256 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-12-09tdf#131332: Replace custom date formats with ISO 8601Bogdan Buzea
Change-Id: Idf08d44bb5287da44b281820e73e08c58e154f99 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/178163 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-12-09tdf#162504 Create help page for Alignment Sidebar panelDione Maddern
Create new file source/text/scalc/01/sidebar_alignment.xhp to explain the features of the Alignment panel of the Properties sidebar. In AllLangHelp_scalc.mk - Add new file source/text/scalc/01/sidebar_alignment.xhp to the make file - Change the file path for source/text/scalc/01/sidebar_number_format.xhp to show amended file location. In source/text/shared/01/05020700.xhp - Add variable tag so that the file can easily be linked from other help pages. In source/text/shared/01/05100100.xhp - Add section tags so that content can be easily embedded in other pages. In source/text/shared/01/05340300.xhp - Add section and variable tags so that content can be easily embedded in other pages. - Reformat the "reference_edge" section so that each option has its own heading. This improves readability and consistency and allows the same content to be re-used in the help page for the Alignment Sidebar panel. In source/text/shared/01/LeftToRight.xhp - Add section tags so that content can be easily embedded in other pages. In source/text/shared/01/RightToLeft.xhp - Add section tags so that content can be easily embedded in other pages. In source/text/scalc/sidebar_number_format.xhp - Moved file to source/text/scalc/01/sidebar_number_format.xhp In source/text/shared/01/sidebar_properties.xhp - Embed description of Alignment sidebar panel - Update file path for source/text/scalc/01/sidebar_number_format.xhp - Add loc_false tags for embedded variables Change-Id: Id9c232c18bab1cfab99eec83e796f8db25681898 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/177707 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-12-09tdf#161502 Update label Structure to Content in Function Wizard helpIlmari Lauhakangas
Change-Id: I62322b720b0ec54c54268d9cb6a0f2d36b7c8d94 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/178125 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> Tested-by: Jenkins
2024-11-27tdf#131332: Replace custom date formats with ISO 8601Bogdan Buzea
Change-Id: I46c451df1f3b957a3129f167e0a8d45726ef78c4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/177295 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-11-27tdf#131332: Replace custom date formats with ISO 8601Bogdan Buzea
Change-Id: I2f17cb9ffc9704c229f4c2f6dd9c6fb8e0531f42 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/177297 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-11-26tdf#85976 update help page for 'Handle Duplicate Records' dialogSahil Gautam
+ use row/column instead of record to make it easier to understand + use field instead of record to describe the treeview entries in the 'Compare by' section as that's a more technically correct term. https://bugs.documentfoundation.org/show_bug.cgi?id=85976#c84 Change-Id: I05f2280a94507528a595436d2a8a52c6ed574d9e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/177261 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-11-19tdf#162504 Create help page for Number Format paneDione Maddern
Create new page source/text/scalc/sidebar_number_format.xhp to describe the features of the Number Format pane in the Properties sidebar deck. In AllLangHelp_scalc.mk - Add new file source/text/scalc/sidebar_number_format.xhp to repository. In source/text/scalc/01/default_number_formats.xhp - Add variable and section tags so that content can be easily linked and embedded in other pages. - Remove old comments In source/text/shared/01/05020300.xhp - Add variable and section tags so that content can be easily linked and embedded in other pages. - Remove old comments In /home/dione/libreoffice/helpcontent2/source/text/shared/01/sidebar_properties.xhp THIS PAGE IS A WIP AND WILL NOT BE LINKED IN HELP UNTIL IT IS FINISHED - Embed description of the help page for Number Formats - Added index bookmarks (Currently commented out) - Updated application switches to hide the desription of the Paragraph pane for CALC and BASE. Change-Id: I7e1849ddc41cad7fd5d4b6c57e8a03186eb6575f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/176720 Tested-by: Jenkins Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-11-12Remove Calc screenshots.Olivier Hallot
+ used only once in a help page + Calc localized screenshots are missing. + Re-visit "make screenshots" for Calc sometime in the future. Change-Id: I7a8df7b48eec280d63396c457e3115236bb57ae6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/176505 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-11-09tdf#143846 split LEFTB LENB MIDB RIGHTBPierre F
Change-Id: I57be1c7ea1642ef84798fadc6dd204bbac4c994e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/176069 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-11-04TyposOlivier Hallot
Change-Id: I18a9e94a27f6e19c26c9076b9bd6be307717169b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175987 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-11-02Tweaks for text function for navigation (3)Olivier Hallot
Change-Id: I6a4246acf9e6ade45e9692a24fb358fc44a90a05 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175955 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-11-02tdf#143846 split PROPER REPLACE REPT RIGHT SEARCH ...Pierre F
... SUBSTITUTE T TEXT TRIM UNICHAR UNICODE UPPER Change-Id: I2ef1a659fbaf481dac1329f86178b8cd9b786ce2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175912 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-11-01Tweaks for text function for navigation (2)Olivier Hallot
Change-Id: I5fb676334f398441aa8505ccba3f3344b4c3c3e6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175932 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-11-01tdf#143846 split EXACT FIND FIXED LEFT LEN LOWERPierre F
Change-Id: If4635fad96157ae6b91c77aa574c1bfb3351d35c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175858 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-10-30tdf#143846 split DECIMAL() + DOLLAR()Pierre F
Change-Id: Iba787b44ad846fd2e7ec129fbb72bf916b23e2e9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175756 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-10-30Mute L10n of embedded contents.Olivier Hallot
+ fix bad string Change-Id: Ie84c289310923c286cc843d42ffc2c361dcd9154 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175758 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-10-29Tweaks for text function for navigationOlivier Hallot
Change-Id: I1bc8d9ab8c73d94264c5774bd37cae2a9b54950e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175785 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-10-29tdf#143846 split CODE() + CONCATENATE()Pierre F
Change-Id: Ic190564f4e7a7884900766cee26322f5ab7dfec9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175607 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-10-24Completion of CHAR and CLEAN functionsOlivier Hallot
Added link to wiki pages. Change-Id: I9c5b5d44f05c8d803994cd9efc864ab873bdd386 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175554 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-10-24tdf#143846 split CHAR + CLEAN. + helperPierre F
to extract xhp files, run : perl helpers/calc_text_func.pl CHAR CLEAN ouput : TODO. add to git and AllLangHelp_scalc.mk : helpcontent2/source/text/scalc/01/func_char \ helpcontent2/source/text/scalc/01/func_clean \ Change-Id: I986cb038748586c12bd09441070cf272de2d4106 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174677 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-10-08tdf#162275 Fix typoIlmari Lauhakangas
Change-Id: If8ae57d1d7a92256ee4b9fef60ca47496d225be4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174704 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> Tested-by: Jenkins
2024-10-04tdf#143846 split BASE + BAHTTEXTPierre F
new helper : xsltproc --stringparam func BAHTTEXT helpers/calc_text_func.xsl source/text/scalc/01/04060110.xhp > source/text/scalc/01/bahttext.xhp Change-Id: I40c33d486c45ef0a3316dba1c0aea4af68ff9f37 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/172748 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-09-30tdf#162607 disambiguate hid2file.js, InsertCtrlOlivier Hallot
+ Removed misplaced bookmark in Calc + review of Insert toolbar for Calc + Refactor Change-Id: Ifc908c22a5c8e69e6f8ccc86b637baa0b009c7f3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174286 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-09-29Fix typoAndrea Gelmini
Change-Id: Ie5eb123d87c8d1993f3699c20687044835381e47 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174159 Reviewed-by: Julien Nabet <serval2412@yahoo.fr> Tested-by: Jenkins
2024-09-28tdf#85976 Help page for HandleDuplicateRecords dialogSahil Gautam
https: //gerrit.libreoffice.org/c/core/+/160685/comments/9dd92aa8_beae1c5f Change-Id: I4ce7ad0022ed34b3704a3a5b17416eabcf91dd03 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/173142 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-09-28tdf#162607 disambiguate hid2file.js, uno:SheetMenuOlivier Hallot
+ Remove singleton help file used nowhere (superseeded by scalc/main0116.xhp) Change-Id: I5e675d84c9e54fcf0d2bf7c3f0c46bd6de6d43aa Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174143 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-09-27Fix typoAndrea Gelmini
Change-Id: I3084421a7390178d8b6cecf8752b3223994e41fa Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174056 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2024-09-27Fix typoAndrea Gelmini
Change-Id: I4ecf82ce4ebf13c9147f08c960f2624a4997a3e4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174054 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2024-09-27Fix typoAndrea Gelmini
Change-Id: I32cf04e2b4e9f1b05a904d7cecdc12ca719ff696 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174055 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2024-09-27tdf#162275 Add documentation for "database table references"Dione Maddern
Added new help page source/text/scalc/01/database_table_reference.xhp to cover the "database table references" feature in Calc, also called "structured references". Added new help page to repository AllLangHelp_scalc.mk Added section and variable tags to allow pages to be more easily linked and embedded in other pages in: - source/text/scalc/01/04060101.xhp - source/text/scalc/01/04060107.xhp - source/text/scalc/01/12010000.xhp - source/text/shared/optionen/01060900.xhp Added Related Topics links to make it easier to access relevant information in: - source/text/scalc/01/04060101.xhp - source/text/scalc/01/04060107.xhp - source/text/scalc/01/12010000.xhp - source/text/scalc/guide/database_define.xhp Change-Id: Ic3bf69b8ad773828efeea35a7539ebf29bae6856 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/173999 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-09-23tdf#162607 disambiguate hid2file.js, RTL/LTROlivier Hallot
+ Created files for uno:ParaRightToLeft and uno:ParaLeftToRight commands + Adjust embeds and links, how to get Change-Id: Ide954868ecaa513c439d4950b097aefa96ffb69a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/173814 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-09-21tdf#162607 disambiguate hid2file.js, DrawGraphicMenuOlivier Hallot
+ This uno:DrawGraphicMenu does not exist (anymore) + drop duplicate page in scalc/01 folder + adjust format_object.xhp for Writer and Calc Change-Id: I45b58ca078115a564e06a3b02bd93c0f50dc1e26 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/173764 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-09-17tdf#162847 Resize icon in page.Olivier Hallot
+ refactor partially Change-Id: I9e547dcab48fe5413f92076c365bf7db952c06c7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/173570 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-09-16tdf#162607 disambiguate hid2file.js, Print previewOlivier Hallot
+ Moved Print Preview and Close Preview to shared/01/print_preview.xhp + deleted 01120000.xhp from swriter/01 and scalc/01 Change-Id: I85e7d0c73f1a0f886657f8cabff774c0d3b67606 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/173459 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-09-12tdf#162607 Remove dup's in hid2file.js,uno:Align*Olivier Hallot
+ Removed bookmarks from hidden ahelp + refactor Change-Id: I075adfbfbe6cc0113e70ca151adc518a94131420 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/173274 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-09-12tdf#162607 Remove dup's in hid2file.js Standard filterOlivier Hallot
+ Deleted shared/02/12090000.xhp because 12090100.xhp has much more info and duplicates contents + rebuild links to reach 12090100.xhp + renamed references to Default filter to Standard filter. + add section to standard filter icon for embed purposes + refactor Change-Id: Ib88b7574fa12910c4cf9c8af9cbf79577b600e4b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/173237 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-09-07tdf#162607 Remove dup's in hid2file.js, SC_HID*Olivier Hallot
+ fixed bad bookmarks + refactor Change-Id: Ie466ecff62f4bdcbecfe737a80c5ff2a93e02d9d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/172992 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2024-09-07tdf#162607 Remove dup's in hid2file.jsOlivier Hallot
+ fixed Fourier bad bookmark + needless bookmark in shared/00/00000001.xhp "delete". + deleted page shared/01/06130500.xhp because of full duplicate of sbasic/ homonym Change-Id: Ib9506e93f868dbc6c35b7dfbd73cad72c807d6f6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/172990 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-09-03tdf#162607 Remove dup's in hid2file.js, .uno:InsertMenuOlivier Hallot
+ .uno:InsertMenu scattered in 4 files + Same content in each + moved to shared/ + refactor links from trees and main menus Change-Id: Iafd166596991c3d92e1e721837466456e090e2a3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/172835 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-09-03tdf#162607 Remove dup's in hid2file.js, .uno:ViewMenuOlivier Hallot
+ .uno:WindowMenu scattered in 5 files + Same content in each + moved to shared/ + refactor links from trees and main menus Change-Id: I1324aff453df2870a70926321a2211bc12901cd4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/172793 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
generated by cgit (git 2.34.1) at 2025-02-05 19:35:57 +0000