From bc005e8c9c1e7a03da63c168d9e55e9918f08e6c Mon Sep 17 00:00:00 2001 From: Zdeněk Crhonek Date: Thu, 21 Jul 2016 19:50:15 +0200 Subject: update MONTHS test case Change-Id: I333fe1c0744563243723837a8ae27bfa7ba559d7 Reviewed-on: https://gerrit.libreoffice.org/27408 Tested-by: Jenkins Reviewed-by: jan iversen Tested-by: jan iversen --- sc/qa/unit/data/functions/fods/months.fods | 372 ++++++++++++++--------------- 1 file changed, 181 insertions(+), 191 deletions(-) diff --git a/sc/qa/unit/data/functions/fods/months.fods b/sc/qa/unit/data/functions/fods/months.fods index 828adfc2b365..8999a94ef792 100644 --- a/sc/qa/unit/data/functions/fods/months.fods +++ b/sc/qa/unit/data/functions/fods/months.fods @@ -1,7 +1,7 @@ - 2016-06-10T20:02:06.652576343P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/131e604073f89e6c1dd54be88b94b7befd881f2e + 2016-06-10T20:02:06.652576343P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/800a196718abbfd38d93c845e563e055ef778b04 0 @@ -28,10 +28,11 @@ 100 60 true + false 2 - 12 + 9 0 0 0 @@ -45,6 +46,7 @@ 100 60 true + false Sheet2 @@ -69,6 +71,7 @@ 1 1 true + false @@ -108,7 +111,7 @@ true 1 true - qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= false 0 @@ -132,214 +135,203 @@ - + - + - + - - + - + £ - + - £ - + - + £ - + - £ - + - + £ - + - £ - + - + £ - + - £ - + - + £ - + - £ - + - + - + ( ) - + - + - + ( ) - + - + £ - + - £ - + - + £ - + - £ - + - + - + - - + - + - + - - + - + - + - - + - + - + - - - - - $ - + - - - - - $ - - - - + - + - + - + - + - + - + - + - + - + - + @@ -348,7 +340,7 @@ - + @@ -366,60 +358,62 @@ - + - + - + - + - + - + - + - + - + - + - + - + - + - + - - . - . + / + + / : + + @@ -434,40 +428,40 @@ - + - + - + - + - + - + - + @@ -478,7 +472,7 @@ - + @@ -493,52 +487,45 @@ - + - + - + - - - - - - - - + - + - + - - - + + + - + - + @@ -547,21 +534,21 @@ - + - + - + - + @@ -584,7 +571,7 @@ ??? (???) - 00.00.0000, 00:00:00 + 00/00/0000, 00:00:00 @@ -616,7 +603,7 @@ Result - PRAVDA + TRUE @@ -639,7 +626,7 @@ 1 - PRAVDA + TRUE Simple MONTHS formulas with local references and values @@ -706,7 +693,7 @@ Comment - + @@ -717,10 +704,10 @@ 14 - PRAVDA + TRUE - - =MONTHS("2010-04-03"; "2011-06-17"; 0) + + =MONTHS("2010-04-03", "2011-06-17", 0) @@ -732,14 +719,14 @@ 0 - PRAVDA + TRUE - - =MONTHS("2010-03-31"; "2010-04-30"; 0) + + =MONTHS("2010-03-31", "2010-04-30", 0) - 33333,33 + 33333.33 @@ -751,10 +738,10 @@ 2 - PRAVDA + TRUE - - =MONTHS("2010-03-31"; "2010-06-30"; 0) + + =MONTHS("2010-03-31", "2010-06-30", 0) @@ -770,10 +757,10 @@ 14 - PRAVDA + TRUE - - =MONTHS("2010-04-03"; "2011-06-17"; 1) + + =MONTHS("2010-04-03", "2011-06-17", 1) @@ -785,10 +772,10 @@ 1 - PRAVDA + TRUE - - =MONTHS("2010-03-31"; "2010-04-01"; 1) + + =MONTHS("2010-03-31", "2010-04-01", 1) @@ -800,16 +787,16 @@ 1 - PRAVDA + TRUE - - =MONTHS(J7; K7; 1) + + =MONTHS(J7, K7, 1) - + 2010-03-31 - + 2010-04-01 @@ -822,19 +809,32 @@ 1 - PRAVDA + TRUE - - =MONTHS(day1; day2; 1) + + =MONTHS(day1, day2, 1) - + - - - + + Err:502 + + + error + + + TRUE + + + =MONTHS(day1, day2, 8999) + + + Tdf#100440 + + @@ -851,35 +851,30 @@ - + - - 0 - - - Error - + + + + + + - - =MONTHS(day1; day2; 8999) - - - Tdf#100440 - - + - + - + - + + - + @@ -887,23 +882,23 @@ - + - + - + - + @@ -915,7 +910,7 @@ - + @@ -927,7 +922,7 @@ - + @@ -939,7 +934,7 @@ - + @@ -951,7 +946,7 @@ - + @@ -963,7 +958,7 @@ - + @@ -976,7 +971,7 @@ - + @@ -984,7 +979,7 @@ - + @@ -992,7 +987,7 @@ - + @@ -1000,7 +995,7 @@ - + @@ -1008,7 +1003,7 @@ - + @@ -1016,14 +1011,14 @@ - - + + Age - + @@ -1032,7 +1027,7 @@ - + @@ -1042,15 +1037,10 @@ - - - - - - - + + -- cgit