From 1cef707d9e0f59d7137417533cb3d6f7ef16eae4 Mon Sep 17 00:00:00 2001 From: Zdeněk Crhonek Date: Thu, 21 Jul 2016 19:53:46 +0200 Subject: update years test case Change-Id: I796982f5675816a145048b906bbfcb8779b8c8c2 Reviewed-on: https://gerrit.libreoffice.org/27410 Tested-by: Jenkins Reviewed-by: jan iversen Tested-by: jan iversen --- sc/qa/unit/data/functions/fods/years.fods | 255 ++++++++++++++---------------- 1 file changed, 119 insertions(+), 136 deletions(-) (limited to 'sc') diff --git a/sc/qa/unit/data/functions/fods/years.fods b/sc/qa/unit/data/functions/fods/years.fods index 0c5575d8888a..724ee3476163 100644 --- a/sc/qa/unit/data/functions/fods/years.fods +++ b/sc/qa/unit/data/functions/fods/years.fods @@ -1,13 +1,13 @@ - 2016-06-16T21:00:15.480415068P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/83d5a4a9c256eaef4c04f799db38b373d9cff4d5 + 2016-06-16T21:00:15.480415068P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/800a196718abbfd38d93c845e563e055ef778b04 0 0 33007 - 15307 + 15264 view1 @@ -32,7 +32,7 @@ 2 - 11 + 12 0 0 0 @@ -50,7 +50,7 @@ Sheet2 - 567 + 1241 0 100 60 @@ -91,12 +91,10 @@ true true true - true - true false 12632256 false - Generic Printer + Lexmark-E352dn cs @@ -120,12 +118,14 @@ + true + true 3 1 true 1 true - kAH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAtgAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCm1hcmdpbmRhanVzdG1lbnQ9MCwwLDAsMApjb2xvcmRlcHRoPTI0CnBzbGV2ZWw9MApwZGZkZXZpY2U9MApjb2xvcmRldmljZT0wClBQRENvbnRleERhdGEKRHVwbGV4Ok5vbmUAUGFnZVNpemU6TGV0dGVyAAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= false 0 @@ -148,7 +148,6 @@ - @@ -592,102 +591,89 @@ - - - - - - - - - + - + - + - + - + - - - - - - + - + - + - + - + - + - + - + - + @@ -731,7 +717,7 @@ ??? (???) - 00/00/0000, 00:00:00 + 00/00/0000, 00:00:00 @@ -855,17 +841,17 @@ Comment - + DATA - + 1 - + - + #VALUE! @@ -875,11 +861,11 @@ TRUE - + =YEARS(K2,K3,K4:K6) - + 11/01/2014 @@ -895,14 +881,14 @@ err - + TRUE - + =YEARS(K2,K2,K2) - + 11/30/2017 @@ -911,29 +897,29 @@ - + 3 3 - + TRUE - + =YEARS(K2,K3,L2) - - + + 11/11/2014 - + 0 - + @@ -945,11 +931,11 @@ TRUE - + =YEARS(K2,K3,) - + 11/27/2014 @@ -968,11 +954,11 @@ TRUE - + =YEARS(K3,K2,) - + 11/28/2014 @@ -981,29 +967,29 @@ - + Err:504 err - + TRUE - + =YEARS(K2,K2+6,,{1;0;1;0;1;0;1}) - - + + 12/24/2001 - + 1 - + @@ -1012,14 +998,14 @@ 3 - + TRUE - + =YEARS(day1,day2,one) - + 12/25/2001 @@ -1031,14 +1017,14 @@ 2 - + TRUE - + =YEARS(DATE(2014,1,15),DATE(2016,4,1),0) - + 12/26/2001 @@ -1050,21 +1036,21 @@ Err - + TRUE - + =WEEKS(DATE(2014,11,1),DATE(2014,11,30),{"Hello";"Eike";"!"}) TDF#100409 - - + + 12/31/2001 - + @@ -1073,22 +1059,35 @@ 115 - + TRUE - + =YEARS(K16,K17,0) - + 01/01/2002 - - - + + Err:502 + + + Err + + + TRUE + + + =YEARS(DATE(2014,1,15),DATE(2016,4,1),2) + + + Tdf#100440 + + 17 @@ -1096,84 +1095,73 @@ - - + + - - + + 12/01/2001 - + - - + + - - + + - + 12/30/1899 - + - - + + 12/30/1899 - + - + Tdf#96756 bug - + 01/02/2015 - - Err:502 - - - err - - - - =YEARS(DATE(2014,1,15),DATE(2016,4,1),2) - - - Tdf#100440 - - + + + - - + + - + - + YEARSCalculates the difference in years between two dates.SyntaxYEARS(StartDate; EndDate; Type)StartDate is the first dateEndDate is the second dateType calculates the type of difference. Possible values are 0 (interval) and 1 (in calendar years). @@ -1181,44 +1169,44 @@ - + - + - + - + - + - + - + - + - + @@ -1228,7 +1216,7 @@ - + @@ -1243,35 +1231,30 @@ - + - + - + - - - - - - + - - + + -- cgit