From f19044f9c4adfa2adb303b2ff871706dc6e32532 Mon Sep 17 00:00:00 2001 From: Zdeněk Crhonek Date: Tue, 31 May 2016 08:16:24 +0200 Subject: add DAYSINYEAR test case Change-Id: I5475b2d77f0db9bddc70ab64c3d191aac12a04f6 --- sc/qa/unit/data/functions/fods/daysinyear.fods | 838 +++++++++++++++++++++++++ 1 file changed, 838 insertions(+) create mode 100644 sc/qa/unit/data/functions/fods/daysinyear.fods diff --git a/sc/qa/unit/data/functions/fods/daysinyear.fods b/sc/qa/unit/data/functions/fods/daysinyear.fods new file mode 100644 index 000000000000..f6135e95d13f --- /dev/null +++ b/sc/qa/unit/data/functions/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 -- cgit