wangxin/help
1
0
Fork 0
forked from amazingfate/help
Code Pull Requests Activity
Files
master
help/source/text/sdatabase/rep_navigator.xhp
Ilmari Lauhakangas 7e42394ecb tdf#152323 drop name attribute from <link> elements 
Replacement done with

find . -name \*.xhp -print0 |xargs -0 -P 0 perl -CS -pi -e \
        's#(<link[^>]*?) +name *="[^"]*" *( [^>]+|) *>#$1$2>#g'

(note some inconsistencies with space between name and = and also having
empty value, and some more complicated expression to also clear up
double space before/after the attribute)

translation files will be prepped with:

find */helpcontent2 -name \*.po -print0 |xargs -0 -P 0 perl -CS -pi -e \
    $'s#(<link[^>]*?) +name=(?:\\\\"[^"]*\\\\"|\'[^\']*\') *( [^>]+|) *(/?>)#$1$2$3#g unless /^#/'

(note that not all languages use the " as quote character for the
attributes, but that also single quotes appera in the po file. Hence
the use of the shell $'string' syntax to be able to quote ' as \'
It also requires to quote the backslash, so that it needs to be escaped
once for the shell, then another time for perl. Also don't work on
obsolete strings (those are prefixed with #~ in the po files)
Also note that <link..></link> gets turned into <link ../> during
translation extraction (along with removal of the space between the
attribute name and the value), so the pattern needs to be slightly
different here)

Change-Id: I95e53a08e6b0095cd894109ea0de154cc4859d8f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143713
Tested-by: Jenkins
Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
2022-12-07 17:39:02 +00:00

71 lines
6.7 KiB
XML
Raw Permalink Blame History

<?xml version="1.0" encoding="UTF-8"?>
<!--
* 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/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabaserep_navigatorxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Report Navigator</title>
<filename>/text/sdatabase/rep_navigator.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id5823847"><bookmark_value>formulas in reports;editing</bookmark_value>
<bookmark_value>functions in reports;editing</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:ReportNavigator" id="bm_id8798791" localize="false"/><h1 id="hd_id1821955"><variable id="rep_navigator"><link href="text/sdatabase/rep_navigator.xhp">Report Navigator</link>
</variable></h1>
<paragraph role="paragraph" id="par_id1150852" xml-lang="en-US">You can open the Report Navigator window of the <link href="text/sdatabase/rep_main.xhp">Report Builder</link> by choosing <item type="menuitem">View - Report Navigator</item>.</paragraph>
<paragraph role="paragraph" id="par_id1111484" xml-lang="en-US"><ahelp hid=".">The Report Navigator reveals the structure of the report. You can use the Report Navigator to insert functions into the report.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_REPORT_NAVIGATOR_TREE" id="bm_id7007354" localize="false"/><paragraph role="paragraph" id="par_id8314157" xml-lang="en-US"><ahelp hid=".">Click an entry in the Report Navigator. The corresponding object or area is selected in the Report Builder view. Right-click an entry to open the context menu.</ahelp></paragraph>
<h2 id="hd_id2932828">To enter functions to the report</h2>
<bookmark xml-lang="en-US" branch="hid/.uno:NewFunction" id="bm_id974456" localize="false"/><paragraph role="paragraph" id="par_id5091708" xml-lang="en-US"><ahelp hid=".">In the context menu of the Report Navigator, you see the same commands as in the Report Builder view, plus additional commands to create new functions or to delete them.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id9449446" xml-lang="en-US">Functions can be entered using a syntax as specified by the <link href="https://en.wikipedia.org/wiki/OpenFormula">OpenFormula</link> proposal.</paragraph>
<paragraph role="paragraph" id="par_id4095583" xml-lang="en-US">See <link href="https://wiki.documentfoundation.org/Database">Wiki page about Base</link> for some more help regarding the functions in a report.</paragraph>
<h3 id="hd_id311593">To calculate a sum for each client<comment>copied from a mail by Ocke - did not test</comment></h3>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id3948789" xml-lang="en-US">Open the Report Navigator.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id5391399" xml-lang="en-US">Open the Groups entry and the group where you want to calculate the cost. </paragraph>
<paragraph role="paragraph" id="par_id6989654" xml-lang="en-US">The group has a sub entry called functions. </paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id1803643" xml-lang="en-US">Open the context menu (right click) on the functions entry, choose to create a new function, and select it. </paragraph>
<paragraph role="paragraph" id="par_id868251" xml-lang="en-US">In the property browser you see the function. </paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id6247749" xml-lang="en-US">Change the name to e.g. CostCalc and the formula to [CostCalc] + [enter your cost column name].</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id1565904" xml-lang="en-US">In the initial value enter 0.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id1569261" xml-lang="en-US">Now you can insert a text field and bind it to your [CostCalc] (appears in the data field list box).</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id9256874" xml-lang="en-US">Maybe you have to set the initial value to the value of the field like [field].<comment>these 3 paras copied from another mail by Ocke in users@dba.o.o</comment></paragraph>
<paragraph role="paragraph" id="par_id4601886" xml-lang="en-US">If there are blank fields in the cost column, use the following formula to replace the blank fields' content with zero:</paragraph>
<paragraph role="code" id="par_id1754509" xml-lang="en-US">[SumCost] + IF(ISBLANK([field]);0;[field])</paragraph><comment>need some real working examples. See i81874</comment><comment>Formula</comment>
<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_FORMULA" id="bm_id2767113" localize="false"/><paragraph role="paragraph" id="par_id8122196" xml-lang="en-US"><ahelp hid="." visibility="hidden">Enter the formula that defines the function. Use OpenFormula syntax.</ahelp></paragraph><comment>Initial value</comment>
<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_INITIALFORMULA" id="bm_id301828" localize="false"/><paragraph role="paragraph" id="par_id9909665" xml-lang="en-US"><ahelp hid="." visibility="hidden">Enter the initial value for the evaluation of the formula. Often this is set to 0 or to 1.</ahelp></paragraph><comment>Deep traversing</comment>
<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_DEEPTRAVERSING" id="bm_id8996246" localize="false"/><paragraph role="paragraph" id="par_id9141819" xml-lang="en-US"><ahelp hid="." visibility="hidden">If Deep traversing is enabled, functions are evaluated considering all lower levels of hierarchy. This would be used for instance for line numbering. If Deep traversing is not enabled, only the first level of hierarchy is evaluated.</ahelp></paragraph><comment>Pre evaluation</comment>
<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_PREEVALUATED" id="bm_id5729544" localize="false"/><paragraph role="paragraph" id="par_id6354869" xml-lang="en-US"><ahelp hid="." visibility="hidden">If Pre evaluation is enabled, functions are evaluated only when the report is finished.</ahelp></paragraph>
</body>
</helpdocument>
View Git Blame Copy Permalink