diff options
Diffstat (limited to '')
38 files changed, 675 insertions, 0 deletions
diff --git a/sc/qa/unit/data/contentCSV/bugFix_Sheet2.csv b/sc/qa/unit/data/contentCSV/bugFix_Sheet2.csv new file mode 100644 index 000000000..c6fbdda00 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/bugFix_Sheet2.csv @@ -0,0 +1,6 @@ +success +fail +success +fail +success +fail diff --git a/sc/qa/unit/data/contentCSV/bugFix_Sheet4.csv b/sc/qa/unit/data/contentCSV/bugFix_Sheet4.csv new file mode 100644 index 000000000..ffd5da6fa --- /dev/null +++ b/sc/qa/unit/data/contentCSV/bugFix_Sheet4.csv @@ -0,0 +1 @@ +๑.๐๐ diff --git a/sc/qa/unit/data/contentCSV/cachedValue.csv b/sc/qa/unit/data/contentCSV/cachedValue.csv new file mode 100644 index 000000000..597eda148 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/cachedValue.csv @@ -0,0 +1,2 @@ +1.00,200.00%,$3.00,1/3/00,00:00,6.00E+000,7 1/5,TRUE,9,1000%,01-10 +1.00,200.00%,$3.00,1/3/00,12:00:00 AM,6.00E+000,7 1/5,TRUE,9,1000.00%,01-10 diff --git a/sc/qa/unit/data/contentCSV/cell-value.csv b/sc/qa/unit/data/contentCSV/cell-value.csv new file mode 100644 index 000000000..30ac22262 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/cell-value.csv @@ -0,0 +1,3 @@ +-2012,-1,0,1,2012 +-3.14,-0.99,0.01,3.14, +H,"Hello, Calc!",,"Calc is the spreadsheet program you've always needed. Newcomers find it intuitive and easy to learn. Professional data miners and number crunchers will appreciate the comprehensive range of advanced functions. Advanced DataPilot technology makes it easy to pull-in raw data from corporate databases, and then cross-tabulate, summarise, and convert it into meaningful information. Natural language formulas let you create formulas using words (for example: ""sales - costs""). The Intelligent Sum button inserts a sum function or a subtotal automatically, depending on the context. Wizards can guide you through choosing and using a comprehensive range of advanced spreadsheet functions. Or you can download templates from the LibreOffice template repository, for ready-made spreadsheet solutions. Styles and direct formatting makes it easy to apply flexible cell formatting options, including freely-rotating contents, templates, backgrounds, borders and much more. Become a spreadsheet expert, using templates with built-in functions, so that you can re-use a pre-prepared sheet and just focus on the immediate work. The Scenario Manager allows ""what if ..."" analysis at the touch of a button. For instance, you can compare profitability for high, medium and low sales forecasts. Calc's solver component lets you solve optimization problems in which the optimum value of a particular spreadsheet cell has to be calculated based on constraints provided in other cells. You can do collaborative work on spreadsheets, thanks to Calc's multiple-user support. You can share a spreadsheet, so that other users can easily add their data to it. The spreadsheet owner can then easily integrate the new data, in just a few clicks. This collaboration feature helps avoid editing conflicts. You can save your spreadsheets in OpenDocument format, the new international standard for documents. This XML-based format means that your files can be read even if the recipient is not a Calc user. Your spreadsheets will be accessible using any OpenDocument-compliant software. You can also open Microsoft Excel spreadsheets, and can also save your work in Excel format for sending to people still locked into Microsoft products. If you only need to make your data readable, but on a wide range of devices and platforms, you can export to Portable Document Format (.pdf). Calc can read .xlsx files created with Microsoft Office 2007 for Windows or Microsoft Office 2008 for Mac OS X.", diff --git a/sc/qa/unit/data/contentCSV/conditionalFormatting.csv b/sc/qa/unit/data/contentCSV/conditionalFormatting.csv new file mode 100644 index 000000000..ac8d2128a --- /dev/null +++ b/sc/qa/unit/data/contentCSV/conditionalFormatting.csv @@ -0,0 +1,2 @@ +-$2,$0,1 1/5,1.23E+004 +05:35,0.00 USD,1500%,01/02/00 diff --git a/sc/qa/unit/data/contentCSV/dataValidity1.csv b/sc/qa/unit/data/contentCSV/dataValidity1.csv new file mode 100644 index 000000000..13fbdc94c --- /dev/null +++ b/sc/qa/unit/data/contentCSV/dataValidity1.csv @@ -0,0 +1,4 @@ +,, +,,Enter a number greater than 3.14 +,,3.141 +,,999 diff --git a/sc/qa/unit/data/contentCSV/dataValidity2.csv b/sc/qa/unit/data/contentCSV/dataValidity2.csv new file mode 100644 index 000000000..b54c93320 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/dataValidity2.csv @@ -0,0 +1,8 @@ +,,,,,, +,,,,,, +,,Enter a whole number between 1 and 10,,,, +,,4,10,,, +,,3,,,, +,,,,,, +,,,,,, +,,5,5,5,5,5 diff --git a/sc/qa/unit/data/contentCSV/dataValidity3.csv b/sc/qa/unit/data/contentCSV/dataValidity3.csv new file mode 100644 index 000000000..a8c82ceca --- /dev/null +++ b/sc/qa/unit/data/contentCSV/dataValidity3.csv @@ -0,0 +1,4 @@ +"",, +"",,Enter text not a numeric value. +"",,AAAA +"",,AAA12 diff --git a/sc/qa/unit/data/contentCSV/database-functions.csv b/sc/qa/unit/data/contentCSV/database-functions.csv new file mode 100644 index 000000000..df547d7f9 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/database-functions.csv @@ -0,0 +1,12 @@ +44.25 +2 +5 +7 +51 +150 +89760 +6.36396103067893 +3 +1650 +27 +4 diff --git a/sc/qa/unit/data/contentCSV/dataprovider.csv b/sc/qa/unit/data/contentCSV/dataprovider.csv new file mode 100644 index 000000000..7031f2dff --- /dev/null +++ b/sc/qa/unit/data/contentCSV/dataprovider.csv @@ -0,0 +1,3 @@ +-2012,-1,0,1,2012 +-3.14,-0.99,0.01,3.14 +H,"Hello, Calc!" diff --git a/sc/qa/unit/data/contentCSV/date-time-functions.csv b/sc/qa/unit/data/contentCSV/date-time-functions.csv new file mode 100644 index 000000000..09cf42bfd --- /dev/null +++ b/sc/qa/unit/data/contentCSV/date-time-functions.csv @@ -0,0 +1,31 @@ +30347 +38,1,27,457,13937,57 +19925 +30,31,1,21 +3652 +5150 +30,28,29 +366,365 +41749 +36890 +37346 +17 +1,0 +58,59,45 +4 +2,3 +17 +15 +.18 +0,0.6666666667,0.5 +4,3,4 +52 +1,1,52 +1,52 +52 +10,11 +52,52 +37253 +1899,1900,1991 +0.5,0.4972677596,0.5055555556,0.498630137,0.5 +1,2 diff --git a/sc/qa/unit/data/contentCSV/fdo36933test.csv b/sc/qa/unit/data/contentCSV/fdo36933test.csv new file mode 100644 index 000000000..1e8b31496 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/fdo36933test.csv @@ -0,0 +1 @@ +6 diff --git a/sc/qa/unit/data/contentCSV/fdo43534test.csv b/sc/qa/unit/data/contentCSV/fdo43534test.csv new file mode 100644 index 000000000..8a15fab2c --- /dev/null +++ b/sc/qa/unit/data/contentCSV/fdo43534test.csv @@ -0,0 +1,10 @@ +1,1,1,data +l,v,b +G,F0,P2,F0- +1,1 +0 +C2- +$A:$A$7 +15 +',",^ +0,1 diff --git a/sc/qa/unit/data/contentCSV/fdo43700test.csv b/sc/qa/unit/data/contentCSV/fdo43700test.csv new file mode 100644 index 000000000..737798c36 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/fdo43700test.csv @@ -0,0 +1,3 @@ +3 +3 +1 diff --git a/sc/qa/unit/data/contentCSV/fdo48621_broken_quotes_exported.csv b/sc/qa/unit/data/contentCSV/fdo48621_broken_quotes_exported.csv new file mode 100644 index 000000000..dfc83c5f3 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/fdo48621_broken_quotes_exported.csv @@ -0,0 +1,90 @@ +i80358,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"abc"" d ""ef",shall be:,"abc"" d ""ef",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"a""b, ""a",shall be:,"a""b, ""a",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +i78926_input.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +2,5,GR010 015 1001,/image/grimas/015/1001.jpg,/image/grimas/015/1001.jpg,/image/grimas/015/1001.jpg,,,,,,,,,,,,,5.45,0,0000-00-00 00:00:00,0000-00-00 00:00:00,0000-00-00 00:00:00,0.05,1,2,81,4,0,1,0,2000,0,0,0,"0 +" +3,5,GR010 015 1002,/image/grimas/015/1002.jpg,/image/grimas/015/1002.jpg,/image/grimas/015/1002.jpg,,,,,,,,,,,,,5.45,0,0000-00-00 00:00:00,0000-00-00 00:00:00,0000-00-00 00:00:00,0.05,1,2,81,4,0,0,0,2000,0,0,0,"0 +" +,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +i78926_input.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +772,3,SPAZZOLA ARIA BABYLISS 32,image/APP.ELET/Varie/Babyliss-Spazzola-Elettrica.jpg,image/APP.ELET/Varie/Babyliss-Spazzola-Elettrica.jpg,image/APP.ELET/Varie/Babyliss-Spazzola-Elettrica.jpg,,,,,,,,,,,,,33,0,2006-11-07 09:26:16,2007-05-24 17:54:24,NULL,1,1,2,86,150,0,0,0,2000,0,,, +773,1,"BIGODINI RISCALDANTI \""BA",image/APP.ELET/Varie/Bigodini-caldi.jpg,image/APP.ELET/Varie/Bigodini-caldi.jpg,image/APP.ELET/Varie/Bigodini-caldi.jpg,,,,,,,,,,,,,57.91,0,2006-11-07 09:26:16,2006-11-07 09:26:16,0000-00-00 00:00:00,0.7,1,2,86,152,0,1,0,2000,0,0,0,0 +774,3,"PIASTRA \""BABYLISS\"" PRO C",image/APP.ELET/piastre/Piastre-Babyliss-2564E.jpg,image/APP.ELET/piastre/Piastre-Babyliss-2564E.jpg,image/APP.ELET/piastre/Piastre-Babyliss-2564E.jpg,,,,,,,,,,,,,78,0,2006-11-07 09:26:16,2006-12-13 19:18:31,0000-00-00 00:00:00,0.7,1,2,86,148,0,0,0,2000,0,0,0,0 +775,0,PHON ULTRON MAXI 2200W+1,image/APP.ELET/phon/Phon-Ultron-1500W.jpg,image/APP.ELET/phon/Phon-Ultron-1500W.jpg,image/APP.ELET/phon/Phon-Ultron-1500W.jpg,,,,,,,,,,,,,26.66,0,2006-11-07 09:26:16,2006-12-13 18:57:03,0000-00-00 00:00:00,0.7,1,2,101,158,0,0,0,2000,0,0,0,0 +,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +i78926_inconsistent_double_quote_behavior.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Description,Description,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +The following text breaks everything,"OpenOffice.org calc doesn't "" like quotes embedded in fields.",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +This field will fix everything,"Here is the "" fix",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +First fixed record,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +This field will break things again,"Mismatched quote "" must be after some quoted text",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +This field will fix everything,"Here is the "" fix",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +First fixed record,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +This next field will /not/ break things because /this/ field is not quoted,"Mismatched quote "" must be after some quoted text",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +i80385_test1.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +test,"a""b, ""a"," d""a""c ", m ,j ,d,"b""A""","D""E","f,1","a,b","de""b,a",,,,,,,,,,,,,,,,,,,,,,,,, +"abcdef"" test ""abc","def""g""h","def""gh""",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"this is +a test","yes +it +works",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +No it doesn't,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"yes it,"",""does",no,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"""""a,cd""e +""a""b"" +",<- needed to end test file here,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +i80385_test2.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +test,"a""b, ""a"," d""a""c ", m ,j ,d,"b""A""","D""E","f,1","a,b","de""b,a +""abcdef"" test ""abc","def""g""h","def""gh""",,,,,,,,,,,,,,,,,,,,,,, +"this is +a test","yes +it +works",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +No it doesn't,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"yes it,"",""does",no,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"""""a,cd""e +""a""b"" +",<- needed to end test file here,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +i80385_test3.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +test,"a""b, ""a"," d""a""c ", m ,j ,d,"b""A""","D""E","f,1","a,b","de""b,a",,,,,,,,,,,,,,,,,,,,,,,,, +"abcdef"" test ""abc","def""g""h","def""gh""",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"this is +a test","yes +it +works",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +No it doesn't,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"yes it,"",""does",no,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"""""a,cd""e +""a""b""",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +i80385_test4.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +test,"a""b, ""a"," d""a""c ", m ,j ,d,"b""A""","D""E","f,1","a,b","de""b,a +""abcdef"" test ""abc","def""g""h","def""gh""",,,,,,,,,,,,,,,,,,,,,,, +"this is +a test","yes +it +works",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +No it doesn't,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"yes it,"",""does",no,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, +"""""a,cd""e +""a""b""",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, diff --git a/sc/qa/unit/data/contentCSV/fdo64229b.csv b/sc/qa/unit/data/contentCSV/fdo64229b.csv new file mode 100644 index 000000000..3fcdf275a --- /dev/null +++ b/sc/qa/unit/data/contentCSV/fdo64229b.csv @@ -0,0 +1,3 @@ +2,4,2,4 +2,4,2,4 +2,4,2,4 diff --git a/sc/qa/unit/data/contentCSV/financial-functions.csv b/sc/qa/unit/data/contentCSV/financial-functions.csv new file mode 100644 index 000000000..540d0959b --- /dev/null +++ b/sc/qa/unit/data/contentCSV/financial-functions.csv @@ -0,0 +1,58 @@ +16.9444444444444 +20.5479452054794 +930 +375 +71 +92 +110 +37026 +2 +2 +-57.5412415342252 +-11135.2321307508,-937.5 +-3669.73551569782 +-934.107123420898,-68.2782711809783 +1075 +1721.80586824866 +0.0372448979591837 +1.125,1.125 +1.02,1.1 +79.4907946994012 +5.99195013802694 +0.0535426673707582 +0.10112312546402 +-4234 +1124.76 +0.0812374805252615 +-352.973422514773 +0.113321028236252 +-300 +4.02068710841898 +0.941647376706893 +0.127303166959042 +0.052500319868356 +-12.0207780851554 +49.432121038173 +99.8782860147214 +99.8782860147214 +0.0448731663302424 +-715.955334437392 +-350.992937038239 +95.0428743993921 +99.7958333333333 +99.984498875557 +-35019.3680845542 +0.00770147248823279 +1014.42026586264 +0.074569931823542 +553.571428571429 +13333.3333333333 +0.094151493565943 +98.45 +0.0914169629253423 +8603.80245372397 +0.194818475056105 +332.570918796713 +0.0650000069 +0.0609543337 +0.052822572 diff --git a/sc/qa/unit/data/contentCSV/hard-recalc.csv b/sc/qa/unit/data/contentCSV/hard-recalc.csv new file mode 100644 index 000000000..5d7a586fd --- /dev/null +++ b/sc/qa/unit/data/contentCSV/hard-recalc.csv @@ -0,0 +1 @@ +2+2=,4 diff --git a/sc/qa/unit/data/contentCSV/information-functions.csv b/sc/qa/unit/data/contentCSV/information-functions.csv new file mode 100644 index 000000000..876951eb8 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/information-functions.csv @@ -0,0 +1,20 @@ +27,1,4,$E$1,$Logical.$A$1,4,b,v,l +6 +"=CELL(""ROW"",AA1)","=ADDRESS(2,3)" +FALSE,TRUE,FALSE +FALSE,TRUE,FALSE,TRUE +TRUE,FALSE,TRUE,TRUE +1,0,0,1 +TRUE,FALSE,FALSE +FALSE,FALSE,FALSE,TRUE +TRUE,FALSE,FALSE,FALSE +TRUE,TRUE,FALSE +TRUE,FALSE,TRUE +1,0,0,1,0 +TRUE,TRUE,FALSE,FALSE,FALSE,FALSE +FALSE,TRUE,FALSE,TRUE +0,1,42,0 +#N/A +1,2,8,64,16 +TRUE,FALSE +FALSE,TRUE diff --git a/sc/qa/unit/data/contentCSV/logical-functions.csv b/sc/qa/unit/data/contentCSV/logical-functions.csv new file mode 100644 index 000000000..902009be6 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/logical-functions.csv @@ -0,0 +1,7 @@ +FALSE,FALSE,FALSE,TRUE,FALSE +FALSE +TRUE,FALSE,4,1 +TRUE,FALSE +FALSE,TRUE,TRUE,TRUE,TRUE +TRUE +FALSE,TRUE,TRUE diff --git a/sc/qa/unit/data/contentCSV/mathematical-functions.csv b/sc/qa/unit/data/contentCSV/mathematical-functions.csv new file mode 100644 index 000000000..a3577dd15 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/mathematical-functions.csv @@ -0,0 +1,76 @@ +0,1,10 +0.5,0,1 +0,Err:502 +0.5,0.75,0.25 +3.1415926536 +1,1,3,-3,-5,5 +0,2,12,-4,-6,4 +4,Err:502,Err:502 +14,Err:502 +10,Err:502 +3,48 +48,3 +0.7071067812,"0.00" +0.7071067812,-1 +8 +12 +5 +"1.2","1","0","1000" +2,4,Err:502 +7.2672834168,195.583 +-12 +-12,-12,-10 +1,-1 +15,1.5 +0.8509181282 +1 +1.4142135624,2 +1.4142135624,2 +5 +1.5222612189 +0,1.5707963268,30 +-5.1929877137,4 +0.7853981634,45 +0.7853981634,45 +0 +1 +1,1 +2.5066282746 +1.3130352855 +180 +2.7182818285 +6,1 +5,-2 +4,2,0,-2 +8,2 +5,5 +TRUE,FALSE,TRUE,TRUE,FALSE +TRUE,FALSE,TRUE,TRUE +128000 +75 +3 +6 +1.23,-1.234 +1.0986122887,321 +2.0959032743,4 +0.6989700043 +-10 +-10 +-10,-10,-12 +84 +64 +24 +24,120,1.4024,6,#DIV/0! +14,24,33,66 +1,1.25,3 +3,4 +1.5707963268,1.308996939 +1.23,45,-45,900,1.2 +2,2,5,3,5,3,1 +1.41,1.3,46,-46,1000 +0 +8,48.3,5.25 +-20,5.25,48,48,18,210,72,14 +1,1 +0 +7.27,195.58 diff --git a/sc/qa/unit/data/contentCSV/matrix.csv b/sc/qa/unit/data/contentCSV/matrix.csv new file mode 100644 index 000000000..fb4a32939 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/matrix.csv @@ -0,0 +1,10 @@ +10,55 +20,54 +30,47 +40,52 +50,50 +60,37 +70,48 +80,55 +90,50 +100,52 diff --git a/sc/qa/unit/data/contentCSV/matrix2.csv b/sc/qa/unit/data/contentCSV/matrix2.csv new file mode 100644 index 000000000..8450f0d01 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/matrix2.csv @@ -0,0 +1,6 @@ +Matrices with errors and other misc potential problems: +Err:502,Err:502,Err:502, +#N/A,#N/A,#N/A, +TRUE,TRUE,TRUE, +FALSE,FALSE,FALSE, +42,,42,, diff --git a/sc/qa/unit/data/contentCSV/matrix3.csv b/sc/qa/unit/data/contentCSV/matrix3.csv new file mode 100644 index 000000000..4417d2117 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/matrix3.csv @@ -0,0 +1,6 @@ +1,,1,, +1, +#DIV/0! +1 +1 +#DIV/0! diff --git a/sc/qa/unit/data/contentCSV/merged1.csv b/sc/qa/unit/data/contentCSV/merged1.csv new file mode 100644 index 000000000..708ab3a2a --- /dev/null +++ b/sc/qa/unit/data/contentCSV/merged1.csv @@ -0,0 +1,16 @@ +merged,,,,,,, +,,,,,,, +,,,,,,,another merged +,,,,,,, +,,,,,,, +,,,,,,, +,,,,,,, +,,,,,,, +,,,,,,, +,,,,,,, +,,,,,,, +,,,,,,, +,,,,,,, +,,,,,,, +,,,,,,, +,,,yet another merged,,,, diff --git a/sc/qa/unit/data/contentCSV/merged2.csv b/sc/qa/unit/data/contentCSV/merged2.csv new file mode 100644 index 000000000..68eef2871 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/merged2.csv @@ -0,0 +1,4 @@ +,,,, +,,,, +,,,, +,,,,merged on another sheet diff --git a/sc/qa/unit/data/contentCSV/new_cond_format_test.csv b/sc/qa/unit/data/contentCSV/new_cond_format_test.csv new file mode 100644 index 000000000..37893fc47 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/new_cond_format_test.csv @@ -0,0 +1,22 @@ +,top n elements,,bottom n elements,,top n percent,,bottom n percent,,above average,,below average,,above equal average,,below equal average +,1,,1.00,,1,,1.00,,1,,1.00,,2,,2.00 +,2,,2.00,,2,,2.00,,2,,2.00,,3,,3.00 +,3,,3.00,,3,,3,,3,,3.00,,4,,4.00 +,4,,4,,4,,4,,4,,4.00,,5,,5.00 +,5,,5,,5,,5,,5,,5.00,,6,,6.00 +,6,,6,,6,,6,,6,,6.00,,7,,7.00 +,7,,7,,7,,7,,7,,7.00,,11.00,,11 +,10,,10,,10,,10,,10.00,,10,,10.00,,10.00 +,11,,11,,11,,11,,11.00,,11,,11.00,,11 +,12,,12,,12,,12,,12.00,,12,,12.00,,12 +,13,,13,,13,,13,,13.00,,13,,13.00,,13 +,14,,14,,14,,14,,14.00,,14,,14.00,,14 +,15,,15,,15,,15,,15.00,,15,,15.00,,15 +,16.00,,16,,16,,16,,16.00,,16,,16.00,,16 +,17.00,,17,,17,,17,,17.00,,17,,17.00,,17 +,18.00,,18,,18,,18,,18.00,,18,,18.00,,18 +,19.00,,19,,19.00,,19,,19.00,,19,,19.00,,19 +,20.00,,20,,20.00,,20,,20.00,,20,,20.00,,20 +,1,,1.00,,1,,1.00,,1,,1.00,,2,,2.00 +,2,,2.00,,2,,2.00,,2,,2.00,,2,,2.00 +,3,,3.00,,3,,3,,3,,3.00,,3,,3.00 diff --git a/sc/qa/unit/data/contentCSV/new_cond_format_test_export.csv b/sc/qa/unit/data/contentCSV/new_cond_format_test_export.csv new file mode 100644 index 000000000..37893fc47 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/new_cond_format_test_export.csv @@ -0,0 +1,22 @@ +,top n elements,,bottom n elements,,top n percent,,bottom n percent,,above average,,below average,,above equal average,,below equal average +,1,,1.00,,1,,1.00,,1,,1.00,,2,,2.00 +,2,,2.00,,2,,2.00,,2,,2.00,,3,,3.00 +,3,,3.00,,3,,3,,3,,3.00,,4,,4.00 +,4,,4,,4,,4,,4,,4.00,,5,,5.00 +,5,,5,,5,,5,,5,,5.00,,6,,6.00 +,6,,6,,6,,6,,6,,6.00,,7,,7.00 +,7,,7,,7,,7,,7,,7.00,,11.00,,11 +,10,,10,,10,,10,,10.00,,10,,10.00,,10.00 +,11,,11,,11,,11,,11.00,,11,,11.00,,11 +,12,,12,,12,,12,,12.00,,12,,12.00,,12 +,13,,13,,13,,13,,13.00,,13,,13.00,,13 +,14,,14,,14,,14,,14.00,,14,,14.00,,14 +,15,,15,,15,,15,,15.00,,15,,15.00,,15 +,16.00,,16,,16,,16,,16.00,,16,,16.00,,16 +,17.00,,17,,17,,17,,17.00,,17,,17.00,,17 +,18.00,,18,,18,,18,,18.00,,18,,18.00,,18 +,19.00,,19,,19.00,,19,,19.00,,19,,19.00,,19 +,20.00,,20,,20.00,,20,,20.00,,20,,20.00,,20 +,1,,1.00,,1,,1.00,,1,,1.00,,2,,2.00 +,2,,2.00,,2,,2.00,,2,,2.00,,2,,2.00 +,3,,3.00,,3,,3,,3,,3.00,,3,,3.00 diff --git a/sc/qa/unit/data/contentCSV/new_cond_format_test_sheet2.csv b/sc/qa/unit/data/contentCSV/new_cond_format_test_sheet2.csv new file mode 100644 index 000000000..9bbdfede1 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/new_cond_format_test_sheet2.csv @@ -0,0 +1,3 @@ +2.00,2 +1,1.000 +4.00,3 diff --git a/sc/qa/unit/data/contentCSV/numberFormat.csv b/sc/qa/unit/data/contentCSV/numberFormat.csv new file mode 100644 index 000000000..c6aaf5a14 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/numberFormat.csv @@ -0,0 +1,9 @@ +2.00,-3.00 +40.10%,-22% +"$12,345.00","-$1,234.00" +2.59E+005,-2.35E+03 +25 31/82 +FALSE,TRUE +/> +258.9E3,-953E-06 +0.5 ,"/ 123.46" diff --git a/sc/qa/unit/data/contentCSV/rangeExp_Sheet2.csv b/sc/qa/unit/data/contentCSV/rangeExp_Sheet2.csv new file mode 100644 index 000000000..f6d5971b0 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/rangeExp_Sheet2.csv @@ -0,0 +1,6 @@ +6, 5 +7, 7 +0 +1, 2, 3 +4, 5, 6 +5 diff --git a/sc/qa/unit/data/contentCSV/repeatedColumns1.csv b/sc/qa/unit/data/contentCSV/repeatedColumns1.csv new file mode 100644 index 000000000..ffcf6c2dd --- /dev/null +++ b/sc/qa/unit/data/contentCSV/repeatedColumns1.csv @@ -0,0 +1 @@ +test,test,test,test,test,test diff --git a/sc/qa/unit/data/contentCSV/repeatedColumns2.csv b/sc/qa/unit/data/contentCSV/repeatedColumns2.csv new file mode 100644 index 000000000..e0020ad0a --- /dev/null +++ b/sc/qa/unit/data/contentCSV/repeatedColumns2.csv @@ -0,0 +1 @@ +5,5,5,5,5 diff --git a/sc/qa/unit/data/contentCSV/shared-formula.csv b/sc/qa/unit/data/contentCSV/shared-formula.csv new file mode 100644 index 000000000..071939893 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/shared-formula.csv @@ -0,0 +1,9 @@ +1 +2 +3 +4 +5 +6 +7 +8 +9 diff --git a/sc/qa/unit/data/contentCSV/spreadsheet-functions.csv b/sc/qa/unit/data/contentCSV/spreadsheet-functions.csv new file mode 100644 index 000000000..8b8caa53f --- /dev/null +++ b/sc/qa/unit/data/contentCSV/spreadsheet-functions.csv @@ -0,0 +1,19 @@ +$C$2,$A$1,Sheet.B$2,Sheet!R2C2 +2,4,4,5,6,15,15,6,9 +1,3,4,4,2,2 +2,4,7,8,4 +4,5,#N/A,8,1 +24,4,4,4,4,3,4,4,0,12,9,9 +3,3,3,2,3,test +1,3,1,1,1,0 +4,1,2 +32767,502,#N/A +Hyperlink,http://www.example.org +3,1 +1,3,5 +bb,bb,zz +4,Today +yy,test,PLUM,VAN +4,55 +7,3 +2,7 diff --git a/sc/qa/unit/data/contentCSV/statistical-functions.csv b/sc/qa/unit/data/contentCSV/statistical-functions.csv new file mode 100644 index 000000000..2e3c45cdb --- /dev/null +++ b/sc/qa/unit/data/contentCSV/statistical-functions.csv @@ -0,0 +1,154 @@ +1,1,2,0,3,3 +0.3676796136,0.3676796136 +6.1730730529,6.1730730529 +0.7768698399 +0.7768698399 +4,6,14 +3,6,14,4 +0.0209708029,0.0209708029 +3.2830202868, +11.0704976935,13.388222599 +0.4549364231 +0.0209757694 +0.1115650801,0.7768698399 +0.0002098623,0.5276334473 +11.0704976935 +0.0209708029 +0.0209757694 +7 +0.1938476563,0.1208496094 +0.1938476563,0.1208496094 +0.3501633938 +0.3501633938 +0.6854705811,1.4837646484 +0.9624023438 +0.2907100492 +0 +0 +5.1 +0.8090909091,1 +0.8090909091 +37.6363636364 +41.7937736351 +0.0753454347,0.0149568299 +0 +0 +1.6094379124 +1.6094379124 +0.8646647168 +0.8646647168 +0.3472657011 +0.4621171573 +0.5493061443 +0.9319331609 +0.081755009 +0.9319331609 +0.6143396437 +0.7095282499,0.3856603563 +0.6143396437 +2 +0.1930408167 +0.0106510993 +0.0106510993 +0.1930408167 +8 +0.1735008392 +-29 +-24.8571428571 +-32.25 +-0.6063659074 +0.2976325427 +0.2939945977 +0.2939945977 +4 +4 +4 +0.9278398202 +0.9278398202 +0.0317396518,0.0317396518,0.3989422804 +0.667 +0.625 +0.667 +1.6 +1.1 +1.9 +-0.6063659074 +69.4077578277 +69.4077578277 +0.0299454931,0.9192433408 +0.0299454931,0.9192433408 +0.25,0.75 +0.25 +6 +6 +6 +0,1 +1 +9,7 +200,14 +200,14 +3.8000923613 +3.8000923613 +1.7416698335 +0.8646647168 +0.8646647168 +6.09 +6.09 +6.7666666667 +6.09 +6.7666666667 +6.7666666667 +0.4557955617 +1.9431802805 +0.4557955617 +1.221255395 +-1.4397557473 +0.1704465662 +0.3408931323 +0.8295534338 +3.54474625858076E-005 +2.708305094 +2.4677925359 +2.4677925359 +2.6012817354 +2.4677925359 +2.6012817354 +2.6012817354 +1 +-0.1225598712 +-0.1363480926 +2 +9 +2 +0.5,0.1 +121,216 +120 +1.333334673 +0.8413447461 +1.333334673 +0.2419707245,0.8413447461 +0.0450794929 +60.9 +0 +100 +0 +0 +0 +0 +0 +1 +0 +0 +0 +0 +0 +0 +0 +0 +0 +0.927295218 +3 +13 +15,48,1 +10.1387001854,6.2137119224 +0 diff --git a/sc/qa/unit/data/contentCSV/text-functions.csv b/sc/qa/unit/data/contentCSV/text-functions.csv new file mode 100644 index 000000000..8b0ebeed8 --- /dev/null +++ b/sc/qa/unit/data/contentCSV/text-functions.csv @@ -0,0 +1,41 @@ +1014,2002 +ABCDEFGHIJKLMNOPQRSTUVWXYZ +"0017","10001","00FF" +A,a,d +dog +72,104,97 +Good Morning Mrs. Doe +17,64206,5 +$255.00,$367.46 +FALSE + +6,2 +1234567.890 + +t,tes,testing + +6 +12 +happy,ape +te,est,est + +1000000.35,4500.75 +Cat,Monkey +output,outputce +shoeshoeshoe +day + +CMXCIX,CMXCIX,LMVLIV,XMIX,VMIV,IM +onpba +2 +12abc12abc12abc,12312abc123 +,12345 +12.35,012.35 +hello world + +169 +MAYBE +4321 +un +ff +out diff --git a/sc/qa/unit/data/contentCSV/user-defined-function.csv b/sc/qa/unit/data/contentCSV/user-defined-function.csv new file mode 100644 index 000000000..45a4fb75d --- /dev/null +++ b/sc/qa/unit/data/contentCSV/user-defined-function.csv @@ -0,0 +1 @@ +8 |