AllLangHelp_scalc.mk | 1 source/text/scalc/guide/datapilot.xhp | 9 +- source/text/scalc/guide/datapilot_calculatedfield.xhp | 72 ++++++++++++++++++ 3 files changed, 78 insertions(+), 4 deletions(-)
New commits: commit 096545cb25c958c28712a4d3125b531c817f6c61 Author: Olivier Hallot <[email protected]> AuthorDate: Tue May 19 16:26:06 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Tue May 19 22:56:52 2026 +0200 tdf#172107 Documentation for "calculated field". Change-Id: I15f409c98227e20568d40919f6995950d768b0ee Reviewed-on: https://gerrit.libreoffice.org/c/help/+/205374 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 6b328d418d..7b7c9574ee 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -444,6 +444,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/guide/database_sort \ helpcontent2/source/text/scalc/guide/datapilot \ helpcontent2/source/text/scalc/guide/datapilot_createtable \ + helpcontent2/source/text/scalc/guide/datapilot_calculatedfield \ helpcontent2/source/text/scalc/guide/datapilot_formatting \ helpcontent2/source/text/scalc/guide/datapilot_deletetable \ helpcontent2/source/text/scalc/guide/datapilot_edittable \ diff --git a/source/text/scalc/guide/datapilot.xhp b/source/text/scalc/guide/datapilot.xhp index ae8cdaa769..5233db08ad 100644 --- a/source/text/scalc/guide/datapilot.xhp +++ b/source/text/scalc/guide/datapilot.xhp @@ -19,18 +19,18 @@ <helpdocument version="1.0"> <meta> <topic id="textscalcguidedatapilotxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Pivot Table</title> +<title id="tit">Pivot Table</title> <filename>/text/scalc/guide/datapilot.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3150448"><bookmark_value>pivot table function; introduction</bookmark_value> +<bookmark branch="index" id="bm_id3150448"><bookmark_value>pivot table function; introduction</bookmark_value> <bookmark_value>DataPilot, see pivot table function</bookmark_value> </bookmark> <h1 id="hd_id3150448"><variable id="datapilot"><link href="text/scalc/guide/datapilot.xhp">Pivot Table</link> </variable></h1> -<paragraph role="paragraph" id="par_id3156024" xml-lang="en-US">The <emph>pivot table</emph> (formerly known as <emph>DataPilot</emph>) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports.</paragraph> -<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US">A table that has been created as a <link href="text/scalc/01/12090000.xhp">pivot table</link> is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.</paragraph> +<paragraph role="paragraph" id="par_id3156024">The <emph>pivot table</emph> (formerly known as <emph>DataPilot</emph>) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports.</paragraph> +<paragraph role="paragraph" id="par_id3145069">A table that has been created as a <link href="text/scalc/01/12090000.xhp">pivot table</link> is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/> <section id="relatedtopics"> @@ -40,6 +40,7 @@ <embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/> <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/> <embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/> +<embed href="text/scalc/guide/datapilot_calculatedfield.xhp#h1"/> <embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/> <embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/> diff --git a/source/text/scalc/guide/datapilot_calculatedfield.xhp b/source/text/scalc/guide/datapilot_calculatedfield.xhp new file mode 100644 index 0000000000..71cd76ab3d --- /dev/null +++ b/source/text/scalc/guide/datapilot_calculatedfield.xhp @@ -0,0 +1,72 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + +<meta> + <topic id="text/scalc/guide/datapilot_calculatedfield.xhp" indexer="include" status="PUBLISH"> + <title id="tit">Pivot Table Calculated Field</title> + <filename>/text/scalc/guide/datapilot_calculatedfield.xhp</filename> + </topic> +</meta> +<body> +<bookmark id="bm_id771779151018515" branch="hid/modules/scalc/ui/pivotcalcfielddialog/PivotCalcField" localize="false"/> +<bookmark id="bm_id731779151018515" branch="hid/modules/scalc/ui/pivotcalcfielddialog/@@nowidget@@" localize="false"/> +<bookmark branch="index" id="bm_id651779216111106"> +<bookmark_value>pivot table;calculated field</bookmark_value> +<bookmark_value>calculated field;pivot table</bookmark_value> +</bookmark> +<section id="calculatedfield"> + <h1 id="hd_id391779151018515"><variable id="h1"><link href="text/scalc/guide/datapilot_calculatedfield.xhp">Pivot Table Calculated Field</link></variable></h1> + <description id="par_id791779151018515">Create a new pivot table data column using a custom formula.</description> +</section> +<paragraph role="paragraph" id="par_id741779215670448">A Calculated Field lets you add a new data column with a custom formula, and unlike manually entered columns, it becomes a built-in part of the Pivot Table. This ensures that sorting, filtering, and other Pivot Table functions work seamlessly.</paragraph> +<section id="howtoget"> + <paragraph role="paragraph" id="par_id581779217252143">Place cursor inside an existing pivot table, then</paragraph> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id591779217314215">Choose <menuitem>Data > Pivot Table > Calculated Field</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_context"/> + <paragraph role="paragraph" id="par_id71779217350764">Choose <menuitem>Calculated Field</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id471779218276448">On the <menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose <menuitem>Pivot Calculated Field</menuitem></paragraph> +</section> +<bookmark branch="hid/modules/scalc/ui/pivotcalcfielddialog/calcfieldscb" id="bm_id241779151385184" localize="false"/> +<h2 id="hd_id381779152416650">Name</h2> +<paragraph role="paragraph" id="par_id861779215700848">The name of the calculated field. This name will appear as an additional entry in the Fields list.</paragraph> +<bookmark branch="hid/modules/scalc/ui/pivotcalcfielddialog/calcentry" id="bm_id81779151412045" localize="false"/> +<h2 id="hd_id571779152543327">Formula</h2> +<paragraph role="paragraph" id="par_id731779215705911">The formula of the calculated field. The formula syntax is the same as any other formula cell in Calc.</paragraph> +<bookmark branch="hid/modules/scalc/ui/pivotcalcfielddialog/listbox-fields" id="bm_id1001779151416558" localize="false"/> +<h2 id="hd_id411779152548485">Fields</h2> +<paragraph role="paragraph" id="par_id961779215710863">Display the list of fields and calculated fields. All fields of this list can be used in calculated fields formulas.</paragraph> +<bookmark branch="hid/modules/scalc/ui/pivotcalcfielddialog/insertbtn" id="bm_id921779151420675" localize="false"/> +<h2 id="hd_id621779152553173">Insert Field</h2> +<paragraph role="paragraph" id="par_id281779215719060">Click to add the calculated field to the Field list.</paragraph> +<bookmark branch="hid/modules/scalc/ui/pivotcalcfielddialog/addbtn" id="bm_id851779151424837" localize="false"/> +<h2 id="hd_id541779152557453">Add</h2> +<paragraph role="paragraph" id="par_id831779196715514">Adds the calculated field to the pivot table fields.</paragraph> +<bookmark branch="hid/modules/scalc/ui/pivotcalcfielddialog/modbtn" id="bm_id141779151428517" localize="false"/> +<h2 id="hd_id331779152562869">Modify</h2> +<paragraph role="paragraph" id="par_id761779196720167">Modifies the calcullated field formula and update the Fields list.</paragraph> +<bookmark branch="hid/modules/scalc/ui/pivotcalcfielddialog/deletebtn" id="bm_id481779151433049" localize="false"/> +<h2 id="hd_id621779152567265">Delete</h2> +<paragraph role="paragraph" id="par_id81779196646476">Deletes the calculated field.</paragraph> +<embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/> +<section id="relatedtopics"> +<embed href="text/scalc/guide/datapilot.xhp#datapilot"/> +<embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> +<embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/> +<embed href="text/scalc/guide/datapilot_formatting.xhp#h1"/> +<embed href="text/scalc/guide/datapilot_filtertable.xhp#datapilot_filtertable"/> +<embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/> +<embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/> +<embed href="text/scalc/guide/pivotchart.xhp#pivotchart"/> +</section> +</body> +</helpdocument>
