source/text/swriter/02/14020000.xhp | 51 ++++++++++++++++++++++++------------ 1 file changed, 34 insertions(+), 17 deletions(-)
New commits: commit c8e6db62fb887e420f55a5d0c0d85b98d320682c Author: Olivier Hallot <[email protected]> AuthorDate: Thu Jun 12 11:49:18 2025 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Thu Jun 12 20:45:03 2025 +0200 tdf#123384, tdf#166948 Writer MOD function Help Change-Id: Ia0295ba01a930bb3b21acab8d48c6dff5a622843 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/186426 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/source/text/swriter/02/14020000.xhp b/source/text/swriter/02/14020000.xhp index 0b3302e6da..9449e3495c 100644 --- a/source/text/swriter/02/14020000.xhp +++ b/source/text/swriter/02/14020000.xhp @@ -44,22 +44,28 @@ </section> <paragraph role="paragraph" id="par_id3149096">The formula appears in the input line. To specify a range of cells in a table, select the desired cells with the mouse. The corresponding cell references also appear in the input line. Enter additional parameters, as necessary, and click <emph>Apply</emph> to confirm your entry. You can also enter the formula directly if you know the appropriate syntax. This is necessary, for example, in the <link href="text/swriter/01/04090000.xhp"><emph>Insert Fields</emph></link> and <emph>Edit Fields</emph> dialogs.</paragraph> <section id="howtoget"> - <paragraph role="paragraph" id="par_id301663685328962">Go to <menuitem>Table - Edit Formula</menuitem>.</paragraph> - <paragraph role="paragraph" id="par_id101599562003431">In the Table toolbar, press the <emph>Insert or Edit Formula</emph> icon.</paragraph> - <paragraph role="paragraph" id="par_id621599564033048">In a text document, press <keycode>F2</keycode>.</paragraph> -<section id="syformula"> -<table id="tbl_id3153634"> -<tablerow> -<tablecell> -<paragraph role="paragraph" id="par_id3155142"> -<image id="img_id3155148" src="sw/res/sc20556.png" width="1cm" height="1cm"><alt id="alt_id3155148">Formula icon in Table toolbar</alt></image></paragraph> -</tablecell> -<tablecell> -<paragraph role="paragraph" id="par_id3150113">Formula</paragraph> -</tablecell> -</tablerow> -</table> -</section> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id301663685328962">Go to <menuitem>Table - Edit Formula</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id551749743717732">In the <menuitem>Table</menuitem> tab, choose <menuitem>Edit Formula</menuitem></paragraph> + <embed href="text/shared/00/00000004.xhp#from_sidebar"/> + <paragraph role="paragraph" id="par_id451749743863827">Open the <menuitem>Table</menuitem> panel of the <menuitem>Properties</menuitem> deck, choose <menuitem>Edit Formula</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <section id="syformula"> + <table id="tbl_id3153634"> + <tablerow> + <tablecell> + <paragraph role="paragraph" id="par_id3155142"> + <image id="img_id3155148" src="cmd/sc_dbviewfunctions.svg" width="1cm" height="1cm"><alt id="alt_id3155148">Formula icon in Table toolbar</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph role="paragraph" id="par_id3150113">Formula</paragraph> + </tablecell> + </tablerow> + </table> + </section> + <embed href="text/shared/00/00000004.xhp#from_keyboard"/> + <paragraph role="paragraph" id="par_id621599564033048">Press <keycode>F2</keycode>.</paragraph> </section> <h2 id="hd_id3150691">Summary of Formula Options</h2> <h3 id="hd_id3155858">Basic Calculation Functions</h3> @@ -543,7 +549,18 @@ <paragraph role="paragraph" id="par_id941599563922444">Example: INT 2.6 returns 2</paragraph> </tablecell> </tablerow> - +<tablerow> + <tablecell> + <paragraph id="par_id521749736044752" role="paragraph">Integer division remainder</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id341749736047968" role="paragraph" localize="false">MOD</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id161749736050864" role="paragraph">Returns the remainder when one integer is divided by another.</paragraph> + <paragraph role="paragraph" id="par_id961749736054176">Example: MOD(18 | 4) returns 2</paragraph> + </tablecell> +</tablerow> </table> <h3 id="hd_id3150888">Variables for document properties</h3> <paragraph role="paragraph" id="par_id3150161">The following document properties are also found under <emph>File - Properties - Statistics</emph>.</paragraph>
