summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2022-06-18 11:24:34 -0300
committerAdolfo Jayme Barrientos <fitojb@ubuntu.com>2022-06-25 19:08:45 +0200
commit310cc24de29d0b1bd7b6a49a18c3f7b38de47cdf (patch)
treec04d32cf15eecbaa849c680cd71ac701ac89b65f
parented3a241502df77ac5ef3aca25609e67f818047e4 (diff)
tdf#149393 cross-ref DECIMAL <-> BASE functions
Change-Id: I5f8a2e5d93ca0d723a6adfc31aa6cd3fcc7568c5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136085 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 4ab7e2cf0ecd45c000eb7605c1918265569e52f7) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136428 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
-rw-r--r--source/text/scalc/01/04060110.xhp13
-rw-r--r--source/text/scalc/01/common_func.xhp3
2 files changed, 11 insertions, 5 deletions
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index ff904317f0..d4a9c00161 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -103,7 +103,9 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BASIS" id="bm_id3150957" localize="false"/>
-
+<bookmark xml-lang="en-US" branch="index" id="bm_id3156399">
+ <bookmark_value>decimal system; converting to</bookmark_value>
+</bookmark>
<h2 id="hd_id3153072">BASE</h2>
<paragraph id="par_id3153289" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BASIS">Converts a positive integer to a specified base into a text from the <link href="text/shared/00/00000005.xhp#number_system" name="numbering system">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used.</paragraph>
@@ -114,10 +116,6 @@
<paragraph id="par_id3148746" role="paragraph" xml-lang="en-US"> <emph>MinimumLength</emph> (optional) determines the minimum length of the character sequence that has been created. If the text is shorter than the indicated minimum length, zeros are added to the left of the string.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3156399">
- <bookmark_value>decimal system; converting to</bookmark_value>
-</bookmark>
-
<paragraph id="par_id3156399" role="paragraph" xml-lang="en-US"> <item type="input">=BASE(17;10;4)</item> returns 0017 in the decimal system.</paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3157871">
<bookmark_value>binary system; converting to</bookmark_value>
@@ -129,6 +127,9 @@
</bookmark>
<paragraph id="par_id3145226" role="paragraph" xml-lang="en-US"> <item type="input">=BASE(255;16;4)</item> returns 00FF in the hexadecimal system.</paragraph>
+
+<embed href="text/scalc/01/common_func.xhp#sectionseealso"/>
+<paragraph role="paragraph" id="par_id991655560817321"><link href="text/scalc/01/04060110.xhp#decimal" name="decimal">DECIMAL</link></paragraph>
</section>
<section id="char">
@@ -224,6 +225,8 @@
<paragraph id="par_id3145355" role="paragraph" xml-lang="en-US"> <item type="input">=DECIMAL("17";10)</item> returns 17.</paragraph>
<paragraph id="par_id3155622" role="paragraph" xml-lang="en-US"> <item type="input">=DECIMAL("FACE";16)</item> returns 64206.</paragraph>
<paragraph id="par_id3151015" role="paragraph" xml-lang="en-US"> <item type="input">=DECIMAL("0101";2)</item> returns 5.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectionseealso"/>
+<paragraph role="paragraph" id="par_id421655560837244"><link href="text/scalc/01/04060110.xhp#base" name="base">BASE</link></paragraph>
</section>
<section id="dollar">
diff --git a/source/text/scalc/01/common_func.xhp b/source/text/scalc/01/common_func.xhp
index 21fb6f552f..3ec6b8e0b9 100644
--- a/source/text/scalc/01/common_func.xhp
+++ b/source/text/scalc/01/common_func.xhp
@@ -27,6 +27,9 @@
<section id="sectiontechinfo">
<h3 id="hd_id301640873452726">Technical information</h3>
</section>
+ <section id="sectionseealso">
+ <h3 id="hd_id371655560095924">See also</h3>
+ </section>
<section id="notODFF">
<paragraph role="paragraph" id="par_id251640873774457">This function is not part of the <emph>Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format</emph> standard. The name space is</paragraph>
</section>