summaryrefslogtreecommitdiff
path: root/sc/inc
diff options
context:
space:
mode:
authorMike Kaganski <mike.kaganski@collabora.com>2019-11-10 12:42:33 +0200
committerMike Kaganski <mike.kaganski@collabora.com>2019-11-11 13:47:54 +0100
commit572a8132e0e460b17c80c456dfb5e07f6b9a9c6a (patch)
tree94ad46abbe7322c4f2f537f477ed5d77df2a0fb9 /sc/inc
parent0bf1c44884954bd10be59a738302da603923b481 (diff)
tdf#121090: Correct the last argument to HLOOKUP/VLOOKUP description
The argument is meant to define semantical meaning of the array's first column, not just define if it's sorted or not. Change-Id: I87ff172bcc13d6471ee4025e74962be89f1b0b50 Reviewed-on: https://gerrit.libreoffice.org/82376 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
Diffstat (limited to 'sc/inc')
-rw-r--r--sc/inc/scfuncs.hrc8
1 files changed, 4 insertions, 4 deletions
diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc
index 5bcbb648e0dc..77031c5a5ac8 100644
--- a/sc/inc/scfuncs.hrc
+++ b/sc/inc/scfuncs.hrc
@@ -3358,8 +3358,8 @@ const char* SC_OPCODE_H_LOOKUP_ARY[] =
NC_("SC_OPCODE_H_LOOKUP", "The array or the range for the reference."),
NC_("SC_OPCODE_H_LOOKUP", "Index"),
NC_("SC_OPCODE_H_LOOKUP", "The row index in the array."),
- NC_("SC_OPCODE_H_LOOKUP", "Sorted"),
- NC_("SC_OPCODE_H_LOOKUP", "If the value is TRUE or not given, the search row of the array must be sorted in ascending order.")
+ NC_("SC_OPCODE_H_LOOKUP", "Sorted range lookup"),
+ NC_("SC_OPCODE_H_LOOKUP", "If the value is TRUE or not given, the search row of the array represents a series of ranges, and must be sorted in ascending order.")
};
// -=*# Resource for function VLOOKUP #*=-
@@ -3372,8 +3372,8 @@ const char* SC_OPCODE_V_LOOKUP_ARY[] =
NC_("SC_OPCODE_V_LOOKUP", "The array or range for referencing."),
NC_("SC_OPCODE_V_LOOKUP", "Index"),
NC_("SC_OPCODE_V_LOOKUP", "Column index number in the array."),
- NC_("SC_OPCODE_V_LOOKUP", "Sort order"),
- NC_("SC_OPCODE_V_LOOKUP", "If the value is TRUE or not given, the search column of the array must be sorted in ascending order.")
+ NC_("SC_OPCODE_V_LOOKUP", "Sorted range lookup"),
+ NC_("SC_OPCODE_V_LOOKUP", "If the value is TRUE or not given, the search column of the array represents a series of ranges, and must be sorted in ascending order.")
};
// -=*# Resource for function INDEX #*=-