diff options
| author | Mavridis Philippe <mavridisf@gmail.com> | 2024-04-05 18:08:02 +0300 |
|---|---|---|
| committer | TDE Gitea <gitea@mirror.git.trinitydesktop.org> | 2024-05-18 08:23:18 +0000 |
| commit | 76f5e81662ade526958e24dee91adaf03a294c72 (patch) | |
| tree | 339b4e7faa0e8795e3d8037584138f9f40b2bb0d /kspread/extensions | |
| parent | 4f21f4038f558fa330c307cc3745d6c3568b8b56 (diff) | |
| download | koffice-76f5e81662ade526958e24dee91adaf03a294c72.tar.gz koffice-76f5e81662ade526958e24dee91adaf03a294c72.zip | |
KSpread: New lookup/reference functions
Adds reference functions HLOOKUP, VLOOKUP.
Import from Calligra revision 1134327.
Authors: Stefan Nikolaus <stefan.nikolaus@kdemail.net>
Sebastian Sauer <mail@dipe.org>
Signed-off-by: Mavridis Philippe <mavridisf@gmail.com>
Diffstat (limited to 'kspread/extensions')
| -rw-r--r-- | kspread/extensions/reference.xml | 54 |
1 files changed, 53 insertions, 1 deletions
diff --git a/kspread/extensions/reference.xml b/kspread/extensions/reference.xml index 01715bf4..2b0af0bc 100644 --- a/kspread/extensions/reference.xml +++ b/kspread/extensions/reference.xml @@ -201,7 +201,59 @@ <Example>LOOKUP(1.232; A1:A6; B1:B6) for A1 = 1, A2 = 2 returns the value of B1.</Example> </Help> </Function> - + + <Function> + <Name>HLOOKUP</Name> + <Type>String/Numeric</Type> + <Parameter> + <Comment>Lookup value</Comment> + <Type>String/Numeric</Type> + </Parameter> + <Parameter> + <Comment>Data source</Comment> + <Type>Array</Type> + </Parameter> + <Parameter> + <Comment>Row</Comment> + <Type>Int</Type> + </Parameter> + <Parameter> + <Comment>Sorted (optional)</Comment> + <Type>Boolean</Type> + </Parameter> + <Help> + <Text>Look for a matching value in the first row of the given table, and return the value of the indicated row.</Text> + <Text>Looks up the 'lookup value' in the first row of the 'data source'. If a value matches, the value in the 'row' and the column, the value was found in, is returned. If 'sorted' is true (default), the first row is assumed to be sorted. The search will end, if the 'lookup value' is lower than the value, currently compared to.</Text> + <Syntax>HLOOKUP(Lookup value; data source; Row; Sorted)</Syntax> + </Help> + </Function> + + <Function> + <Name>VLOOKUP</Name> + <Type>String/Numeric</Type> + <Parameter> + <Comment>Lookup value</Comment> + <Type>String/Numeric</Type> + </Parameter> + <Parameter> + <Comment>Data source</Comment> + <Type>Array</Type> + </Parameter> + <Parameter> + <Comment>Column</Comment> + <Type>Int</Type> + </Parameter> + <Parameter> + <Comment>Sorted (optional)</Comment> + <Type>Boolean</Type> + </Parameter> + <Help> + <Text>Look for a matching value in the first column of the given table, and return the value of the indicated column.</Text> + <Text>Looks up the 'lookup value' in the first column of the 'data source'. If a value matches, the value in the 'column' and the row, the value was found in, is returned. If 'sorted' is true (default), the first column is assumed to be sorted. The search will end, if the 'lookup value' is lower than the value, currently compared to.</Text> + <Syntax>VLOOKUP(Lookup value; data source; Column; Sorted)</Syntax> + </Help> + </Function> + </Group> </KSpreadFunctions> |