From 572a8132e0e460b17c80c456dfb5e07f6b9a9c6a Mon Sep 17 00:00:00 2001 From: Mike Kaganski Date: Sun, 10 Nov 2019 12:42:33 +0200 Subject: 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 --- sc/inc/scfuncs.hrc | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'sc/inc') 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 #*=- -- cgit