From e473e0e1b9bc354d53908cb0ca84db06c3051fe2 Mon Sep 17 00:00:00 2001 From: Zdeněk Crhonek Date: Sun, 28 Aug 2016 20:20:41 +0200 Subject: add HLOOKUP test case Change-Id: I4a4fcec694522060bede6ef66aed818b1dd37c14 Reviewed-on: https://gerrit.libreoffice.org/28442 Tested-by: Jenkins Reviewed-by: Markus Mohrhard --- sc/qa/unit/data/functions/fods/hlookup.fods | 1526 +++++++++++++++++++++++++++ 1 file changed, 1526 insertions(+) create mode 100644 sc/qa/unit/data/functions/fods/hlookup.fods (limited to 'sc') diff --git a/sc/qa/unit/data/functions/fods/hlookup.fods b/sc/qa/unit/data/functions/fods/hlookup.fods new file mode 100644 index 000000000000..12bedbe73f8c --- /dev/null +++ b/sc/qa/unit/data/functions/fods/hlookup.fods @@ -0,0 +1,1526 @@ + + + + 2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/989e8bc0d792f0dc5778746fac45de129a22d7ac + + + 0 + 0 + 22009 + 4261 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 80 + 60 + true + false + + + 2 + 34 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 12 + 0 + 80 + 60 + true + false + + + Sheet2 + 591 + 0 + 80 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + false + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00/00/0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + HLOOKUP Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple HLOOKUP formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Axles + + + Bearings + + + Bolts + + + + Order ID + + + 10247 + + + 10249 + + + 10250 + + + 10251 + + + 10252 + + + 10253 + + + + 2 + + + 4 + + + 8 + + + B + + + D + + + H + + + 1 + + + 3 + + + b + + + d + + + + + 4 + + + 4 + + + TRUE + + + =HLOOKUP("Axles", I1:K4, 2, 1) + + + + 4 + + + 9 + + + + Unit Price + + + 14 + + + 18.6 + + + 7.7 + + + 16.8 + + + 64.8 + + + + one + + + two + + + three + + + four + + + + + 7 + + + 7 + + + TRUE + + + =HLOOKUP("Bearings", I1:K4, 3, 0) + + + + 5 + + + 7 + + + 10 + + + + Quantity + + + 12 + + + 9 + + + 10 + + + 6 + + + 20 + + + 40 + + + + 1 + + + + + + 5 + + + 5 + + + TRUE + + + =HLOOKUP("B", I1:K4, 3, 1) + + + + 6 + + + 8 + + + 11 + + + + + 2 + + + + 0 + + + + + + 11 + + + 11 + + + TRUE + + + =HLOOKUP("Bolts", I1:K4, 4) + + + + + + + 3 + + + + 1 + + + + + + c + + + c + + + TRUE + + + =HLOOKUP(3, {1,2,3;"a","b","c";"d","e","f"}, 2, 1) + + + + + + 4 + + + + 2 + + + + + + 16.8 + + + 16.8 + + + TRUE + + + =HLOOKUP(10251, M1:S3, 2, 0) + + + + + + 5 + + + + 3 + + + + + + #N/A + + + #N/A + + + TRUE + + + =HLOOKUP(10248, M1:S3, 2, 0) + + + + + + + 6 + + + + 4 + + + + + + 14 + + + 14 + + + TRUE + + + =HLOOKUP(10248, M1:S3, 2, 1) + + + + + + 7 + + + + a + + + + + + 16.8 + + + 16.8 + + + TRUE + + + =HLOOKUP(10251, M1:S3, 2, 0) + + + + + + 8 + + + + b + + + + + + #N/A + + + #N/A + + + TRUE + + + =HLOOKUP(U3,$U$1:$AB$1,1) + + + + + + 9 + + + + c + + + + + + 2 + + + 2 + + + TRUE + + + =HLOOKUP(U4,$U$1:$AB$1,1) + + + + + + A + + + + d + + + + + + 2 + + + 2 + + + TRUE + + + =HLOOKUP(U5,$U$1:$AB$1,1) + + + + + + + B + + + + e + + + + + + 4 + + + 4 + + + TRUE + + + =HLOOKUP(U6,$U$1:$AB$1,1) + + + + C + + + + + + 4 + + + 4 + + + TRUE + + + =HLOOKUP(U7,$U$1:$AB$1,1) + + + + D + + + + + + 4 + + + 4 + + + TRUE + + + =HLOOKUP(U8,$U$1:$AB$1,1) + + + + E + + + + + + 4 + + + 4 + + + TRUE + + + =HLOOKUP(U9,$U$1:$AB$1,1) + + + + + + F + + + + + + 8 + + + 8 + + + TRUE + + + =HLOOKUP(U10,$U$1:$AB$1,1) + + + + G + + + + + + 8 + + + 8 + + + TRUE + + + =HLOOKUP(U11,$U$1:$AB$1,1) + + + + H + + + + + + #N/A + + + #N/A + + + TRUE + + + =HLOOKUP(U12,$U$1:$AB$1,1) + + + + + + I + + + + + + B + + + B + + + TRUE + + + =HLOOKUP(U13,$U$1:$AB$1,1) + + + + + + + + B + + + B + + + TRUE + + + =HLOOKUP(U14,$U$1:$AB$1,1) + + + + + + D + + + D + + + TRUE + + + =HLOOKUP(U15,$U$1:$AB$1,1) + + + + + + + + D + + + D + + + TRUE + + + =HLOOKUP(U16,$U$1:$AB$1,1) + + + + + + D + + + D + + + TRUE + + + =HLOOKUP(U17,$U$1:$AB$1,1) + + + + + + D + + + D + + + TRUE + + + =HLOOKUP(U18,$U$1:$AB$1,1) + + + + + + + + H + + + H + + + TRUE + + + =HLOOKUP(U19,$U$1:$AB$1,1) + + + + + + H + + + H + + + TRUE + + + =HLOOKUP(U20,$U$1:$AB$1,1) + + + + + + #N/A + + + #N/A + + + TRUE + + + =HLOOKUP(AC4,$AC$1:$AF$2,2) + + + + + + one + + + one + + + TRUE + + + =HLOOKUP(AC5,$AC$1:$AF$2,2) + + + + + + one + + + one + + + TRUE + + + =HLOOKUP(AC6,$AC$1:$AF$2,2) + + + + + + two + + + two + + + TRUE + + + =HLOOKUP(AC7,$AC$1:$AF$2,2) + + + + + + two + + + two + + + TRUE + + + =HLOOKUP(AC8,$AC$1:$AF$2,2) + + + + + + + + #N/A + + + #N/A + + + TRUE + + + =HLOOKUP(AC9,$AC$1:$AF$2,2) + + + + + + three + + + three + + + TRUE + + + =HLOOKUP(AC10,$AC$1:$AF$2,2) + + + + + + three + + + three + + + TRUE + + + =HLOOKUP(AC11,$AC$1:$AF$2,2) + + + + + + four + + + four + + + TRUE + + + =HLOOKUP(AC12,$AC$1:$AF$2,2) + + + + + + four + + + four + + + TRUE + + + =HLOOKUP(AC13,$AC$1:$AF$2,2) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + \ No newline at end of file -- cgit