commit bed4d8f1eb32a39bfce5c7fa8546dbab155706a7
author Rafael Lima <rafael.palma.lima@gmail.com> Sun Oct 30 00:21:34 2022 +0200
committer Olivier Hallot <olivier.hallot@libreoffice.org> Mon Oct 31 17:08:04 2022 +0100
tree a886b9cbe465c0b3cc97aac11a23705e2901ce21
parent d5736c124223e77d5a8d67c8c95bf141ee74ab5b

tdf#150465 Improve description of RANDBETWEEN in function wizard

As requested by the user, this patch makes it clearer that both Bottom and Top values may be returned by the RANDBETWEEN and RANDBETWEEN.NV functions, making the Function Wizard and the online Help descriptions more similar.

Change-Id: I730a9a5e42525f890c85c2489ef03797b812917a
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/141922
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

sc/inc/scfuncs.hrc

diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc
index 51d317d..0e9d2b0 100644
--- a/sc/inc/scfuncs.hrc
+++ b/sc/inc/scfuncs.hrc
@@ -4144,11 +4144,11 @@ const TranslateId SC_OPCODE_RANDOM_NV_ARY[] =
// -=*# Resource for function RANDBETWEEN.NV #*=-
const TranslateId SC_OPCODE_RANDBETWEEN_NV_ARY[] =
{
    NC_("SC_OPCODE_RANDBETWEEN_NV", "Returns a random integer between the numbers you specify, non-volatile."),
    NC_("SC_OPCODE_RANDBETWEEN_NV", "Returns a random integer between the specified Bottom and Top values (both inclusive), non-volatile."),
    NC_("SC_OPCODE_RANDBETWEEN_NV", "Bottom"),
    NC_("SC_OPCODE_RANDBETWEEN_NV", "The smallest integer returned."),
    NC_("SC_OPCODE_RANDBETWEEN_NV", "The smallest integer that can be returned."),
    NC_("SC_OPCODE_RANDBETWEEN_NV", "Top"),
    NC_("SC_OPCODE_RANDBETWEEN_NV", "The largest integer returned.")
    NC_("SC_OPCODE_RANDBETWEEN_NV", "The largest integer that can be returned.")
};

/* vim:set shiftwidth=4 softtabstop=4 expandtab: */

scaddins/inc/analysis.hrc

diff --git a/scaddins/inc/analysis.hrc b/scaddins/inc/analysis.hrc
index 3850911..b66233e 100644
--- a/scaddins/inc/analysis.hrc
+++ b/scaddins/inc/analysis.hrc
@@ -144,11 +144,11 @@ const TranslateId ANALYSIS_Sqrtpi[] =

const TranslateId ANALYSIS_Randbetween[] =
{
    NC_("ANALYSIS_Randbetween", "Returns a random integer between the numbers you specify"),
    NC_("ANALYSIS_Randbetween", "Returns a random integer between the specified Bottom and Top values (both inclusive)"),
    NC_("ANALYSIS_Randbetween", "Bottom"),
    NC_("ANALYSIS_Randbetween", "The smallest integer returned"),
    NC_("ANALYSIS_Randbetween", "The smallest integer that can be returned"),
    NC_("ANALYSIS_Randbetween", "Top"),
    NC_("ANALYSIS_Randbetween", "The largest integer returned")
    NC_("ANALYSIS_Randbetween", "The largest integer that can be returned")
};

const TranslateId ANALYSIS_Gcd[] =