From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- sc/qa/unit/data/functions/date_time/fods/date.fods | 1315 ++++++++++ .../data/functions/date_time/fods/datedif.fods | 2673 ++++++++++++++++++++ .../data/functions/date_time/fods/datevalue.fods | 836 ++++++ sc/qa/unit/data/functions/date_time/fods/day.fods | 863 +++++++ sc/qa/unit/data/functions/date_time/fods/days.fods | 802 ++++++ .../data/functions/date_time/fods/days360.fods | 1279 ++++++++++ .../data/functions/date_time/fods/daysinmonth.fods | 853 +++++++ .../data/functions/date_time/fods/daysinyear.fods | 838 ++++++ .../functions/date_time/fods/eastersunday.fods | 1008 ++++++++ .../unit/data/functions/date_time/fods/edate.fods | 1085 ++++++++ .../data/functions/date_time/fods/eomonth.fods | 998 ++++++++ sc/qa/unit/data/functions/date_time/fods/hour.fods | 2450 ++++++++++++++++++ .../data/functions/date_time/fods/isleapyear.fods | 993 ++++++++ .../data/functions/date_time/fods/isoweeknum.fods | 1171 +++++++++ .../unit/data/functions/date_time/fods/minute.fods | 1130 +++++++++ .../unit/data/functions/date_time/fods/month.fods | 1035 ++++++++ .../unit/data/functions/date_time/fods/months.fods | 1061 ++++++++ .../data/functions/date_time/fods/networkdays.fods | 1158 +++++++++ .../functions/date_time/fods/networkdays.intl.fods | 1403 ++++++++++ .../date_time/fods/networkdays_excel2003.fods | 1080 ++++++++ .../unit/data/functions/date_time/fods/second.fods | 1136 +++++++++ sc/qa/unit/data/functions/date_time/fods/time.fods | 1098 ++++++++ .../data/functions/date_time/fods/timevalue.fods | 882 +++++++ .../data/functions/date_time/fods/weekday.fods | 1079 ++++++++ .../data/functions/date_time/fods/weeknum.fods | 1148 +++++++++ .../unit/data/functions/date_time/fods/weeks.fods | 1206 +++++++++ .../data/functions/date_time/fods/weeksinyear.fods | 1138 +++++++++ .../data/functions/date_time/fods/workday.fods | 1066 ++++++++ .../functions/date_time/fods/workday.intl.fods | 2341 +++++++++++++++++ sc/qa/unit/data/functions/date_time/fods/year.fods | 1008 ++++++++ .../data/functions/date_time/fods/yearfrac.fods | 1479 +++++++++++ .../unit/data/functions/date_time/fods/years.fods | 1277 ++++++++++ 32 files changed, 38889 insertions(+) create mode 100644 sc/qa/unit/data/functions/date_time/fods/date.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/datedif.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/datevalue.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/day.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/days.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/days360.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/daysinmonth.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/daysinyear.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/eastersunday.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/edate.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/eomonth.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/hour.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/isleapyear.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/isoweeknum.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/minute.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/month.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/months.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/networkdays.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/networkdays.intl.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/networkdays_excel2003.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/second.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/time.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/timevalue.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/weekday.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/weeknum.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/weeks.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/weeksinyear.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/workday.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/workday.intl.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/year.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/yearfrac.fods create mode 100644 sc/qa/unit/data/functions/date_time/fods/years.fods (limited to 'sc/qa/unit/data/functions/date_time/fods') diff --git a/sc/qa/unit/data/functions/date_time/fods/date.fods b/sc/qa/unit/data/functions/date_time/fods/date.fods new file mode 100644 index 000000000..b8f729764 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/date.fods @@ -0,0 +1,1315 @@ + + + + 2016-05-26T15:42:48.977846871P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 22009 + 4261 + + + view1 + + + 2 + 12 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 3 + 20 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DATE Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DATE formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + + 31.01.1983 + + + 31.01.1983 + + + PRAVDA + + + DATE(1983;1;31) + + + + + + 31.01.1983 + + + 31.01.1983 + + + PRAVDA + + + DATE(year;month;day) + + + + + + 31.01.1983 + + + 31.01.1983 + + + PRAVDA + + DATE(J4;J5;J6) + + + + 1983 + + + + 3 + + + + + + 31.12.1982 + + + 31.12.1982 + + + PRAVDA + + DATE(J4;;J6) + + + missing month / If the values for month and day are out of bounds, they are carried over to the next digit. If you enter =DATE(00;12;31) the result will be 12/31/00. If, on the other hand, you enter =DATE(00;13;31) the result will be 1/31/01. + + + + 1 + + + + 6 + + + + + + Err:511 + + + #error + + + PRAVDA + + DATE(;J5;J6) + + + missing year + + + + 31 + + + + 2002 + + + + + + 31.12.1982 + + + 31.12.1982 + + + PRAVDA + + DATE(J4;J5;) + + + missing day + + + + + + 03.06.2002 + + + 03.06.2002 + + + PRAVDA + + DATE(L6;L5;L4) + + + The year formatted as text + + + + + + 31.12.2000 + + + 31.12.2000 + + + PRAVDA + + + DATE(0;12;31) + + + + + + 31.01.2001 + + + 31.01.2001 + + + PRAVDA + + + DATE(0;13;31) + + + + + + 31.12.1982 + + + 31.12.1982 + + + PRAVDA + + DATE(J4;0;J6) + + + + + + 31.12.1982 + + + 31.12.1982 + + + PRAVDA + + DATE(J4;J5;0) + + + + + + 30.12.1982 + + + 30.12.1982 + + + PRAVDA + + DATE(J4;J5;-1) + + + + + + + + 30.11.1999 + + + 30.11.1999 + + + PRAVDA + + + DATE(0;0;0) + + Year 0 is evaluated as a year with 1 or 2 digits => 2000 => date 2000-01-01Month 0 decrements the date by 1 month => 1999-12-01Day 0 decrements the date by 1 day => 1999-11-30 + + + + + + 01.10.2001 + + + 01.10.2001 + + + PRAVDA + + + DATE(1;10;1) + + + + + + + 01.01.2010 + + + 01.01.2010 + + + PRAVDA + + + DATE(10;1;1) + + + + + + + #VALUE! + + + #VALUE! + + + PRAVDA + + + DATE(100;1;1) + + The #VALUE! because the Gregorian calendar starts in year 1583, welikely could do better there and use the prolapsing Gregorian calendarfor earlier dates, but the help states that. We do recognize earlierdates in cell input, like 100-01-01 => 0100-01-01 or 099-01-01 =>0099-01-01 and can calculate with them. + + + + + + + #VALUE! + + + #VALUE! + + + PRAVDA + + + DATE(1000;1;1) + + + + + + + 01.01.1899 + + + 01.01.1899 + + + PRAVDA + + + DATE(1899;1;1) + + + + + + + 01.01.1900 + + + 01.01.1900 + + + PRAVDA + + + DATE(1900;1;1) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Age + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/datedif.fods b/sc/qa/unit/data/functions/date_time/fods/datedif.fods new file mode 100644 index 000000000..9b09a9bd8 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/datedif.fods @@ -0,0 +1,2673 @@ + + + + 2016-05-26T16:38:23.158699521P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 38680 + 51674 + + + view1 + + + 1 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 5 + 85 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 82 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DATEDIF Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DATEDIF formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + d + + + m + + + y + + + ym + + + md + + + yd + + + + + 365 + + + 365 + + + PRAVDA + + + =DATEDIF($K2;$L2;K$1) + + + + 2011-02-01 + + + 2012-02-01 + + + + + + 29 + + + 29 + + + PRAVDA + + + =DATEDIF($K3;$L3;K$1) + + + + 2012-02-01 + + + 2012-03-01 + + + + + + 365 + + + 365 + + + PRAVDA + + + =DATEDIF($K4;$L4;K$1) + + + + 2012-03-28 + + + 2013-03-28 + + + + + + 366 + + + 366 + + + PRAVDA + + + =DATEDIF($K5;$L5;K$1) + + + + 2012-03-28 + + + 2013-03-29 + + + + + + 364 + + + 364 + + + PRAVDA + + + =DATEDIF($K6;$L6;K$1) + + + + 2012-03-29 + + + 2013-03-28 + + + + + + 365 + + + 365 + + + PRAVDA + + + =DATEDIF($K7;$L7;K$1) + + + + 2012-02-29 + + + 2013-02-28 + + + + + + 366 + + + 366 + + + PRAVDA + + + =DATEDIF($K8;$L8;K$1) + + + + 2012-02-29 + + + 2013-03-01 + + + + + + 366 + + + 366 + + + PRAVDA + + + =DATEDIF($K9;$L9;K$1) + + + + 2011-02-28 + + + 2012-02-29 + + + + + + 367 + + + 367 + + + PRAVDA + + + =DATEDIF($K10;$L10;K$1) + + + + 2011-02-28 + + + 2012-03-01 + + + + + + 32 + + + 32 + + + PRAVDA + + + =DATEDIF($K11;$L11;K$1) + + + + 2011-01-28 + + + 2011-03-01 + + + + + + 31 + + + 31 + + + PRAVDA + + + =DATEDIF($K12;$L12;K$1) + + + + 2011-01-29 + + + 2011-03-01 + + + + + + 426 + + + 426 + + + PRAVDA + + + =DATEDIF($K13;$L13;K$1) + + + + 2001-01-01 + + + 2002-03-03 + + + + + + 700 + + + 700 + + + PRAVDA + + + =DATEDIF($K14;$L14;K$1) + + + + 2001-06-05 + + + 2003-05-06 + + + + + + 304 + + + 304 + + + PRAVDA + + + =DATEDIF($K15;$L15;K$1) + + + + 2001-03-03 + + + 2002-01-01 + + + + + + 760 + + + 760 + + + PRAVDA + + + =DATEDIF($K16;$L16;K$1) + + + + 2001-05-06 + + + 2003-06-05 + + + + + + 8724 + + + 8724 + + + PRAVDA + + + =DATEDIF($K17;$L17;K$1) + + + + 1988-06-22 + + + 2012-05-11 + + + + + + 12 + + + 12 + + + PRAVDA + + + =DATEDIF($K2;$L2;L$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K3;$L3;L$1) + + + + + + 12 + + + 12 + + + PRAVDA + + + =DATEDIF($K4;$L4;L$1) + + + + + + 12 + + + 12 + + + PRAVDA + + + =DATEDIF($K5;$L5;L$1) + + + + + + 11 + + + 11 + + + PRAVDA + + + =DATEDIF($K6;$L6;L$1) + + + + + + 11 + + + 11 + + + PRAVDA + + + =DATEDIF($K7;$L7;L$1) + + + + + + + + 12 + + + 12 + + + PRAVDA + + + =DATEDIF($K8;$L8;L$1) + + + + + + + + 12 + + + 12 + + + PRAVDA + + + =DATEDIF($K9;$L9;L$1) + + + + + + + + 12 + + + 12 + + + PRAVDA + + + =DATEDIF($K10;$L10;L$1) + + + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K11;$L11;L$1) + + + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K12;$L12;L$1) + + + + + + + + 14 + + + 14 + + + PRAVDA + + + =DATEDIF($K13;$L13;L$1) + + + + + + + + 23 + + + 23 + + + PRAVDA + + + =DATEDIF($K14;$L14;L$1) + + + + + + + + 9 + + + 9 + + + PRAVDA + + + =DATEDIF($K15;$L15;L$1) + + + + + + + + 24 + + + 24 + + + PRAVDA + + + =DATEDIF($K16;$L16;L$1) + + + + + + + + 286 + + + 286 + + + PRAVDA + + + =DATEDIF($K17;$L17;L$1) + + + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K2;$L2;M$1) + + + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K3;$L3;M$1) + + + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K4;$L4;M$1) + + + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K5;$L5;M$1) + + + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K6;$L6;M$1) + + + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K7;$L7;M$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K8;$L8;M$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K9;$L9;M$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K10;$L10;M$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K11;$L11;M$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K12;$L12;M$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K13;$L13;M$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K14;$L14;M$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K15;$L15;M$1) + + + + + + 2 + + + 2 + + + PRAVDA + + + =DATEDIF($K16;$L16;M$1) + + + + + + 23 + + + 23 + + + PRAVDA + + + =DATEDIF($K17;$L17;M$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K2;$L2;N$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K3;$L3;N$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K4;$L4;N$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K5;$L5;N$1) + + + + + + 11 + + + 11 + + + PRAVDA + + + =DATEDIF($K6;$L6;N$1) + + + + + + 11 + + + 11 + + + PRAVDA + + + =DATEDIF($K7;$L7;N$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K8;$L8;N$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K9;$L9;N$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K10;$L10;N$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K11;$L11;N$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K12;$L12;N$1) + + + + + + 2 + + + 2 + + + PRAVDA + + + =DATEDIF($K13;$L13;N$1) + + + + + + 11 + + + 11 + + + PRAVDA + + + =DATEDIF($K14;$L14;N$1) + + + + + + 9 + + + 9 + + + PRAVDA + + + =DATEDIF($K15;$L15;N$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K16;$L16;N$1) + + + + + + 10 + + + 10 + + + PRAVDA + + + =DATEDIF($K17;$L17;N$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K2;$L2;O$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K3;$L3;O$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K4;$L4;O$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K5;$L5;O$1) + + + + + + 27 + + + 27 + + + PRAVDA + + + =DATEDIF($K6;$L6;O$1) + + + + + + 30 + + + 30 + + + PRAVDA + + + =DATEDIF($K7;$L7;O$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K8;$L8;O$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K9;$L9;O$1) + + + + + + 2 + + + 2 + + + PRAVDA + + + =DATEDIF($K10;$L10;O$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K11;$L11;O$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K12;$L12;O$1) + + + + + + 2 + + + 2 + + + PRAVDA + + + =DATEDIF($K13;$L13;O$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K14;$L14;O$1) + + + + + + 29 + + + 29 + + + PRAVDA + + + =DATEDIF($K15;$L15;O$1) + + + + + + 30 + + + 30 + + + PRAVDA + + + =DATEDIF($K16;$L16;O$1) + + + + + + 19 + + + 19 + + + PRAVDA + + + =DATEDIF($K17;$L17;O$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K2;$L2;P$1) + + + + + + 29 + + + 29 + + + PRAVDA + + + =DATEDIF($K3;$L3;P$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K4;$L4;P$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K5;$L5;P$1) + + + + + + 364 + + + 364 + + + PRAVDA + + + =DATEDIF($K6;$L6;P$1) + + + + + + 365 + + + 365 + + + PRAVDA + + + =DATEDIF($K7;$L7;P$1) + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF($K8;$L8;P$1) + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF($K9;$L9;P$1) + + + + + + 2 + + + 2 + + + PRAVDA + + + =DATEDIF($K10;$L10;P$1) + + + + + + 32 + + + 32 + + + PRAVDA + + + =DATEDIF($K11;$L11;P$1) + + + + + + 31 + + + 31 + + + PRAVDA + + + =DATEDIF($K12;$L12;P$1) + + + + + + 61 + + + 61 + + + PRAVDA + + + =DATEDIF($K13;$L13;P$1) + + + + + + 335 + + + 335 + + + PRAVDA + + + =DATEDIF($K14;$L14;P$1) + + + + + + 304 + + + 304 + + + PRAVDA + + + =DATEDIF($K15;$L15;P$1) + + + + + + 30 + + + 30 + + + PRAVDA + + + =DATEDIF($K16;$L16;P$1) + + + + + + 324 + + + 324 + + + PRAVDA + + + =DATEDIF($K17;$L17;P$1) + + + + + + 9 + + + 9 + + + PRAVDA + + + =DATEDIF(F98;G98;H98) + + + + 2007-01-01 + + + 2007-01-10 + + + d + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF(F99;G99;H99) + + + + 2007-01-01 + + + 2007-01-31 + + + m + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF(F100;G100;H100) + + + + 2007-01-01 + + + 2007-02-01 + + + m + + + + + + 1 + + + 1 + + + PRAVDA + + + =DATEDIF(F101;G101;H101) + + + + 2007-01-01 + + + 2007-02-28 + + + m + + + + + + 364 + + + 364 + + + PRAVDA + + + =DATEDIF(F102;G102;H102) + + + + 2007-01-01 + + + 2007-12-31 + + + d + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF(F103;G103;H103) + + + + 2007-01-01 + + + 2007-01-31 + + + y + + + + + + 547 + + + 547 + + + PRAVDA + + + =DATEDIF(F104;G104;H104) + + + + 2007-01-01 + + + 2008-07-01 + + + d + + + + + + 18 + + + 18 + + + PRAVDA + + + =DATEDIF(F105;G105;H105) + + + + 2007-01-01 + + + 2008-07-01 + + + m + + + + + + 6 + + + 6 + + + PRAVDA + + + =DATEDIF(F106;G106;H106) + + + + 2007-01-01 + + + 2008-07-01 + + + ym + + + + + + 182 + + + 182 + + + PRAVDA + + + =DATEDIF(F107;G107;H107) + + + + 2007-01-01 + + + 2008-07-01 + + + yd + + + + + + 181 + + + 181 + + + PRAVDA + + + =DATEDIF(F108;G108;H108) + + + + 2008-01-01 + + + 2009-07-01 + + + yd + + + + + + 30 + + + 30 + + + PRAVDA + + + =DATEDIF(F109;G109;H109) + + + + 2007-01-01 + + + 2007-01-31 + + + md + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF(F110;G110;H110) + + + + 01.02.2007 + + + 01.03.2009 + + + md + + + + + + 0 + + + 0 + + + PRAVDA + + + =DATEDIF(F111;G111;H111) + + + + 01.02.2008 + + + 01.03.2009 + + + md + + + + + + 2 + + + 2 + + + PRAVDA + + + =DATEDIF(F112;G112;H112) + + + tdf#105548 + + + 01/01/2017 08:00 AM + + + 01/03/17 07:00 AM + + + d + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + diff --git a/sc/qa/unit/data/functions/date_time/fods/datevalue.fods b/sc/qa/unit/data/functions/date_time/fods/datevalue.fods new file mode 100644 index 000000000..76dce86d2 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/datevalue.fods @@ -0,0 +1,836 @@ + + + + 2016-05-26T13:11:56.742000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/86d84ae4bba0d4c45bc13232645318291a8aed75 + + + 0 + 0 + 18935 + 1848 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 0 + 4 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DATEVALUE Function + + + + + + + + + Result + + + Err:502 + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + Err:502 + + + Simple DATEVALUE formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + 19925 + + + 19925 + + + PRAVDA + + + DATEVALUE("1954-07-20") + + + + + + 19925 + + + 19925 + + + PRAVDA + + + DATEVALUE("1954-07-20 16:30:01") + + + + + + Err:502 + + + 42005 + + + Err:502 + + + DATEVALUE("Jan1, 2015") + + + tdf#91420 locale dependent + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/day.fods b/sc/qa/unit/data/functions/date_time/fods/day.fods new file mode 100644 index 000000000..27591f1f0 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/day.fods @@ -0,0 +1,863 @@ + + + + 2016-05-27T19:01:45.330861582P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 22009 + 4261 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 3 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DAY Function + + + + + + + + + Result + + + Err:502 + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + Err:502 + + + Simple DAY formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + 19925 + + + 19925 + + + PRAVDA + + + DATEVALUE("1954-07-20") + + + + + + 19925 + + + 19925 + + + PRAVDA + + + DATEVALUE("1954-07-20 16:30:01") + + + + + + Err:502 + + + 42005 + + + Err:502 + + + DATEVALUE("Jan1, 2015") + + + tdf#91420 locale dependent + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/days.fods b/sc/qa/unit/data/functions/date_time/fods/days.fods new file mode 100644 index 000000000..aacf1e58f --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/days.fods @@ -0,0 +1,802 @@ + + + + 2016-05-26T14:16:58.709000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/86d84ae4bba0d4c45bc13232645318291a8aed75 + + + 0 + 0 + 23879 + 2723 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 3 + 4 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + . + + . + + + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DAYS Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DAYS formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + 3370 + + + 3370 + + + PRAVDA + + + DAYS("1990-01-01";"1980-10-10") + + + + + + #VALUE! + + + 3370 + + + #VALUE! + + + DAYS("Jan1, 1990";"1980-10-10") + + + + 04.09.04 12:50 + + + + + + -0,048611111109494 + + + -0,048611111109494 + + + PRAVDA + + + DAYS(J4;J3) + + + + 04.09.04 11:40 + + + + + + -3370 + + + -3370 + + + PRAVDA + + + DAYS(J6;J5) + + + + 01.01.1990 + + + + + + + + + 10.10.1980 + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/days360.fods b/sc/qa/unit/data/functions/date_time/fods/days360.fods new file mode 100644 index 000000000..f9261d6ad --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/days360.fods @@ -0,0 +1,1279 @@ + + + + 2016-05-28T12:04:51.801913159P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 27975 + 8468 + + + view1 + + + 2 + 7 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 10 + 3 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + $ + + + + + ($ + + ) + + + + $ + + + + + + ($ + + ) + + + + $ + + + + + ($ + + ) + + + + $ + + + + + + ($ + + ) + + + + + + + - + + + + + + + + + - + + + + + + + + - + + + + + + + + + - + + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + $ + + + + + + $ + + ( + + ) + + + $ + + - + + + + + + + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + + + $ + + + + + + $ + + ( + + ) + + + $ + + - + + + + + + + + + + + + + : + + + + + : + + : + + + + + : + + + + + + + + ok + + + + ERR + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DAYS360 Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DAYS360 formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + 28.02.2007 + + + 28.02.2008 + + + 29.02.2008 + + + 30.04.2008 + + + + + + 28 + + + 28 + + + PRAVDA + + + DAYS360(G$1;G$2) + + + + 28.03.2007 + + + 28.03.2008 + + + 29.03.2008 + + + 30.05.2008 + + + + + + 28 + + + 28 + + + PRAVDA + + + DAYS360(G$1;G$2;0) + + + + + + 30 + + + 30 + + + PRAVDA + + + DAYS360(G$1;G$2;1) + + + + + + 30 + + + 30 + + + PRAVDA + + + DAYS360(H$1;H$2) + + + + + + 30 + + + 30 + + + PRAVDA + + + DAYS360(H$1;H$2;0) + + + + + + 30 + + + 30 + + + PRAVDA + + + DAYS360(H$1;H$2;1) + + + + + + 29 + + + 29 + + + PRAVDA + + + DAYS360(I$1;I$2) + + + + + + 29 + + + 29 + + + PRAVDA + + + DAYS360(I$1;I$2;0) + + + + + + 30 + + + 30 + + + PRAVDA + + + DAYS360(I$1;I$2;1) + + + + + + 30 + + + 30 + + + PRAVDA + + + DAYS360(J$1;J$2) + + + + + + 30 + + + 30 + + + PRAVDA + + + DAYS360(J$1;J$2;0) + + + + + + 30 + + + 30 + + + PRAVDA + + + DAYS360(J$1;J$2;1) + + + + + + 30 + + + 30 + + + PRAVDA + + DAYS360(J$1;J$2;3) + + Eike question https://lists.oasis-open.org/archives/office-comment/201605/msg00002.html + + + + + + 28 + + + 28 + + + PRAVDA + + + DAYS360(date1;date2) + + + + + + 30 + + + 30 + + + PRAVDA + + + DAYS360(J$1;J$2;TRUE()) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/daysinmonth.fods b/sc/qa/unit/data/functions/date_time/fods/daysinmonth.fods new file mode 100644 index 000000000..d658c9dee --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/daysinmonth.fods @@ -0,0 +1,853 @@ + + + + 2016-05-27T19:04:31.385393504P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 23905 + 4064 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 0 + 3 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AER1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + . + + . + + + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DAYSINMONTH Function + + + + + + + + + Result + + + #VALUE! + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + #VALUE! + + + Simple DAYSINMONTH formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + 31 + + + 31 + + + PRAVDA + + + =DAYSINMONTH("1990-01-01") + + + + + + 30 + + + 30 + + + PRAVDA + + + =DAYSINMONTH(J4) + + + + + + 30 + + + 30 + + + PRAVDA + + + =DAYSINMONTH(date1) + + + + 04.09.04 11:40 + + + + + + #VALUE! + + + 31 + + + #VALUE! + + + =DAYSINMONTH("Jan1, 2015") + + + locale dependent + + + + + + 31 + + + 31 + + + PRAVDA + + + =DAYSINMONTH(0) + + + + + + #VALUE! + + + #VALUE! + + + PRAVDA + + + =DAYSINMONTH("a") + + + + + + 31 + + + 31 + + + PRAVDA + + + =DAYSINMONTH(J8) + + + + 0,2 + + + + + + 31 + + + 31 + + + PRAVDA + + + =DAYSINMONTH(J9) + + + AOO #114061 + + + + 31.12.9999 + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/daysinyear.fods b/sc/qa/unit/data/functions/date_time/fods/daysinyear.fods new file mode 100644 index 000000000..f6135e95d --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/daysinyear.fods @@ -0,0 +1,838 @@ + + + + 2016-05-27T19:04:31.385393504P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 23905 + 4064 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 0 + 3 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAFBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + . + + . + + + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DAYSINMONTH Function + + + + + + + + + Result + + + #VALUE! + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + #VALUE! + + + Simple DAYSINMONTH formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + 365 + + + 365 + + + PRAVDA + + + =DAYSINYEAR("1990-01-01") + + + + + + 366 + + + 366 + + + PRAVDA + + + =DAYSINYEAR(J4) + + + + + + 366 + + + 366 + + + PRAVDA + + + =DAYSINYEAR(date1) + + + + 04.09.04 11:40 + + + + + + #VALUE! + + + 365 + + + #VALUE! + + + =DAYSINYEAR("Jan1, 2015") + + + locale dependent + + + + + + 365 + + + 365 + + + PRAVDA + + + =DAYSINYEAR(0) + + + + + + #VALUE! + + + #VALUE! + + + PRAVDA + + + =DAYSINYEAR("a") + + + + + + 365 + + + 365 + + + PRAVDA + + + =DAYSINYEAR(J8) + + + + 0,2 + + + + + + + 01.01.1899 + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/eastersunday.fods b/sc/qa/unit/data/functions/date_time/fods/eastersunday.fods new file mode 100644 index 000000000..0ff92a62c --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/eastersunday.fods @@ -0,0 +1,1008 @@ + + + + 2016-06-09T18:09:22.605373558P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/86d84ae4bba0d4c45bc13232645318291a8aed75 + + + 0 + 0 + 29700 + 9129 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 0 + 13 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + EASTERSUNDAY Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple EASTERSUNDAY formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + 04/18/1954 + + + 04/18/1954 + + + TRUE + + + =EASTERSUNDAY(J2) + + + + + 1954 + + + + + + 04/05/2015 + + + 04/05/2015 + + + TRUE + + + =EASTERSUNDAY("2015") + + + locale dependent + + + + + + 23.04.2000 + + + 23.04.2000 + + + PRAVDA + + + =EASTERSUNDAY(2000) + + + + + + + 23.04.2000 + + + 23.04.2000 + + + PRAVDA + + + =EASTERSUNDAY(0) + + + + + + #VALUE! + + + #VALUE + + + PRAVDA + + + =EASTERSUNDAY("ab") + + + + + + + 23.04.2000 + + + 23.04.2000 + + + PRAVDA + + + =EASTERSUNDAY(year) + + + empty cell + + + + + + 23.04.2000 + + + 23.04.2000 + + + PRAVDA + + + =EASTERSUNDAY(year2) + + + + 2000 + + + + + + Err:511 + + + error511 + + + PRAVDA + + + =EASTERSUNDAY() + + + + + + + #VALUE! + + + #VALUE + + + PRAVDA + + + =EASTERSUNDAY(years) + + + + + + Err:502 + + + #VALUE + + + TRUE + + + =EASTERSUNDAY(99999) + + + TDF#100285 + + + + + + Err:502 + + + #VALUE + + + TRUE + + + =EASTERSUNDAY(-1) + + + + + + + + + + + + + + + + + + + + + + + + https://help.libreoffice.org/Calc/EASTERSUNDAY + + + + + + + + + + + + + + + + + + + + 2000 + + + + + + + + + 2001 + + + + + + + + + 2002 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + diff --git a/sc/qa/unit/data/functions/date_time/fods/edate.fods b/sc/qa/unit/data/functions/date_time/fods/edate.fods new file mode 100644 index 000000000..dd9dac5bc --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/edate.fods @@ -0,0 +1,1085 @@ + + + + 2016-05-26T15:42:48.977846871P0D1LibreOffice/5.1.2.2$Linux_X86_64 LibreOffice_project/10m0$Build-2 + + + 0 + 0 + 22009 + 4261 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 4 + 10 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1185 + 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 + true + true + false + 12632256 + false + Lexmark-E352dn + + + cs + CZ + + + + + + en + US + + + + + + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCklucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + EDATE Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple EDATE formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + + 28.02.2001 + + + 28.02.2001 + + + PRAVDA + + + =EDATE("2001-03-31";-1) + + + + + + 30.04.2001 + + + 30.04.2001 + + + PRAVDA + + + =EDATE("2001-03-31";1) + + + + + + 31.03.2001 + + + 31.03.2001 + + + PRAVDA + + + =EDATE("2001-03-31";0) + + + + 1983 + + + + 3 + + + + + + 30.04.2002 + + + 30.04.2002 + + + PRAVDA + + + =EDATE("2001-03-31";13) + + + + 1 + + + + 6 + + + + + + 30.05.2001 + + + 30.05.2001 + + + PRAVDA + + + =EDATE(datum;month) + + + + 31 + + + + 2002 + + + + + + 30.12.1899 + + + 30.12.1899 + + + PRAVDA + + + =EDATE(J9;0) + + + + 30.04.2001 + + + + + + + + + + + + + + + + + + + 0,2 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Age + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/eomonth.fods b/sc/qa/unit/data/functions/date_time/fods/eomonth.fods new file mode 100644 index 000000000..718593385 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/eomonth.fods @@ -0,0 +1,998 @@ + + + + 2016-06-09T18:11:18.316353292P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/86d84ae4bba0d4c45bc13232645318291a8aed75 + + + 0 + 0 + 25779 + 12389 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 4 + 15 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + EOMONTH Function + + + + + + + + + Result + + + #VALUE! + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + #VALUE! + + + Simple EOMONTH formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + 31.08.1954 + + + 31.08.1954 + + + PRAVDA + + + =EOMONTH("1954-07-20";1) + + + + + + #VALUE! + + + 28.02.2015 + + + #VALUE! + + + =EOMONTH("Jan11, 2015";1) + + + locale dependent + + + + + + 31.07.1905 + + + 31.07.1905 + + + PRAVDA + + + =EOMONTH(2000;1) + + + + + + + 31.01.1900 + + + 31.01.1900 + + + PRAVDA + + + =EOMONTH(0;1) + + + + + + 30.11.2173 + + + 30.11.2173 + + + PRAVDA + + + =EOMONTH(99999;1) + + + + + + #VALUE! + + + #VALUE + + + PRAVDA + + + =EOMONTH("ab";1) + + + + + + + 31.01.1900 + + + 31.01.1900 + + + PRAVDA + + + =EOMONTH(year;1) + + + empty cell + + + + + + 31.07.1905 + + + 31.07.1905 + + + PRAVDA + + + =EOMONTH(year2;1) + + + + 2000 + + + + + + Err:504 + + + error511 + + + PRAVDA + + + =EOMONTH() + + + + + + + Err:504 + + + #VALUE + + + PRAVDA + + + =EOMONTH(years) + + + + + + 30.11.2173 + + + 30.11.2173 + + + PRAVDA + + + =EOMONTH(J27;1) + + + + + + 30.09.2173 + + + 30.09.2173 + + + PRAVDA + + + =EOMONTH(J27;-1) + + + + + + + 31.10.2173 + + + 31.10.2173 + + + PRAVDA + + + =EOMONTH(J27;0) + + + + + + 28.02.2005 + + + 28.02.2005 + + + PRAVDA + + + =EOMONTH(J16;-35) + + + AOO #91507 + + + + + + + + + 01.01.2008 + + + + + + + + + + + + + + 2000 + + + + + + + + + 2001 + + + + + + + + + 2002 + + + + + + + + + + + + + + 13.10.2173 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/hour.fods b/sc/qa/unit/data/functions/date_time/fods/hour.fods new file mode 100644 index 000000000..bb5abc52a --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/hour.fods @@ -0,0 +1,2450 @@ + + + + 2016-06-16T21:33:00.362639640P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 22009 + 6519 + + + view1 + + + 0 + 2 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 1 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 4 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + REM ***** BASIC ***** + +Sub Main +Const x = 1.75 + print cDate(x), Day(cDate(x)), Hour(cDate(x)) +End Sub + +Function basISODateTime(dVal#) + dt = cDate(dVal) + basISODateTime = format(year(dt),"0000")&"-"& format(Month(dt),"00")&"-"& format(day(dt),"00")&" "& format(Hour(dt),"00")&":"& format(Minute(dt),"00")&":"& format(Second(dt),"00") +End Function + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + + - + + + + + + Kč + + + + - + + + Kč + + + + + - + + - + + + + : + + : + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + - + + - + + + + + + + + + + + + + + + + + + + + + € + + + + + - + € + + + + + + + + + - + + + + + + + + + + + - + + + + + + + + + + - + + + + + + + + + + + - + + + + + + + : + + + + + + + + € + + + - + + € + + + + + € + + + + - + + € + + + + + € + + + + € + + + - + + € + + + + + € + + + + - + + € + + + + + € + + + - + + € + + + - € + + + + + + + + + + + + + + - + + + + + - + + + + + + + + + + + € + + + - + + € + + + - + + € + + + + + + + + + + + + + + - + + + + + - + + + + + + + + + + + + + + + Edit Time + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + $ + + + + - + $ + + + + + $ + + + + - + $ + + + + + $ + + + + + - + $ + + + + + $ + + + + + - + $ + + + + + $ + + + + + - + $ + + + + + € + + + + + - + € + + + + + + + + + - + + + + + + + + + + + - + + + + + + + + + + - + + + + + + + + + + + - + + + + + + + DM + + + - + + DM + + + + + DM + + + + - + + DM + + + + + DM + + + - + + DM + + + + + DM + + + + - + + DM + + + + + DM + + + - + + DM + + + - DM + + + + + + + + + - + + + + + - + + + + + + DM + + + - + + DM + + + - + + DM + + + + + + + + + - + + + + + - + + + + + + + + - + + + + £ + + + + - + £ + + + + + $ + + + + - + $ + + + + + € + + + + - + € + + + + + $ + + + + + - + $ + + + + + $ + + + + + - + $ + + + + + + + + + + - + + + + + + + + + + + - + + + + + + + DM + + + + - + + DM + + + + + DM + + + + - + + DM + + + + + + + + + + + + + $ + + + + - + $ + + + + + $ + + + + - + $ + + + + + $ + + + + + - + $ + + + + + $ + + + + + - + $ + + + + + $ + + + + + - + $ + + + + + RM + + + + - + RM + + + + + RM + + + + - + RM + + + + + RM + + + + + - + RM + + + + + RM + + + + + - + RM + + + + + RM + + + + + - + RM + + + + + + + € + + + + - + + + € + + + + + - + + - + + + + + + + + € + + + + - + + + € + + + + + + + / + + / + + + + + / + + / + + + + + 年 + + 月 + + 日 + + + + 時 + + 分 + + 秒 + + + + 月 + + 日 + + + + + . + + . + + + + + + 年 + + 月 + + 日 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + : + + : + + + + + : + + : + + + + + . + + . + + + + : + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + HOUR Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple HOUR formulas with local references and values + + + + + + + + + + + + + + + + + https://help.libreoffice.org/Calc/HOUR + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + 17 + + + 17 + + + PRAVDA + + + =HOUR(J3) + + + + + + 9 + + + 9 + + + PRAVDA + + + =HOUR(J4) + + + + 17:20:00 + + + + + + 17 + + + 17 + + + PRAVDA + + + =HOUR("17:20:00") + + + + 0,4 + + + + + + 12 + + + 12 + + + PRAVDA + + + =HOUR(J6) + + + + + + 0 + + + 0 + + + PRAVDA + + + =HOUR(year2) + + + + 01.01.1999 12:30:01 + + + + + + 1 + + + 1 + + + PRAVDA + + + =HOUR(J8) + + + + + + + + + PRAVDA + + BASISODATETIME(G2) + + + Sheet AOO #117989 – own macro function + + + + 25:39:00 + + + + + + + + + + + 2000 + + + + + + 10 + + + 10 + + + TRUE + + + =HOUR(J10) + + + tdf11880 + + + + 10:59:59.60 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 2000 + + + + + + + + + 2001 + + + + + + + + + 2002 + + + + + + + + + + + + + + 13.10.2173 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + macro function + + + convert date to number + + + expected value + + + Correct + + + + + + 1899-12-26 12:00:00 + + + -4 + + + -4 + + + PRAVDA + + + + 1899-12-26 12:00:00 + + + -3,5 + + + + + 1899-12-26 18:00:00 + + + -4 + + + -4 + + + PRAVDA + + + + 1899-12-26 18:00:00 + + + -3,25 + + + + + 1899-12-27 00:00:00 + + + -3 + + + -3 + + + PRAVDA + + + + 1899-12-27 00:00:00 + + + -3 + + + + + 1899-12-27 06:00:00 + + + -3 + + + -3 + + + PRAVDA + + + + 1899-12-27 06:00:00 + + + -2,75 + + + + + 1899-12-27 12:00:00 + + + -3 + + + -3 + + + PRAVDA + + + + 1899-12-27 12:00:00 + + + -2,5 + + + + + 1899-12-27 18:00:00 + + + -3 + + + -3 + + + PRAVDA + + + + 1899-12-27 18:00:00 + + + -2,25 + + + + + 1899-12-28 00:00:00 + + + -2 + + + -2 + + + PRAVDA + + + + 1899-12-28 00:00:00 + + + -2 + + + + + 1899-12-28 06:00:00 + + + -2 + + + -2 + + + PRAVDA + + + + 1899-12-28 06:00:00 + + + -1,75 + + + + + 1899-12-28 12:00:00 + + + -2 + + + -2 + + + PRAVDA + + + + 1899-12-28 12:00:00 + + + -1,5 + + + + + 1899-12-28 18:00:00 + + + -2 + + + -2 + + + PRAVDA + + + + 1899-12-28 18:00:00 + + + -1,25 + + + + + 1899-12-29 00:00:00 + + + -1 + + + -1 + + + PRAVDA + + + + 1899-12-29 00:00:00 + + + -1 + + + + + 1899-12-29 06:00:00 + + + -1 + + + -1 + + + PRAVDA + + + + 1899-12-29 06:00:00 + + + -0,75 + + + + + 1899-12-29 12:00:00 + + + -1 + + + -1 + + + PRAVDA + + + + 1899-12-29 12:00:00 + + + -0,5 + + + + + 1899-12-29 18:00:00 + + + -1 + + + -1 + + + PRAVDA + + + + 1899-12-29 18:00:00 + + + -0,25 + + + + + 1899-12-30 00:00:00 + + + 0 + + + 0 + + + PRAVDA + + + + 1899-12-30 00:00:00 + + + 0 + + + + + 1899-12-30 06:00:00 + + + 0 + + + 0 + + + PRAVDA + + + + 1899-12-30 06:00:00 + + + 0,25 + + + + + 1899-12-30 12:00:00 + + + 0 + + + 0 + + + PRAVDA + + + + 1899-12-30 12:00:00 + + + 0,5 + + + + + 1899-12-30 18:00:00 + + + 0 + + + 0 + + + PRAVDA + + + + 1899-12-30 18:00:00 + + + 0,75 + + + + + 1899-12-31 00:00:00 + + + 1 + + + 1 + + + PRAVDA + + + + 1899-12-31 00:00:00 + + + 1 + + + + + 1899-12-31 06:00:00 + + + 1 + + + 1 + + + PRAVDA + + + + 1899-12-31 06:00:00 + + + 1,25 + + + + + 1899-12-31 12:00:00 + + + 1 + + + 1 + + + PRAVDA + + + + 1899-12-31 12:00:00 + + + 1,5 + + + + + 1899-12-31 18:00:00 + + + 1 + + + 1 + + + PRAVDA + + + + 1899-12-31 18:00:00 + + + 1,75 + + + + + 1900-01-01 00:00:00 + + + 2 + + + 2 + + + PRAVDA + + + + 1900-01-01 00:00:00 + + + 2 + + + + + 1900-01-01 06:00:00 + + + 2 + + + 2 + + + PRAVDA + + + + 1900-01-01 06:00:00 + + + 2,25 + + + + + 1900-01-01 12:00:00 + + + 2 + + + 2 + + + PRAVDA + + + + 1900-01-01 12:00:00 + + + 2,5 + + + + + + + + + + + + + 4 + + + + + + + + + + + diff --git a/sc/qa/unit/data/functions/date_time/fods/isleapyear.fods b/sc/qa/unit/data/functions/date_time/fods/isleapyear.fods new file mode 100644 index 000000000..3bb1d04d4 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/isleapyear.fods @@ -0,0 +1,993 @@ + + + + 2016-06-09T18:41:04.909912512P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/86d84ae4bba0d4c45bc13232645318291a8aed75 + + + 0 + 0 + 25779 + 12192 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 0 + 7 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + ISLEAPYEAR Function + + + + + + + + + Result + + + #VALUE! + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + #VALUE! + + + Simple ISLEAPYEAR formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + NEPRAVDA + + + NEPRAVDA + + + PRAVDA + + + =ISLEAPYEAR("1954-07-20") + + + + + + #VALUE! + + + NEPRAVDA + + + #VALUE! + + + =ISLEAPYEAR("Jan11, 2015") + + + locale dependent + + + + + + NEPRAVDA + + + NEPRAVDA + + + PRAVDA + + + =ISLEAPYEAR(2000) + + + + + + + NEPRAVDA + + + NEPRAVDA + + + PRAVDA + + + =ISLEAPYEAR(0) + + + + + + NEPRAVDA + + + NEPRAVDA + + + PRAVDA + + + =ISLEAPYEAR(99999) + + + + + + #VALUE! + + + #VALUE + + + PRAVDA + + + =ISLEAPYEAR("ab") + + + + + + + NEPRAVDA + + + NEPRAVDA + + + PRAVDA + + + =ISLEAPYEAR(year) + + + empty cell + + + + + + NEPRAVDA + + + NEPRAVDA + + + PRAVDA + + + =ISLEAPYEAR(year2) + + + + 2000 + + + + + + Err:504 + + + error511 + + + PRAVDA + + + =ISLEAPYEAR() + + + + + + + #VALUE! + + + #VALUE + + + PRAVDA + + + =ISLEAPYEAR(years) + + + + + + NEPRAVDA + + + NEPRAVDA + + + PRAVDA + + + =ISLEAPYEAR(J27) + + + + + + NEPRAVDA + + + NEPRAVDA + + + PRAVDA + + + =ISLEAPYEAR(J27) + + + + + + + NEPRAVDA + + + NEPRAVDA + + + PRAVDA + + + =ISLEAPYEAR(J27) + + + + + + PRAVDA + + + PRAVDA + + + PRAVDA + + + =ISLEAPYEAR(J16) + + + + + + + + + 01.01.2008 + + + + + + + + + + + + + + 2000 + + + + + + + + + 2001 + + + + + + + + + 2002 + + + + + + + + + + + + + + 13.10.2173 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/isoweeknum.fods b/sc/qa/unit/data/functions/date_time/fods/isoweeknum.fods new file mode 100644 index 000000000..9bfd8ba40 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/isoweeknum.fods @@ -0,0 +1,1171 @@ + + + + 2016-06-10T22:00:00.158000000P0D1LibreOffice/5.1.3.2$Windows_x86 LibreOffice_project/644e4637d1d8544fd9f56425bd6cec110e49301b + + + 0 + 0 + 30781 + 17792 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 0 + 13 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1420 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + true + true + true + true + 12632256 + true + false + true + 3 + true + false + false + 1270 + 1270 + 1 + 1 + true + true + false + PDF-XChange 4.0 + +AX+/1BERi1YQ2hhbmdlIDQuMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUERGLVhDaGFuZ2UgNC4wAAAAAAAAAAAAAAAAAAAAAAAWAAEAGgUAAAAAAAAEAAhSAAAEdAAAM1ROVwYAUABEAEYALQBYAEMAaABhAG4AZwBlACAANAAuADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAATcADgEEwwBAAEACQCaCzQIZAABAAAALAECAAEALAEAAAAAQQA0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAAAADQIAACaCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAERDWFAEAAAAAQAAAAAAAAA0CAAAmgsAAAAAAAAsAQAAZAAAAAEAAABDAHUAcgByAGUAbgB0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQwA6AFwAcABvAHIAdABhAGIAbABlAFwAUABvAHIAdABhAGIAbABlAEEAcABwAHMAXABMAGkAYgByAGUATwBmAGYAaQBjAGUAUABvAHIAdABhAGIAbABlAFwAQQBwAHAAXABsAGkAYgByAGUAbwBmAGYAaQBjAGUAXABwAHIAbwBnAHIAYQBtAFwAcwBvAGYAZgBpAGMAZQAuAGIAaQBuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABIAQ09NUEFUX0RVUExFWF9NT0RFDgBEVVBMRVhfVU5LTk9XTg== + + + cs + CZ + + + + + + en + US + + + + + + 0 + false + true + true + false + false + false + 7 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + . + + . + + + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + ISOWEEKNUM Function + + + + + + + + + Result + + + #VALUE! + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + #VALUE! + + + Simple ISOWEEKNUM formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + 29 + + + 29 + + + PRAVDA + + + =ISOWEEKNUM("1954-07-20") + + + + + + #VALUE! + + + 2 + + + #VALUE! + + + =ISOWEEKNUM("Jan11, 2015") + + + locale dependent + + + + + + 25 + + + 25 + + + PRAVDA + + + =ISOWEEKNUM(2000) + + + + + + + 52 + + + 52 + + + PRAVDA + + + =ISOWEEKNUM(0) + + + + + + 41 + + + 41 + + + PRAVDA + + + =ISOWEEKNUM(99999) + + + + + + #VALUE! + + + #VALUE + + + PRAVDA + + + =ISOWEEKNUM("ab") + + + + + + + 52 + + + 52 + + + PRAVDA + + + =ISOWEEKNUM(year) + + + empty cell + + + + + + 25 + + + 25 + + + PRAVDA + + + =ISOWEEKNUM(year2) + + + + 2000 + + + + + + Chyba:511 + + + error511 + + + PRAVDA + + + =ISOWEEKNUM() + + + + + + + #VALUE! + + + #VALUE + + + PRAVDA + + + =ISOWEEKNUM(years) + + + + + + 41 + + + 41 + + + PRAVDA + + + =ISOWEEKNUM(J27) + + + + + + 41 + + + 41 + + + PRAVDA + + + =ISOWEEKNUM(J27) + + + + + + + 41 + + + 41 + + + PRAVDA + + + =ISOWEEKNUM(J27) + + + + + + 1 + + + 1 + + + PRAVDA + + + =ISOWEEKNUM(J16) + + + + + + 53 + + + 53 + + + PRAVDA + + + =ISOWEEKNUM(J25) + + + + 01.01.2008 + + + + + + + + + + + + + + 2000 + + + + + + + + + 2001 + + + + + + + + + 2002 + + + + + + + + + + + + + + 01.01.16 00:00 + + + + + + + + + + + + + + 13.10.2173 + + + + + + + + + + + + + ISOWEEKNUMSummary: Determines the ISO week number of the year for a given date.Syntax: ISOWEEKNUM( DateParam Date )Returns: NumberConstraints: NoneSemantics: Returns the ordinal number of the calendar week in the year for the given date. ISO 8601 defines the calendar week as a time interval of seven calendar days starting with a Monday, and the first calendar week of a year as the one that includes the first Thursday of that year. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/minute.fods b/sc/qa/unit/data/functions/date_time/fods/minute.fods new file mode 100644 index 000000000..69fba0187 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/minute.fods @@ -0,0 +1,1130 @@ + + + + 2016-06-10T20:02:06.652576343P0D1LibreOffice/5.1.3.2$Linux_X86_64 LibreOffice_project/10m0$Build-2 + + + 0 + 0 + 33263 + 27093 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 1 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet1 + 1185 + 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 + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + : + + : + + + + + . + + . + + + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + MINUTE Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple MINUTE formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + + 0 + + + 0 + + + PRAVDA + + + =MINUTE(1) + + + + + + 55 + + + 55 + + + PRAVDA + + + =MINUTE(J3) + + + + 33333,33 + + + + + + 0 + + + 0 + + + PRAVDA + + + =MINUTE(one) + + + + 1 + + + + + + 0 + + + 0 + + + PRAVDA + + + =MINUTE(K4) + + + + + + 0 + + + 0 + + + PRAVDA + + + =MINUTE(0) + + + + + + 30 + + + 30 + + + PRAVDA + + + =MINUTE(J7) + + + + 16:30:59 + + + + + + 30 + + + 30 + + + PRAVDA + + + =MINUTE(J8) + + + + 01.01.00 16:30 + + + + + + 11 + + + 11 + + + TRUE + + + =MINUTE(J9) + + + tdf11880 + + + + 10:11:59.60 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Age + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + diff --git a/sc/qa/unit/data/functions/date_time/fods/month.fods b/sc/qa/unit/data/functions/date_time/fods/month.fods new file mode 100644 index 000000000..e670188c5 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/month.fods @@ -0,0 +1,1035 @@ + + + + 2016-06-10T20:02:06.652576343P0D1LibreOffice/5.1.3.2$Linux_X86_64 LibreOffice_project/10m0$Build-2 + + + 0 + 0 + 33263 + 27093 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 3 + 10 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet1 + 1185 + 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 + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + : + + : + + + + + . + + . + + + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + MONTH Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple MONTH formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + + 12 + + + 12 + + + PRAVDA + + + =MONTH(1) + + + + + + 4 + + + 4 + + + PRAVDA + + + =MONTH(J3) + + + + 33333,33 + + + + + + 12 + + + 12 + + + PRAVDA + + + =MONTH(one) + + + + 1 + + + + + + 12 + + + 12 + + + PRAVDA + + + =MONTH(K4) + + + + + + 12 + + + 12 + + + PRAVDA + + + =MONTH(0) + + + + + + 12 + + + 12 + + + PRAVDA + + + =MONTH(J7) + + + + 16:30:59 + + + + + + 1 + + + 1 + + + PRAVDA + + + =MONTH(J8) + + + + 01.01.00 16:30 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Age + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/months.fods b/sc/qa/unit/data/functions/date_time/fods/months.fods new file mode 100644 index 000000000..8999a94ef --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/months.fods @@ -0,0 +1,1061 @@ + + + + 2016-06-10T20:02:06.652576343P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/800a196718abbfd38d93c845e563e055ef778b04 + + + 0 + 0 + 34297 + 27093 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + false + + + 2 + 9 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + false + + + Sheet2 + 1241 + 0 + 100 + 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č + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + / + + / + + + + : + + + + + + + - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00/00/0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + MONTHS Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple MONTHS formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + + 14 + + + 14 + + + TRUE + + + =MONTHS("2010-04-03", "2011-06-17", 0) + + + + + + 0 + + + 0 + + + TRUE + + + =MONTHS("2010-03-31", "2010-04-30", 0) + + + + 33333.33 + + + + + + 2 + + + 2 + + + TRUE + + + =MONTHS("2010-03-31", "2010-06-30", 0) + + + + 1 + + + + + + 14 + + + 14 + + + TRUE + + + =MONTHS("2010-04-03", "2011-06-17", 1) + + + + + + 1 + + + 1 + + + TRUE + + + =MONTHS("2010-03-31", "2010-04-01", 1) + + + + + + 1 + + + 1 + + + TRUE + + + =MONTHS(J7, K7, 1) + + + + 2010-03-31 + + + 2010-04-01 + + + + + + 1 + + + 1 + + + TRUE + + + =MONTHS(day1, day2, 1) + + + + + + + + Err:502 + + + error + + + TRUE + + + =MONTHS(day1, day2, 8999) + + + Tdf#100440 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Age + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/networkdays.fods b/sc/qa/unit/data/functions/date_time/fods/networkdays.fods new file mode 100644 index 000000000..e2170bffe --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/networkdays.fods @@ -0,0 +1,1158 @@ + + + + 2016-06-15T06:06:13.365000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/131e604073f89e6c1dd54be88b94b7befd881f2e + + + 0 + 0 + 33007 + 12987 + + + view1 + + + 2 + 7 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 1 + 9 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + NETWORKDAYS Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple NETWORKDAYS formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + DATA + + + + 1 + + + + + + 17 + + + 17 + + + PRAVDA + + + =NETWORKDAYS(K2;K3;K4:K6) + + + + 01.11.2014 + + + + 0 + + + + + + 0 + + + 0 + + + PRAVDA + + + =NETWORKDAYS(K2;K2;K2) + + + + 30.11.2014 + + + + 0 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS(K2;K3;L2) + + + + + 11.11.2014 + + + + 0 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS(K2;K3;) + + + + 27.11.2014 + + + + 0 + + + + + + -20 + + + -20 + + + PRAVDA + + + =NETWORKDAYS(K3;K2;) + + + + 28.11.2014 + + + + 0 + + + + + + 17 + + + 17 + + + PRAVDA + + + =NETWORKDAYS(DATE(2014;11;1);DATE(2014;11;30);{"2014-11-11";"2014-11-28";"2014-11-27"}) + + Fixed withhttps://gerrit.libreoffice.org/gitweb?p=core.git;a=commitdiff;h=3c2803bdbc598deeaf6efe43870d4f9d61cb2c6a + + + + + 24.12.2001 + + + + 1 + + + + + + 3 + + + 3 + + + PRAVDA + + + =NETWORKDAYS(K2;K2+6;;{1;0;1;0;1;0;1}) + + + + 25.12.2001 + + + + + + 21 + + + 21 + + + PRAVDA + + + =NETWORKDAYS(K2;K3;;{0;0;0;0;0;1;1}) + + + + 26.12.2001 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS(K2;K3;;{1;0;0;0;0;0;1}) + + + should be the same like row 5 tdf#100342 + + + + + 31.12.2001 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS(K2;K3;;M1:M7) + + + + 01.01.2002 + + + + + + 17 + + + 17 + + + PRAVDA + + + =NETWORKDAYS(day1;day2;days) + + + + 17 + + + + + + + + + + + 01.12.2001 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + NETWORKDAYSSummary: Returns the whole number of work days between two dates.Syntax: NETWORKDAYS( DateParam Date1 ; DateParam Date2 [ ; [ DateSequence holidays ] [ ; LogicalSequence workdays ] ] )Returns: NumberConstraints: NoneSemantics: Returns the whole number of work days between two dates.Work days are defined as non-weekend, non-holiday days. By default, weekends are Saturdays and Sundays and there are no holidays.The optional 3rd parameter Holidays can be used to specify a list of dates to be treated as holidays. Note that this parameter can be omitted as an empty parameter (two consecutive ;; semicolons) to be able to pass the set of Workdays without Holidays.The optional 4th parameter Workdays can be used to specify a different definition for the standard work week by passing in a list of numbers which define which days of the week are workdays (indicated by 0) or not (indicated by non-zero) in order Sunday, Monday,...,Saturday. So, the default definition of the work week excludes Saturday and Sunday and is: {1;0;0;0;0;0;1}. To define the work week as excluding Friday and Saturday, the third parameter would be: {0;0;0;0;0;1;1}. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/networkdays.intl.fods b/sc/qa/unit/data/functions/date_time/fods/networkdays.intl.fods new file mode 100644 index 000000000..3d11ed9bd --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/networkdays.intl.fods @@ -0,0 +1,1403 @@ + + + + 2016-06-16T19:59:56.707410342P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 31552 + 10696 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 3 + 25 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + NETWORKDAYS.INTL Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple NETWORKDAYS.INTL formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + DATA + + + + 1 + + + + + + 17 + + + 17 + + + PRAVDA + + + =NETWORKDAYS.INTL(K2;K3;;K4:K6) + + + + 01.11.2014 + + + + 0 + + + + + + 0 + + + 0 + + + PRAVDA + + + =NETWORKDAYS.INTL(K2;K2;;K2) + + + + 30.11.2014 + + + + 0 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS.INTL(K2;K3;;L2) + + + + + 11.11.2014 + + + + 0 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS.INTL(K2;K3;;) + + + + 27.11.2014 + + + + 0 + + + + + + -20 + + + -20 + + + PRAVDA + + + =NETWORKDAYS.INTL(K3;K2;;) + + + + 28.11.2014 + + + + 0 + + + + + + 17 + + + 17 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);1;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + 24.12.2001 + + + + 1 + + + + + + 18 + + + 18 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);2;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + 25.12.2001 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);3;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + 26.12.2001 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);4;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + 31.12.2001 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);5;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + 01.01.2002 + + + + + + 21 + + + 21 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);6;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + 17 + + + + + + 19 + + + 19 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);7;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + 01.12.2001 + + + + + + Err:502 + + + err502 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);8;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + + 22 + + + 22 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);11;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + + 23 + + + 23 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);12;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + + + + 24 + + + 24 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);13;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + + 23 + + + 23 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);14;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + + 24 + + + 24 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);15;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + + 24 + + + 24 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);16;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + + 22 + + + 22 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2014;11;1);DATE(2014;11;30);17;{"2014-11-11";"2014-11-28";"2014-11-27"}) + + + + + + 22 + + + 22 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2006;1;1);DATE(2006;2;1);"0000110";{"2006-1-2";"2006-1-16"}) + + + + + + 0 + + + 0 + + + PRAVDA + + + =NETWORKDAYS.INTL(DATE(2006;1;1);DATE(2006;2;1);"1111111";{"2006-1-2";"2006-1-16"}) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/networkdays_excel2003.fods b/sc/qa/unit/data/functions/date_time/fods/networkdays_excel2003.fods new file mode 100644 index 000000000..a46ab8194 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/networkdays_excel2003.fods @@ -0,0 +1,1080 @@ + + + + 2016-06-14T07:28:45.493000000P0D1LibreOffice/5.1.3.2$Windows_x86 LibreOffice_project/644e4637d1d8544fd9f56425bd6cec110e49301b + + + 0 + 0 + 31552 + 5954 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 3 + 9 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1420 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + true + true + true + true + 12632256 + true + false + true + 3 + true + false + false + 1270 + 1270 + 1 + 1 + true + true + false + PDF-XChange 4.0 + +AX+/1BERi1YQ2hhbmdlIDQuMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUERGLVhDaGFuZ2UgNC4wAAAAAAAAAAAAAAAAAAAAAAAWAAEAGgUAAAAAAAAEAAhSAAAEdAAAM1ROVwYAUABEAEYALQBYAEMAaABhAG4AZwBlACAANAAuADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAATcADgEEwwBAAEACQCaCzQIZAABAAAALAECAAEALAEAAAAAQQA0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAAAADQIAACaCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAERDWFAEAAAAAQAAAAAAAAA0CAAAmgsAAAAAAAAsAQAAZAAAAAEAAABDAHUAcgByAGUAbgB0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQwA6AFwAcABvAHIAdABhAGIAbABlAFwAUABvAHIAdABhAGIAbABlAEEAcABwAHMAXABMAGkAYgByAGUATwBmAGYAaQBjAGUAUABvAHIAdABhAGIAbABlAFwAQQBwAHAAXABsAGkAYgByAGUAbwBmAGYAaQBjAGUAXABwAHIAbwBnAHIAYQBtAFwAcwBvAGYAZgBpAGMAZQAuAGIAaQBuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABIAQ09NUEFUX0RVUExFWF9NT0RFDgBEVVBMRVhfVU5LTk9XTg== + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + 0 + false + true + true + false + false + false + 7 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + NETWORKDAYS_excel2003 Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple NETWORKDAYS_EXCEL2003 formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + DATA + + + + 1 + + + + + + 17 + + + 17 + + + PRAVDA + + + =NETWORKDAYS_EXCEL2003(K2;K3;K4:K6) + + + + 01.11.2014 + + + + 0 + + + + + + 0 + + + 0 + + + PRAVDA + + + =NETWORKDAYS_EXCEL2003(K2;K2;K2) + + + + 30.11.2014 + + + + 0 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS_EXCEL2003(K2;K3;L2) + + + + + 11.11.2014 + + + + 0 + + + + + + 20 + + + 20 + + + PRAVDA + + + =NETWORKDAYS_EXCEL2003(K2;K3;) + + + + 27.11.2014 + + + + 0 + + + + + + -20 + + + -20 + + + PRAVDA + + + =NETWORKDAYS_EXCEL2003(K3;K2;) + + + + 28.11.2014 + + + + 0 + + + + + + 17 + + + 17 + + + PRAVDA + + + =NETWORKDAYS_EXCEL2003(date1;date2;dateRange) + + + + + 24.12.2001 + + + + 1 + + + + + + + + + 25.12.2001 + + + + + + + + + 26.12.2001 + + + + + + + + + + + 31.12.2001 + + + + + + + + + + 01.01.2002 + + + + + + + + + + 17 + + + + + + + + + + + 01.12.2001 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/second.fods b/sc/qa/unit/data/functions/date_time/fods/second.fods new file mode 100644 index 000000000..fbeda46f4 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/second.fods @@ -0,0 +1,1136 @@ + + + + 2016-06-10T20:02:06.652576343P0D1LibreOffice/5.1.3.2$Linux_X86_64 LibreOffice_project/10m0$Build-2 + + + 0 + 0 + 22009 + 4261 + + + view1 + + + 0 + 4 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 1 + 3 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1185 + 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 + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + : + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + : + + : + + + + + . + + . + + + + : + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + SECOND Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple SECOND formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + + 0 + + + 0 + + + PRAVDA + + + =SECOND(1) + + + + + + 12 + + + 12 + + + PRAVDA + + + =SECOND(J3) + + + + 33333,33 + + + + + + 0 + + + 0 + + + PRAVDA + + + =SECOND(one) + + + + 1 + + + + + + 0 + + + 0 + + + PRAVDA + + + =SECOND(K4) + + + + + + 0 + + + 0 + + + PRAVDA + + + =SECOND(0) + + + + + + 59 + + + 59 + + + PRAVDA + + + =SECOND(J7) + + + + 16:30:59 + + + + + + 1 + + + 1 + + + PRAVDA + + + =SECOND(J8) + + + + 01.01.2000 16:30:01 + + + + + + 13 + + + 13 + + + TRUE + + + =SECOND(J9) + + + tdf118800 + + + + 10:11:12.6000 + + + + + + 9 + + + 9 + + + TRUE + + + =SECOND(J10) + + + tdf121978 + + + + 2018-10-22 11:34:53.0000 + + + 2018-10-22 11:31:44.0000 + + + + + + 9 + + + 9 + + + TRUE + + + =SECOND(J11) + + + tdf121978 + + + + 00:00:08.9990 + + + + + + 8 + + + 8 + + + TRUE + + + =SECOND(J12) + + + tdf121978 + + + + 00:00:08.2500 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Age + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + diff --git a/sc/qa/unit/data/functions/date_time/fods/time.fods b/sc/qa/unit/data/functions/date_time/fods/time.fods new file mode 100644 index 000000000..4e5fd251e --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/time.fods @@ -0,0 +1,1098 @@ + + + + 2016-06-10T20:02:06.652576343P0D1LibreOffice/5.1.3.2$Linux_X86_64 LibreOffice_project/10m0$Build-2 + + + 0 + 0 + 33263 + 27093 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 9 + 18 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1185 + 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 + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + : + + : + + + + + . + + . + + + + : + + : + + + + + + + + : + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + TIME Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple TIME formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + + 11:19:19 + + + 11:19:19 + + + PRAVDA + + + =TIME(11;19;19) + + + + + + 10:19:19 + + + 10:19:19 + + + PRAVDA + + + =TIME(K10;K11;K12) + + + + 33333,33 + + + + + + 10:19:19 + + + 10:19:19 + + + PRAVDA + + + =TIME(hod;min;sek) + + + + 1 + + + + + + Chyba:502 + + + err502 + + + PRAVDA + + + =TIME(-1;min;sek) + + + + + + 00:00:00 + + + 00:00:00 + + + PRAVDA + + + =TIME(0;0;0) + + + + + + 01:00:01 + + + 01:00:01 + + + PRAVDA + + + =TIME(24;60;1) + + + + 16:30:59 + + + + + + 00:59:59 + + + 00:59:59 + + + PRAVDA + + + =TIME(24;60;-1) + + + + 01.01.2000 16:30:01 + + + + + + 00:00:00 + + + 00:00:00 + + + PRAVDA + + + =TIME(23;60;0) + + + + + + 00:00:00 + + + 00:00:00 + + + PRAVDA + + + =TIME(24;0;0) + + + + 10 + + + + + + + + + 19 + + + + + + + + + + 19 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Age + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/timevalue.fods b/sc/qa/unit/data/functions/date_time/fods/timevalue.fods new file mode 100644 index 000000000..8f430a38f --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/timevalue.fods @@ -0,0 +1,882 @@ + + + + 2016-06-16T20:19:04.624025150P0D1LibreOffice/5.1.3.2$Linux_X86_64 LibreOffice_project/10m0$Build-2 + + + 0 + 0 + 27714 + 8154 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 2 + 9 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1185 + 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 + true + true + false + 12632256 + false + Lexmark-E352dn + + + cs + CZ + + + + + + en + US + + + + + + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00/00/0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + TIMEVALUE Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple TIMEVALUE formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + 0 + + + 0 + + + TRUE + + + =TIMEVALUE("12:00am") + + + + + + 0.6666666667 + + + 0.6666666667 + + + TRUE + + + =TIMEVALUE("4PM") + + + + + + 0.5 + + + 0.5 + + + TRUE + + + =TIMEVALUE("12PM") + + + + + + + 0 + + + 0 + + + TRUE + + + =TIMEVALUE("24:00") + + + + + + 0 + + + 0 + + + TRUE + + + =TIMEVALUE(K6) + + + + 24:00 + + + + + + Err:502 + + + Err502 + + + TRUE + + + =TIMEVALUE(K7) + + + + + 10 + + + + + + 0.4300810185 + + + 0.4300810185 + + + TRUE + + + =TIMEVALUE(K8) + + + + 10:19:19 + + + + + + + + + + + + + + + + + + + + + + + + TIMEVALUESummary: Returns a time serial number from given text.Syntax: TIMEVALUE( Text T )Returns: TimeConstraints: NoneSemantics: This computes the serial number of the text string T, which is a time, using the current locale. This function shall accept ISO time format (HH:MM:SS), which is locale-independent. If the text of T has a combined date and time format, e.g. YYYY-MM-DD HH:MM:SS, the fractional part of the date serial number is returned. If the text of T does not have a time format, an evaluator may attempt to convert the number another way (e.g., using VALUE), or it may return an Error (this is implementation-dependent). + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/weekday.fods b/sc/qa/unit/data/functions/date_time/fods/weekday.fods new file mode 100644 index 000000000..62088ab88 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/weekday.fods @@ -0,0 +1,1079 @@ + + + + 2016-06-15T18:43:41.791000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/131e604073f89e6c1dd54be88b94b7befd881f2e + + + 0 + 0 + 27714 + 9172 + + + view1 + + + 1 + 32 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 2 + 9 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + WEEKDAY Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple WEEKDAY formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + 1 + + + + + + 4 + + + 4 + + + PRAVDA + + + =WEEKDAY("2000-06-14") + + + + 2 + + + + + + 3 + + + 3 + + + PRAVDA + + + =WEEKDAY("1996-07-24";2) + + + + + + 1 + + + 1 + + + PRAVDA + + + =WEEKDAY("2016-07-24";1) + + + + + + + 7 + + + 7 + + + PRAVDA + + + =WEEKDAY("2016-07-24";2) + + + + + + 6 + + + 6 + + + PRAVDA + + + =WEEKDAY("2016-07-24";3) + + + + + + + + 6 + + + 6 + + + PRAVDA + + + =WEEKDAY(K9;3) + + + + + + + + + Err:502 + + + ERR + + + PRAVDA + + + =WEEKDAY(K9;0) + + + Tdf#100396 + + + + + + + + Err:502 + + + err + + + PRAVDA + + + =WEEKDAY(K9;) + + + + 24.07.16 10:19 + + + + + + 1 + + + 1 + + + PRAVDA + + + =WEEKDAY(datum;1) + + + + + + + Err:502 + + + Err + + + PRAVDA + + + =WEEKDAY(datum;999999) + + + Tdf#100396 + + + + + + Err:502 + + + Err + + + PRAVDA + + + =WEEKDAY(K9;999999) + + + Tdf#100396 + + + + + + #VALUE! + + + Err + + + PRAVDA + + + =WEEKDAY(K10;K1:K2) + + TODO https://bugs.documentfoundation.org/show_bug.cgi?id=100396#c1 Also, Excel2010 added additional type parameters, see https://support.office.com/en-US/article/WEEKDAY-function-60E44483-2ED1-439F-8BD0-E404C190949Ahttps://lists.oasis-open.org/archives/office-comment/201606/msg00000.html + + + + + + 7 + + + 7 + + + PRAVDA + + + =WEEKDAY("2016-07-24";11) + + + + + + + 6 + + + 6 + + + PRAVDA + + + =WEEKDAY("2016-07-24";12) + + + + + + + + 5 + + + 5 + + + PRAVDA + + + =WEEKDAY("2016-07-24";13) + + + + + RETEST na dev verzi 18.6. + + + + + + 4 + + + 4 + + + PRAVDA + + + =WEEKDAY("2016-07-24";14) + + + + + + + 3 + + + 3 + + + PRAVDA + + + =WEEKDAY("2016-07-24";15) + + + + + + + 2 + + + 2 + + + PRAVDA + + + =WEEKDAY("2016-07-24";16) + + + + + + + 1 + + + 1 + + + PRAVDA + + + =WEEKDAY("2016-07-24";17) + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/weeknum.fods b/sc/qa/unit/data/functions/date_time/fods/weeknum.fods new file mode 100644 index 000000000..7129ed734 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/weeknum.fods @@ -0,0 +1,1148 @@ + + + + 2016-06-16T20:35:01.736746556P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 27714 + 12747 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 10 + 19 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + WEEKNUM Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple WEEKNUM formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + 1 + + + + + + 25 + + + 25 + + + PRAVDA + + + =WEEKNUM("2000-06-14") + + + + 2 + + + + + + 30 + + + 30 + + + PRAVDA + + + =WEEKNUM("1996-07-24";2) + + + + + + 31 + + + 31 + + + PRAVDA + + + =WEEKNUM("2016-07-24";1) + + + + + + + 30 + + + 30 + + + PRAVDA + + + =WEEKNUM("2016-07-24";2) + + + + + + Err:502 + + + Err + + + PRAVDA + + + =WEEKNUM("2016-07-24";3) + + + + + + + + 30 + + + 30 + + + PRAVDA + + + =WEEKNUM($K$9;2) + + + + + + + + + Err:502 + + + ERR + + + PRAVDA + + + =WEEKNUM(K9;0) + + + + + + + + Err:502 + + + ERR + + + PRAVDA + + + =WEEKNUM(K9;) + + + + 24.07.16 10:19 + + + + + + 31 + + + 31 + + + PRAVDA + + + =WEEKNUM(datum;1) + + + + + + + Err:502 + + + Err + + + PRAVDA + + + =WEEKNUM(datum;999999) + + + + + + #VALUE! + + + Err + + + PRAVDA + + + =WEEKNUM(K10;K1:K2) + + + + + + 30 + + + 30 + + + PRAVDA + + + =WEEKNUM($K$9;11) + + + + + + 30 + + + 30 + + + PRAVDA + + + =WEEKNUM($K$9;12) + + + + + + + 30 + + + 30 + + + PRAVDA + + + =WEEKNUM($K$9;13) + + + + + + 30 + + + 30 + + + PRAVDA + + + =WEEKNUM($K$9;14) + + + + + + 30 + + + 30 + + + PRAVDA + + + =WEEKNUM($K$9;15) + + + WEEKNUMSummary: Determines the week number of the year for a given date.Syntax: WEEKNUM( DateParam Date [ ; Number Mode = 1 ] )Returns: NumberConstraints: 1 ≤ Mode ≤ 2, or 11 ≤ Mode ≤ 17, or Mode = 21, or Mode = 150Semantics: Returns the number of the week in the year for the given date.For Mode={1, 2, 11, 12, ..., 17} the week containing January 1 is the first week of the year, and is numbered week 1. The week starts on {Sunday, Monday, Monday, Tuesday, ..., Sunday}.Mode 21 or 150 are both , the week starts on Monday and the week containing the first Thursday of the year is the first week of the year, and is numbered week 1. + + + + + + 31 + + + 31 + + + PRAVDA + + + =WEEKNUM($K$9;16) + + + + + + 31 + + + 31 + + + PRAVDA + + + =WEEKNUM($K$9;17) + + + + + + 29 + + + 29 + + + PRAVDA + + + =WEEKNUM($K$9;21) + + + + + + 29 + + + 29 + + + PRAVDA + + + =WEEKNUM($K$9;150) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/weeks.fods b/sc/qa/unit/data/functions/date_time/fods/weeks.fods new file mode 100644 index 000000000..a0d596086 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/weeks.fods @@ -0,0 +1,1206 @@ + + + + 2016-06-16T20:38:26.745575429P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/800a196718abbfd38d93c845e563e055ef778b04 + + + 0 + 0 + 35796 + 12356 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + false + + + 3 + 12 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + false + + + Sheet2 + 1241 + 0 + 100 + 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 + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00/00/0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + WEEKS Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple WEEKS formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + DATA + + + + 1 + + + + + + #VALUE! + + + err + + + TRUE + + + =WEEKS(K2,K3,K4:K6) + + + + 11/01/2014 + + + + 0 + + + + + + Err:502 + + + err + + + TRUE + + + =WEEKS(K2,K2,K2) + + + + 11/30/2014 + + + + 0 + + + + + + 4 + + + 4 + + + TRUE + + + =WEEKS(K2,K3,L2) + + + + + 11/11/2014 + + + + 0 + + + + + + Err:502 + + + err + + + TRUE + + + =WEEKS(K2,K3,) + + + + 11/27/2014 + + + + 0 + + + + + + Err:502 + + + err + + + TRUE + + + =WEEKS(K3,K2,) + + + + 11/28/2014 + + + + 0 + + + + + + Err:504 + + + err + + + TRUE + + + =WEEKS(K2,K2+6,,{1;0;1;0;1;0;1}) + + + + + 12/24/2001 + + + + 1 + + + + + + 4 + + + 4 + + + TRUE + + + =WEEKS(day1,day2,one) + + + + 12/25/2001 + + + + + + 10 + + + 10 + + + TRUE + + + =WEEKS(DATE(2014,1,15),DATE(2014,4,1),0) + + + + 12/26/2001 + + + + + + #VALUE! + + + Err + + + TRUE + + + =WEEKS(DATE(2014,11,1),DATE(2014,11,30),{"Hello";"Eike";"!"}) + + + TDF#100409 + + + + + 12/31/2001 + + + + + + Err:502 + + + Err + + + TRUE + + + =WEEKS(DATE(2014,1,15),DATE(2014,4,1),2) + + + Tdf#100440 + + + + 01/01/2002 + + + + + + + + + 17 + + + + + + + + + + + 12/01/2001 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + WEEKSCalculates the difference in weeks between two dates.SyntaxWEEKS(StartDate; EndDate; Type)StartDate is the first dateEndDate is the second dateType calculates the type of difference. The possible values are 0 (interval) and 1 (in numbers of weeks). + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/weeksinyear.fods b/sc/qa/unit/data/functions/date_time/fods/weeksinyear.fods new file mode 100644 index 000000000..24f526459 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/weeksinyear.fods @@ -0,0 +1,1138 @@ + + + + 2016-06-15T19:10:07.801000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/131e604073f89e6c1dd54be88b94b7befd881f2e + + + 0 + 0 + 33007 + 5969 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 2 + 9 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + WEEKSINYEAR Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple WEEKSINYEAR formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + DATA + + + + 1 + + + + + + 52 + + + 52 + + + PRAVDA + + + =WEEKSINYEAR(K2) + + + + 01.11.2014 + + + + 0 + + + + + + 52 + + + 52 + + + PRAVDA + + + =WEEKSINYEAR(K12) + + + + 30.11.2014 + + + + 0 + + + + + + 52 + + + 52 + + + PRAVDA + + + =WEEKSINYEAR("2014-12-31") + + + + + 11.11.2014 + + + + 0 + + + + + + Err:504 + + + Error + + + PRAVDA + + + =WEEKSINYEAR() + + + + 27.11.2014 + + + + 0 + + + + + + Err:504 + + + Error + + + PRAVDA + + + =WEEKSINYEAR(K2;1) + + + + 28.11.2014 + + + + 0 + + + + + + Err:504 + + + Error + + + PRAVDA + + + =WEEKSINYEAR(K3;) + + + + + 24.12.2001 + + + + 1 + + + + + + 52 + + + 52 + + + PRAVDA + + + =WEEKSINYEAR(day1) + + + + 25.12.2001 + + + + + + #VALUE! + + + Err + + + PRAVDA + + + =WEEKSINYEAR({"2014-11-1a1";"2014-1n1-28";"201m5-11-27"}) + + + TDF#100409 + + + + 26.12.2001 + + + + + + + + + + 31.12.2001 + + + + + + + + + + + 01.01.2002 + + + + + + + + + 17 + + + + + + + + + + + 01.12.2001 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/workday.fods b/sc/qa/unit/data/functions/date_time/fods/workday.fods new file mode 100644 index 000000000..8037db8f0 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/workday.fods @@ -0,0 +1,1066 @@ + + + + 2016-06-16T20:43:50.386330264P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 33007 + 5940 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 4 + 2 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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 + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + WORKDAY Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple WORKDAY formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + DATA + + + + 1 + + + + + + 07.11.2014 + + + 07.11.2014 + + + PRAVDA + + + =WORKDAY(K2;K3;K4:K6) + + + + 01.11.2014 + + + + 0 + + + + + + 07.11.2014 + + + 07.11.2014 + + + PRAVDA + + + =WORKDAY(K2;K3;K2) + + + + 5 + + + + 0 + + + + + + 07.11.2014 + + + 07.11.2014 + + + PRAVDA + + + =WORKDAY(K2;K3;L2) + + + + + 11.11.2014 + + + + 0 + + + + + + 07.11.2014 + + + 07.11.2014 + + + PRAVDA + + + =WORKDAY(K2;K3;) + + + + 27.11.2014 + + + + 0 + + + + + + 11.11.2014 + + + 11.11.2014 + + + PRAVDA + + + =WORKDAY(DATE(2014;11;1);5;{"2014-11-2";"2014-11-3";"2014-11-4"}) + + + + 28.11.2014 + + + + 0 + + + + + + 07.11.2014 + + + 07.11.2014 + + + PRAVDA + + + =WORKDAY(day1;day2;days) + + + + + 24.12.2001 + + + + 1 + + + + + + + + + + + 25.12.2001 + + + + + + + + + + + 26.12.2001 + + + + + + + + + + + + 31.12.2001 + + + + + + + + + + + 01.01.2002 + + + + + + + + + 17 + + + + + + + + + + + 01.12.2001 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/workday.intl.fods b/sc/qa/unit/data/functions/date_time/fods/workday.intl.fods new file mode 100644 index 000000000..43059d762 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/workday.intl.fods @@ -0,0 +1,2341 @@ + + + + 2016-06-16T17:41:16.399000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/f9f090d0d0f2b454d6c1dd14fe735e7e83fda9da + + + 0 + 0 + 22009 + 4261 + + + view1 + + + 1 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + false + + + 12 + 26 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + false + + + Sheet2 + 1241 + 0 + 100 + 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 + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + € + + + + + + € + + + - + + + + + : + + + + + : + + : + + + + + : + + + + + + + WAAR + + + WAAR + + + ONWAAR + + + + + + + + - + + - + + + + + - + + - + + + + + / + + / + + + + + + + € + + + + + € + + - + + + + € + + + + + + € + + - + + + + € + + + + + € + + - + + + + € + + + + + + € + + - + + + + + - + + - + + + + + - + + - + + + + + - + + + + + - + + + + + : + + + + + + + : + + : + + + + + + + : + + + + + : + + : + + + + + - + + - + + + + : + + + + + + + + + - + + + + + + + + + + - + + + + + + + + + - + + + + + + + + + + - + + + + + + + + + + + - + + + + - + + + + + + + + + + € + + + + + + € + + + - + + + € + + - + + + + + + + + + + + + + + + + + - + + + + - + + + + + + + + + + + + € + + + + + + € + + + - + + + € + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + / + + / + + + + + / + + / + + + + + - + + - + + + + + + + + - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00/00/0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + WORKDAY.INTL Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple WORKDAY.INTL formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + DATA + + + + 1 + + + + + + 41950 + + + 41950 + + + TRUE + + + =WORKDAY.INTL(K2,K3,,K4:K6) + + + + 11/01/2014 + + + + 0 + + + + + + 41950 + + + 41950 + + + TRUE + + + =WORKDAY.INTL(K2,K3,1,K2) + + + + 5 + + + + 0 + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(K2,K3,L2) + + + + + 11/11/2014 + + + + 0 + + + + + + 41950 + + + 41950 + + + TRUE + + + =WORKDAY.INTL(K2,K3,) + + + + 11/27/2014 + + + + 0 + + + + + + 41951 + + + 41951 + + + TRUE + + + =WORKDAY.INTL(DATE(2014,11,1),2,5,{"2014-11-2";"2014-11-3";"2014-11-4"}) + + + + 11/28/2014 + + + + 0 + + + + + + 41951 + + + 41951 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,2,$K$2) + + + + + 12/24/2001 + + + + 1 + + + + + + 41951 + + + 41951 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,3,$K$2) + + + + 12/25/2001 + + + + + + 41951 + + + 41951 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,4,$K$2) + + + + 12/26/2001 + + + + + + 41951 + + + 41951 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,5,$K$2) + + + + + 12/31/2001 + + + + + + 41951 + + + 41951 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,6,$K$2) + + + + 01/01/2002 + + + + + + 41949 + + + 41949 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,7,$K$2) + + + + 17 + + + + + + Err:502 + + + error + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,8,$K$2) + + + + + 12/01/2001 + + + + + + 11/07/14 + + + 41950 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,11,$K$2) + + + + -5 + + + + + + 11/07/14 + + + 41950 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,12,$K$2) + + + + + + 11/07/14 + + + 41950 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,13,$K$2) + + + + + + + + 11/07/14 + + + 41950 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,14,$K$2) + + + + + + 11/07/14 + + + 41950 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,15,$K$2) + + + + + + 11/06/14 + + + 41949 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,16,$K$2) + + + + + + 11/06/14 + + + 41949 + + + TRUE + + + =WORKDAY.INTL($K$2,$K$3,17,$K$2) + + + + + + 10/28/14 + + + 41940 + + + TRUE + + + =WORKDAY.INTL(DATE(2014,11,1),-2,5,{"2014-11-2";"2014-11-3";"2014-11-4"}) + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(DATE(2014,11,1),-2,-5,{"2014-11-2";"2014-11-3";"2014-11-4"}) + + + + + + 10/30/14 + + + 41942 + + + TRUE + + + =WORKDAY.INTL(DATE(2014,11,1),-2,{1;1;0;0;0;0;0},{"2014-11-2";"2014-11-3";"2014-11-4"}) + + + + + + 10/30/14 + + + 41942 + + + TRUE + + + =WORKDAY.INTL(DATE(2014,11,1),-2,{1;1;1;1;1;1;1},{"2014-11-2";"2014-11-3";"2014-11-4"}) + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(DATE(2012,1,1),30,0) + + + + + + 04/14/12 + + + 41013 + + + TRUE + + + =WORKDAY.INTL(DATE(2012,1,1),90,11) + + + + 0 + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(DATE(2014,11,1),-2,"1111111",{"2014-11-2";"2014-11-3";"2014-11-4"}) + + + winfried tdf#100446 + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(DATE(2014,11,1),-2,"1111111",{"2014-11-2";"2014-11-3";"2014-11-4"}) + + + + + + 10/14/14 + + + 41926 + + + TRUE + + + =WORKDAY.INTL(DATE(2014,11,1),-8,"0011001",{"2014-10-20";"2014-10-23";"2014-10-24"}) + + + + + + 10/15/14 + + + 41927 + + + TRUE + + + =WORKDAY.INTL(DATE(2014,11,1),-8,"0000111",{"2014-10-20";"2014-10-23";"2014-10-24"}) + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(DATE(2014,11,1),-8,{0;0;1;1;0;0;1},{"2014-10-20";"2014-10-23";"2014-10-24"}) + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(K2,-K1,{1;0;0;1;0;0;1}) + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(K2,-K1,{0;0;0;1;0;0;1}) + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(K2,-K1,{1;0;0;1;0;0;0}) + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(K2,K1,{0;0;0;0;0;1;1}) + + + + + + 10/25/14 + + + 41937 + + + TRUE + + + =WORKDAY.INTL($K$2;$K$14;3;$K$2) + + + + + + + 11/07/14 + + + 41950 + + + TRUE + + + =WORKDAY.INTL(K2;K3;{1;0;0;1;0;0;0}) + + + + + + + #N/A + + + #N/A + + + TRUE + + + =WORKDAY.INTL(K2;K3;{M1:M7}) + + + + + + + 11/07/14 + + + 41950 + + + TRUE + + + =WORKDAY.INTL(K2;K3;{M1:M7}) + + + + + + + 11/07/14 + + + 41950 + + + TRUE + + + =WORKDAY.INTL(K2;K3;{M1:M7}) + + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(K2;K3;{M1:M7}) + + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(K2;K3;{M1:M7}) + + + + + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(K2;K3;{M1:M7}) + + + + 3 + + + + + + #VALUE! + + + error + + + TRUE + + + =WORKDAY.INTL(K2;K3;{M1:M7}) + + + + + + + 06/21/16 + + + 42542 + + + TRUE + + + =WORKDAY.INTL(K$1;1;;K2) + + + + 6/20/2016 + + + + + + 06/22/16 + + + 42543 + + + TRUE + + + =WORKDAY.INTL(K$1;1;"1100000";K3) + + + + 6/20/2016 + + + + + + #VALUE! + + + #NUM! + + + TRUE + + + =WORKDAY.INTL(K$1;1;1111111;K4) + + + + 1 + + + + + + 06/21/16 + + + 42542 + + + TRUE + + + =WORKDAY.INTL(K$1;1;"0000011";K5) + + + + + + + 06/27/16 + + + 42548 + + + TRUE + + + =WORKDAY.INTL(K$1;1;"0111111";K6) + + + + + + + #VALUE! + + + #VALUE! + + + TRUE + + + =WORKDAY.INTL(K$1;1;K7) + + + + a + + + + + + #VALUE! + + + #VALUE! + + + TRUE + + + =WORKDAY.INTL(K$1;1;K8) + + + + + + + + + + #VALUE! + + + #VALUE! + + + TRUE + + + =WORKDAY.INTL(K$1;1;K9) + + + + 1 + + + + + + 06/21/16 + + + 42542 + + + TRUE + + + =WORKDAY.INTL(K$1;1;K10) + + + + 12 + + + + + + 06/22/16 + + + 42543 + + + TRUE + + + =WORKDAY.INTL(K$1;1;K11) + + + + 1100000 + + + + + + #VALUE! + + + #NUM! + + + TRUE + + + =WORKDAY.INTL(K$1;1;K12) + + + + 1100000 + + + + + + 06/22/16 + + + 42543 + + + TRUE + + + =WORKDAY.INTL(K$1;1;K13) + + + + 1100000 + + + + + + #VALUE! + + + #NUM! + + + TRUE + + + =WORKDAY.INTL(K$1;1;1100000) + + + + + + + 06/21/16 + + + 42542 + + + TRUE + + + =WORKDAY.INTL(K$1;1;11) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/year.fods b/sc/qa/unit/data/functions/date_time/fods/year.fods new file mode 100644 index 000000000..f0b10c615 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/year.fods @@ -0,0 +1,1008 @@ + + + + 2016-06-09T18:47:00.924389214P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/86d84ae4bba0d4c45bc13232645318291a8aed75 + + + 0 + 0 + 31628 + 27643 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 0 + 4 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 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+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + YEAR Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple YEAR formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + + + + 1899 + + + 1899 + + + PRAVDA + + + YEAR(1) + + + + + + 1900 + + + 1900 + + + PRAVDA + + + YEAR(2) + + + + + + 1991 + + + 1991 + + + PRAVDA + + + YEAR(33333,33) + + + + 33333,33 + + + + + + 1899 + + + 1899 + + + PRAVDA + + + YEAR(one) + + + + 1 + + + + + + 1899 + + + 1899 + + + PRAVDA + + YEAR(K5) + + + + + + 1899 + + + 1899 + + + PRAVDA + + + YEAR(0) + + + + + + 1899 + + + 1899 + + + PRAVDA + + + YEAR(-1) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Age + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/date_time/fods/yearfrac.fods b/sc/qa/unit/data/functions/date_time/fods/yearfrac.fods new file mode 100644 index 000000000..adbfe0fac --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/yearfrac.fods @@ -0,0 +1,1479 @@ + + + + 2016-05-11T11:31:25.267000000P0D1LibreOffice/5.1.1.3$Windows_x86 LibreOffice_project/89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d + + + 0 + 0 + 34127 + 15017 + + + view1 + + + 0 + 7 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 6 + 33 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1168 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + true + true + true + true + 12632256 + true + false + true + 3 + true + false + false + 1270 + 1270 + 1 + 1 + true + true + true + PDF-XChange 4.0 + +AX+/1BERi1YQ2hhbmdlIDQuMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUERGLVhDaGFuZ2UgNC4wAAAAAAAAAAAAAAAAAAAAAAAWAAEAGgUAAAAAAAAEAAhSAAAEdAAAM1ROVwYAUABEAEYALQBYAEMAaABhAG4AZwBlACAANAAuADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAATcADgEEwwBAAEACQCaCzQIZAABAAAALAECAAEALAEAAAAAQQA0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAAAADQIAACaCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAERDWFAEAAAAAQAAAAAAAAA0CAAAmgsAAAAAAAAsAQAAZAAAAAEAAABDAHUAcgByAGUAbgB0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQwA6AFwAcABvAHIAdABhAGIAbABlAFwAUABvAHIAdABhAGIAbABlAEEAcABwAHMAXABMAGkAYgByAGUATwBmAGYAaQBjAGUAUABvAHIAdABhAGIAbABlAFwAQQBwAHAAXABsAGkAYgByAGUAbwBmAGYAaQBjAGUAXABwAHIAbwBnAHIAYQBtAFwAcwBvAGYAZgBpAGMAZQAuAGIAaQBuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABIAQ09NUEFUX0RVUExFWF9NT0RFDgBEVVBMRVhfVU5LTk9XTg== + + + en + US + + + + + + 0 + false + true + true + false + false + false + 7 + + + + + + + + + + + + + + + + + + + + + + + + + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + + + € + + + - + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + . + + . + + + + : + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + YEARFRAC Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Yearfrac formulas + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Date 1 + + + Date 2 + + + Function + + + Formula + + + Expected Value + + + Correct? + + + Test purpose + + + + + + 1 + + + total of tests + + + + + 01.01.2001 19:27:41 + + + 01.01.2002 12:10:30 + + YEARFRAC(A3;B3;0) + + + 1,000000 + + + 1,000000 + + + 1 + + + YEARFRAC ignores the time portion of the date, truncating it + + + + + 01.01.2002 + + + 01.01.2001 + + YEARFRAC(A4;B4;0) + + + 1,000000 + + + 1,000000 + + + 1 + + + The order of the dates does not matter. Date 1 can be before or after Date 2 + + + + + 01.01.2000 + + YEARFRAC(A5;B5;0) + + + 0,000000 + + + 0,000000 + + + 1 + + + If the dates are equal, the result is 0 + + + + + 01.01.2002 19:27:41 + + + 01.01.2002 12:10:30 + + YEARFRAC(A6;B6;0) + + + 0,000000 + + + 0,000000 + + + 1 + + + Again, ignore the time portion. If the dates are equal, the result is 0 + + + + + 31.01.2010 + + + 31.07.2010 + + YEARFRAC(A7;B7;0) + + + 0,500000 + + + 0,500000 + + + 1 + + + both days-of-month are 31 → 180/360 + + + + + 31.01.2010 + + + 01.08.2010 + + YEARFRAC(A8;B8;0) + + + 0,502778 + + + 0,502778 + + + 1 + + + date1's day-of-month is 31, but date2 is not → 181/360 + + + + + 30.01.2010 + + + 31.07.2010 + + YEARFRAC(A9;B9;0) + + + 0,500000 + + + 0,500000 + + + 1 + + + date1's day-of-month is 30 and date2's is 31 → 180/360 + + + + + 28.02.2010 + + + 28.02.2011 + + YEARFRAC(A10;B10;0) + + + 1,000000 + + + 1,000000 + + + 1 + + + both days are last day of February (non leap year) → 360/360 + + + + + 29.02.2000 + + + 29.02.2008 + + YEARFRAC(A11;B11;0) + + + 8,000000 + + + 8,000000 + + + 1 + + + both days are last day of February (leap year) → 8 full years + + + + + 28.02.2010 + + + 30.08.2010 + + YEARFRAC(A12;B12;0) + + + 0,500000 + + + 0,500000 + + + 1 + + + date1 is last date of February (non leap year) → 180/360 + + + + + 29.02.2008 + + + 30.08.2008 + + YEARFRAC(A13;B13;0) + + + 0,500000 + + + 0,500000 + + + 1 + + + date1 is last date of February (leap year) → 180/360 + + + + + 01.01.2001 19:27:41 + + + 01.01.2002 12:10:30 + + YEARFRAC(A14;B14;1) + + + 1,000000 + + + 1,000000 + + + 1 + + + YEARFRAC ignores the time portion of the date, truncating it + + + + + 01.01.2002 + + + 01.01.2001 + + YEARFRAC(A15;B15;1) + + + 1,000000 + + + 1,000000 + + + 1 + + + The order of the dates does not matter. Date 1 can be before or after Date 2 + + + + + 01.01.2000 + + YEARFRAC(A16;B16;1) + + + 0,000000 + + + 0,000000 + + + 1 + + + If the dates are equal, the result is 0 + + + + + 01.01.2002 19:27:41 + + + 01.01.2002 12:10:30 + + YEARFRAC(A17;B17;1) + + + 0,000000 + + + 0,000000 + + + 1 + + + Again, ignore the time portion. If the dates are equal, the result is 0 + + + + + 31.01.2002 + + + 01.05.2003 + + YEARFRAC(A18;B18;1) + + + 1,246575 + + + 1,246575 + + + 1 + + + More than a year apart, no leap years → (365+90)/365 + + + + + 31.01.2008 + + + 01.05.2009 + + YEARFRAC(A19;B19;1) + + + 1,247606 + + + 1,247606 + + + 1 + + + More than a year apart, with leap year → (366 + 90)( (366+365)/2) + + + + + 31.01.2007 + + + 01.05.2009 + + YEARFRAC(A20;B20;1) + + + 2,247263 + + + 2,247263 + + + 1 + + + Several years apart, with leap year → (365 + 366 + 90)( (365 + 366 + 365)/3) + + + + + 31.01.2007 + + + 01.05.2007 + + YEARFRAC(A21;B21;1) + + + 0,246575 + + + 0,246575 + + + 1 + + + In same year (not leap year) → 90/365 + + + + + 31.01.2008 + + + 01.05.2008 + + YEARFRAC(A22;B22;1) + + + 0,248634 + + + 0,248634 + + + 1 + + + in same year (leap year) → 91/366 + + + + + 15.12.2007 + + + 14.03.2008 + + YEARFRAC(A23;B23;1) + + + 0,245902 + + + 0,245902 + + + 1 + + + Less than a year, but February 29 is in range + + + + + 01.12.2007 + + + 29.02.2008 + + YEARFRAC(A24;B24;1) + + + 0,245902 + + + 0,245902 + + + 1 + + Less than a year, but date 2 is February 29th + + + + + + YEARFRAC(A13;B13;3) + + + 8,005479 + + + 8,005479 + + + 1 + + + Base 3 + + + + + + + YEARFRAC(A24;B24;4) + + + 0,252778 + + + 0,252778 + + + 1 + + + Base 4 + + + + + YEARFRAC("2008-01-31";B24;0) + + + 0,252778 + + + 0,252778 + + + 1 + + + date in “ “ + + + + + YEARFRAC(DATE(2008;1;31);B24;0) + + + 0,252778 + + + 0,252778 + + + 1 + + + date as function DATE + + + + + + YEARFRAC(DATE(1958;3;1);DATE(1996;1;1);1) + + + 37,836434 + + + 37,836434 + + + 1 + + + Bug 40100 + + + + + + YEARFRAC(DATE(1958;3;1);DATE(1995;12;31);1) + + + 37,835723 + + + 37,835723 + + + 1 + + + + + + + 29.02.2008 + + YEARFRAC(A33;B26;1) + + + 108,165617 + + + 108,165617 + + + 1 + + + AOO bug 122543 + + + + + YEARFRAC(A33;yearFracDate;1) + + + 108,165617 + + + 108,165617 + + + 1 + + + yearFracDate name + + + + + YEARFRAC(A5;B5) + + + 1 + + + 1 + + + 1 + + without 3rd argument + + + + + 28-02-2003 + + + 29-02-2004 + + + =(B34-A34)/YEARFRAC(A34;B34;1) + + + 365,500000 + + + 365,500000 + + + 1 + + + tdf69569, days in year + + + + + 28-02-2003 + + + 28-02-2004 + + + =(B35-A35)/YEARFRAC(A35;B35;1) + + + 365,000000 + + + 365,000000 + + + 1 + + + tdf69569, days in year + + + + + 28-02-2004 + + + 28-02-2005 + + + =(B36-A36)/YEARFRAC(A36;B36;1) + + + 366,000000 + + + 366,000000 + + + 1 + + + tdf69569, days in year + + + + + 01-01-2016 + + + 31-01-2016 + + + =(B37-A37)/YEARFRAC(A37;B37;1) + + + 366,000000 + + + 366,000000 + + + 1 + + + tdf69569, days in year + + + + + 01-01-2016 + + + 01-01-2017 + + + =(B38-A38)/YEARFRAC(A38;B38;1) + + + 366,000000 + + + 366,000000 + + + 1 + + + tdf69569, days in year + + + + + 31-01-2016 + + + 01-01-2017 + + + =(B39-A39)/YEARFRAC(A39;B39;1) + + + 366,000000 + + + 366,000000 + + + 1 + + + tdf69569, days in year + + + + + 31-01-2016 + + + 31-01-2017 + + + =(B40-A40)/YEARFRAC(A40;B40;1) + + + 366,000000 + + + 366,000000 + + + 1 + + + tdf69569, days in year + + + + + 29-02-2016 + + + 01-05-2016 + + + =(B41-A41)/YEARFRAC(A41;B41;1) + + + 366,000000 + + + 366,000000 + + + 1 + + + tdf69569, days in year + + + + + 30-04-2016 + + + 01-09-2016 + + + =(B42-A42)/YEARFRAC(A42;B42;1) + + + 366,000000 + + + 366,000000 + + + 1 + + + tdf69569, days in year + + + + + 30-11-2016 + + + 29-09-2017 + + + =(B43-A43)/YEARFRAC(A43;B43;1) + + + 365.000000 + + + 365,000000 + + + 1 + + + tdf69569, days in year + + + + + + + + + + + + + + + + + + + + + + diff --git a/sc/qa/unit/data/functions/date_time/fods/years.fods b/sc/qa/unit/data/functions/date_time/fods/years.fods new file mode 100644 index 000000000..724ee3476 --- /dev/null +++ b/sc/qa/unit/data/functions/date_time/fods/years.fods @@ -0,0 +1,1277 @@ + + + + 2016-06-16T21:00:15.480415068P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/800a196718abbfd38d93c845e563e055ef778b04 + + + 0 + 0 + 33007 + 15264 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + false + + + 2 + 12 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + false + + + Sheet2 + 1241 + 0 + 100 + 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 + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + € + + + + + + - + € + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00/00/0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + YEARS Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + SimpleYEARS formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + + DATA + + + + 1 + + + + + + #VALUE! + + + err + + + TRUE + + + =YEARS(K2,K3,K4:K6) + + + + 11/01/2014 + + + + 0 + + + + + + Err:502 + + + err + + + TRUE + + + =YEARS(K2,K2,K2) + + + + 11/30/2017 + + + + 0 + + + + + + 3 + + + 3 + + + TRUE + + + =YEARS(K2,K3,L2) + + + + + 11/11/2014 + + + + 0 + + + + + + Err:502 + + + err + + + TRUE + + + =YEARS(K2,K3,) + + + + 11/27/2014 + + + + 0 + + + + + + Err:502 + + + err + + + TRUE + + + =YEARS(K3,K2,) + + + + 11/28/2014 + + + + 0 + + + + + + Err:504 + + + err + + + TRUE + + + =YEARS(K2,K2+6,,{1;0;1;0;1;0;1}) + + + + + 12/24/2001 + + + + 1 + + + + + + 3 + + + 3 + + + TRUE + + + =YEARS(day1,day2,one) + + + + 12/25/2001 + + + + + + 2 + + + 2 + + + TRUE + + + =YEARS(DATE(2014,1,15),DATE(2016,4,1),0) + + + + 12/26/2001 + + + + + + #VALUE! + + + Err + + + TRUE + + + =WEEKS(DATE(2014,11,1),DATE(2014,11,30),{"Hello";"Eike";"!"}) + + + TDF#100409 + + + + + 12/31/2001 + + + + + + 115 + + + 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 + + + + + + + + + + + 12/01/2001 + + + + + + + + + + + + + + + + 12/30/1899 + + + + + + + + + + 12/30/1899 + + + + + + + + + Tdf#96756 bug + + + + 01/02/2015 + + + + + + + + + + + + + + + + + + + + + + + + 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). + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + + \ No newline at end of file -- cgit v1.2.3