From 91585d248c7eae60fde0956da3da95c55fafdbcc Mon Sep 17 00:00:00 2001 From: Zdeněk Crhonek Date: Mon, 23 May 2016 19:53:21 +0200 Subject: add DSTDEVP test case Change-Id: I263ed01d155c5939ff52487bcf0920acab4c1e5c Reviewed-on: https://gerrit.libreoffice.org/25374 Reviewed-by: Markus Mohrhard Tested-by: Markus Mohrhard --- sc/qa/unit/data/functions/fods/dstdevp.fods | 1357 +++++++++++++++++++++++++++ 1 file changed, 1357 insertions(+) create mode 100644 sc/qa/unit/data/functions/fods/dstdevp.fods diff --git a/sc/qa/unit/data/functions/fods/dstdevp.fods b/sc/qa/unit/data/functions/fods/dstdevp.fods new file mode 100644 index 000000000000..bfc321a5c3d8 --- /dev/null +++ b/sc/qa/unit/data/functions/fods/dstdevp.fods @@ -0,0 +1,1357 @@ + + + + 2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/369ca1d72bc877c6ccce991c92ae1a246956ca57 + + + 0 + 0 + 22009 + 4261 + + + view1 + + + 3 + 16 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 9 + 5 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet1 + 1241 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 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+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + DSTDEVP Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DSTDEVP formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + 3 + + + 3 + + + PRAVDA + + DSTDEVP(J1:N10;"Weight";J44:N45) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + + 4,14578098794425 + + + 4,14578098794425 + + + PRAVDA + + DSTDEVP(J1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + 4,5 + + + 4,5 + + + PRAVDA + + DSTDEVP(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + 4,17612260356422 + + + 4,17612260356422 + + + PRAVDA + + DSTDEVP(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + + 0 + + + 0 + + + PRAVDA + + DSTDEVP(J1:N10;"Weight";J23:N24) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + 4,5 + + + 4,5 + + + PRAVDA + + + DSTDEVP(J1:N10;"Weight";J56:N57) + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + + + + + Irene + + + 2 + + + 8 + + + 1000 + + + 42 + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 9 + + + + + + + + + 10 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 2 + + + >7 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + >=E + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + Frank + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 10 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 7 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 8 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + [E-F].* + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + \ No newline at end of file -- cgit