From 4ab7e2cf0ecd45c000eb7605c1918265569e52f7 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Sat, 18 Jun 2022 11:24:34 -0300 Subject: 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 --- source/text/scalc/01/04060110.xhp | 13 ++++++++----- source/text/scalc/01/common_func.xhp | 3 +++ 2 files changed, 11 insertions(+), 5 deletions(-) (limited to 'source/text/scalc') diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index cb75657ad3..41c4382016 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -103,7 +103,9 @@ - + + decimal system; converting to +

BASE

Converts a positive integer to a specified base into a text from the numbering system. The digits 0-9 and the letters A-Z are used. @@ -114,10 +116,6 @@ MinimumLength (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. - - decimal system; converting to - - =BASE(17;10;4) returns 0017 in the decimal system. binary system; converting to @@ -129,6 +127,9 @@ =BASE(255;16;4) returns 00FF in the hexadecimal system. + + +DECIMAL
@@ -224,6 +225,8 @@ =DECIMAL("17";10) returns 17. =DECIMAL("FACE";16) returns 64206. =DECIMAL("0101";2) returns 5. + +BASE
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 @@

Technical information

+
+

See also

+
This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is
-- cgit