excel: verify cell format

Test started at Wed Apr 25 13:11:02 CEST 2012, lasting 1823 ms.
Source: /raid/volume1/opt/webtest/webtestCC/CanooFunctionalTesting/selftests/tests/excel.xml:113:
Base URL (used by invoke steps with a relative URL): http://localhost:19090/selftest/
Simulated browser: IE6

Expand/Collapse nested steps: 

#	Result	Name	Parameter	Duration
1		invoke Resulting page	-> complete url http://localhost:19090/selftest/testExcel.xls url testExcel.xls	24
2		excelSelectSheet	sheetName Sheet2	23
3		excelVerifyCellStyle A bit of everything	align center border top:thick; bottom:dash dot; left:none; right:medium dash dot borderColor top:auto; bottom:plum; left:none; right:bright green cell B37 fillBackgroundColor red fillColor tan fillPattern thin diagonal stripe fontName Arial fontSize 12 fontStyle strikethrough bold italic underline textColor green valign top	7
4		excelVerifyCellStyle Border on a non existant cell	border none cell A1	3
5		excelVerifyCellStyle Colour by #rrggbb	borderColor #ff0000 cell D36	3
6		excelVerifyCellStyle Specific borders	border top:thin;bottom:dotted;left,right:none cell B5	4
7		excelVerifyCellStyle Specific borders and border colors	border left:medium dash dot;right:thick;top,bottom:none borderColor left:auto;right:orange;top,bottom:none cell C22	4
8		repeat Check Border Styles	counterName row endCount 30 startCount 4 step 2 # Result Name Parameter Duration   1 iteration wrapper Iteration 4   # Result Name Parameter Duration   1 excelStoreCellValue cell B4 property value 2   2 excelVerifyCellStyle border thin cell B4 3 6   2 iteration wrapper Iteration 6   # Result Name Parameter Duration   1 excelStoreCellValue cell B6 property value 2   2 excelVerifyCellStyle border dotted cell B6 3 6   3 iteration wrapper Iteration 8   # Result Name Parameter Duration   1 excelStoreCellValue cell B8 property value 2   2 excelVerifyCellStyle border hair cell B8 3 7   4 iteration wrapper Iteration 10   # Result Name Parameter Duration   1 excelStoreCellValue cell B10 property value 2   2 excelVerifyCellStyle border dashed cell B10 3 7   5 iteration wrapper Iteration 12   # Result Name Parameter Duration   1 excelStoreCellValue cell B12 property value 2   2 excelVerifyCellStyle border dash dot cell B12 4 7   6 iteration wrapper Iteration 14   # Result Name Parameter Duration   1 excelStoreCellValue cell B14 property value 2   2 excelVerifyCellStyle border dash dot dot cell B14 3 7   7 iteration wrapper Iteration 16   # Result Name Parameter Duration   1 excelStoreCellValue cell B16 property value 2   2 excelVerifyCellStyle border double cell B16 4 8   8 iteration wrapper Iteration 18   # Result Name Parameter Duration   1 excelStoreCellValue cell B18 property value 2   2 excelVerifyCellStyle border medium cell B18 3 7   9 iteration wrapper Iteration 20   # Result Name Parameter Duration   1 excelStoreCellValue cell B20 property value 2   2 excelVerifyCellStyle border medium dashed cell B20 4 7   10 iteration wrapper Iteration 22   # Result Name Parameter Duration   1 excelStoreCellValue cell B22 property value 1   2 excelVerifyCellStyle border medium dash dot cell B22 3 6   11 iteration wrapper Iteration 24   # Result Name Parameter Duration   1 excelStoreCellValue cell B24 property value 1   2 excelVerifyCellStyle border medium dash dot dot cell B24 4 7   12 iteration wrapper Iteration 26   # Result Name Parameter Duration   1 excelStoreCellValue cell B26 property value 1   2 excelVerifyCellStyle border slanted dash dot cell B26 4 9   13 iteration wrapper Iteration 28   # Result Name Parameter Duration   1 excelStoreCellValue cell B28 property value 4   2 excelVerifyCellStyle border thick cell B28 4 25   14 iteration wrapper Iteration 30   # Result Name Parameter Duration   1 excelStoreCellValue cell B30 property value 2   2 excelVerifyCellStyle border none cell B30 4 9	125
9		repeat Check Border and Text Colors	counterName row endCount 96 startCount 4 step 2 # Result Name Parameter Duration   1 iteration wrapper Iteration 4   # Result Name Parameter Duration   1 excelStoreCellValue cell D4 property color 2   2 excelVerifyCellStyle borderColor black cell D4 textColor black 3   3 excelVerifyCellStyle cell F4 fillColor black 4   4 excelVerifyCellStyle cell G4 fillBackgroundColor black 4 16   2 iteration wrapper Iteration 6   # Result Name Parameter Duration   1 excelStoreCellValue cell D6 property color 2   2 excelVerifyCellStyle borderColor brown cell D6 textColor brown 4   3 excelVerifyCellStyle cell F6 fillColor brown 4   4 excelVerifyCellStyle cell G6 fillBackgroundColor brown 54 65   3 iteration wrapper Iteration 8   # Result Name Parameter Duration   1 excelStoreCellValue cell D8 property color 2   2 excelVerifyCellStyle borderColor olive green cell D8 textColor olive green 4   3 excelVerifyCellStyle cell F8 fillColor olive green 4   4 excelVerifyCellStyle cell G8 fillBackgroundColor olive green 4 16   4 iteration wrapper Iteration 10   # Result Name Parameter Duration   1 excelStoreCellValue cell D10 property color 1   2 excelVerifyCellStyle borderColor dark green cell D10 textColor dark green 3   3 excelVerifyCellStyle cell F10 fillColor dark green 5   4 excelVerifyCellStyle cell G10 fillBackgroundColor dark green 4 16   5 iteration wrapper Iteration 12   # Result Name Parameter Duration   1 excelStoreCellValue cell D12 property color 2   2 excelVerifyCellStyle borderColor dark teal cell D12 textColor dark teal 4   3 excelVerifyCellStyle cell F12 fillColor dark teal 4   4 excelVerifyCellStyle cell G12 fillBackgroundColor dark teal 4 16   6 iteration wrapper Iteration 14   # Result Name Parameter Duration   1 excelStoreCellValue cell D14 property color 2   2 excelVerifyCellStyle borderColor dark blue cell D14 textColor dark blue 4   3 excelVerifyCellStyle cell F14 fillColor dark blue 4   4 excelVerifyCellStyle cell G14 fillBackgroundColor dark blue 4 16   7 iteration wrapper Iteration 16   # Result Name Parameter Duration   1 excelStoreCellValue cell D16 property color 2   2 excelVerifyCellStyle borderColor indigo cell D16 textColor indigo 4   3 excelVerifyCellStyle cell F16 fillColor indigo 4   4 excelVerifyCellStyle cell G16 fillBackgroundColor indigo 3 16   8 iteration wrapper Iteration 18   # Result Name Parameter Duration   1 excelStoreCellValue cell D18 property color 1   2 excelVerifyCellStyle borderColor 80% gray cell D18 textColor 80% gray 4   3 excelVerifyCellStyle cell F18 fillColor 80% gray 5   4 excelVerifyCellStyle cell G18 fillBackgroundColor 80% gray 5 18   9 iteration wrapper Iteration 20   # Result Name Parameter Duration   1 excelStoreCellValue cell D20 property color 2   2 excelVerifyCellStyle borderColor dark red cell D20 textColor dark red 4   3 excelVerifyCellStyle cell F20 fillColor dark red 5   4 excelVerifyCellStyle cell G20 fillBackgroundColor dark red 4 18   10 iteration wrapper Iteration 22   # Result Name Parameter Duration   1 excelStoreCellValue cell D22 property color 2   2 excelVerifyCellStyle borderColor orange cell D22 textColor orange 5   3 excelVerifyCellStyle cell F22 fillColor orange 5   4 excelVerifyCellStyle cell G22 fillBackgroundColor orange 5 18   11 iteration wrapper Iteration 24   # Result Name Parameter Duration   1 excelStoreCellValue cell D24 property color 2   2 excelVerifyCellStyle borderColor dark yellow cell D24 textColor dark yellow 4   3 excelVerifyCellStyle cell F24 fillColor dark yellow 9   4 excelVerifyCellStyle cell G24 fillBackgroundColor dark yellow 5 22   12 iteration wrapper Iteration 26   # Result Name Parameter Duration   1 excelStoreCellValue cell D26 property color 2   2 excelVerifyCellStyle borderColor green cell D26 textColor green 4   3 excelVerifyCellStyle cell F26 fillColor green 5   4 excelVerifyCellStyle cell G26 fillBackgroundColor green 5 18   13 iteration wrapper Iteration 28   # Result Name Parameter Duration   1 excelStoreCellValue cell D28 property color 3   2 excelVerifyCellStyle borderColor teal cell D28 textColor teal 5   3 excelVerifyCellStyle cell F28 fillColor teal 4   4 excelVerifyCellStyle cell G28 fillBackgroundColor teal 5 20   14 iteration wrapper Iteration 30   # Result Name Parameter Duration   1 excelStoreCellValue cell D30 property color 2   2 excelVerifyCellStyle borderColor blue cell D30 textColor blue 5   3 excelVerifyCellStyle cell F30 fillColor blue 5   4 excelVerifyCellStyle cell G30 fillBackgroundColor blue 5 18   15 iteration wrapper Iteration 32   # Result Name Parameter Duration   1 excelStoreCellValue cell D32 property color 2   2 excelVerifyCellStyle borderColor blue gray cell D32 textColor blue gray 5   3 excelVerifyCellStyle cell F32 fillColor blue gray 5   4 excelVerifyCellStyle cell G32 fillBackgroundColor blue gray 6 22   16 iteration wrapper Iteration 34   # Result Name Parameter Duration   1 excelStoreCellValue cell D34 property color 2   2 excelVerifyCellStyle borderColor 50% gray cell D34 textColor 50% gray 4   3 excelVerifyCellStyle cell F34 fillColor 50% gray 5   4 excelVerifyCellStyle cell G34 fillBackgroundColor 50% gray 5 19   17 iteration wrapper Iteration 36   # Result Name Parameter Duration   1 excelStoreCellValue cell D36 property color 2   2 excelVerifyCellStyle borderColor red cell D36 textColor red 5   3 excelVerifyCellStyle cell F36 fillColor red 5   4 excelVerifyCellStyle cell G36 fillBackgroundColor red 4 18   18 iteration wrapper Iteration 38   # Result Name Parameter Duration   1 excelStoreCellValue cell D38 property color 2   2 excelVerifyCellStyle borderColor light orange cell D38 textColor light orange 4   3 excelVerifyCellStyle cell F38 fillColor light orange 5   4 excelVerifyCellStyle cell G38 fillBackgroundColor light orange 5 17   19 iteration wrapper Iteration 40   # Result Name Parameter Duration   1 excelStoreCellValue cell D40 property color 3   2 excelVerifyCellStyle borderColor lime cell D40 textColor lime 4   3 excelVerifyCellStyle cell F40 fillColor lime 4   4 excelVerifyCellStyle cell G40 fillBackgroundColor lime 4 17   20 iteration wrapper Iteration 42   # Result Name Parameter Duration   1 excelStoreCellValue cell D42 property color 2   2 excelVerifyCellStyle borderColor sea green cell D42 textColor sea green 4   3 excelVerifyCellStyle cell F42 fillColor sea green 5   4 excelVerifyCellStyle cell G42 fillBackgroundColor sea green 4 17   21 iteration wrapper Iteration 44   # Result Name Parameter Duration   1 excelStoreCellValue cell D44 property color 2   2 excelVerifyCellStyle borderColor aqua cell D44 textColor aqua 4   3 excelVerifyCellStyle cell F44 fillColor aqua 5   4 excelVerifyCellStyle cell G44 fillBackgroundColor aqua 4 17   22 iteration wrapper Iteration 46   # Result Name Parameter Duration   1 excelStoreCellValue cell D46 property color 2   2 excelVerifyCellStyle borderColor light blue cell D46 textColor light blue 4   3 excelVerifyCellStyle cell F46 fillColor light blue 4   4 excelVerifyCellStyle cell G46 fillBackgroundColor light blue 4 17   23 iteration wrapper Iteration 48   # Result Name Parameter Duration   1 excelStoreCellValue cell D48 property color 2   2 excelVerifyCellStyle borderColor violet cell D48 textColor violet 4   3 excelVerifyCellStyle cell F48 fillColor violet 4   4 excelVerifyCellStyle cell G48 fillBackgroundColor violet 4 17   24 iteration wrapper Iteration 50   # Result Name Parameter Duration   1 excelStoreCellValue cell D50 property color 2   2 excelVerifyCellStyle borderColor 40% gray cell D50 textColor 40% gray 3   3 excelVerifyCellStyle cell F50 fillColor 40% gray 4   4 excelVerifyCellStyle cell G50 fillBackgroundColor 40% gray 5 17   25 iteration wrapper Iteration 52   # Result Name Parameter Duration   1 excelStoreCellValue cell D52 property color 2   2 excelVerifyCellStyle borderColor pink cell D52 textColor pink 20   3 excelVerifyCellStyle cell F52 fillColor pink 4   4 excelVerifyCellStyle cell G52 fillBackgroundColor pink 4 32   26 iteration wrapper Iteration 54   # Result Name Parameter Duration   1 excelStoreCellValue cell D54 property color 2   2 excelVerifyCellStyle borderColor gold cell D54 textColor gold 4   3 excelVerifyCellStyle cell F54 fillColor gold 4   4 excelVerifyCellStyle cell G54 fillBackgroundColor gold 4 16   27 iteration wrapper Iteration 56   # Result Name Parameter Duration   1 excelStoreCellValue cell D56 property color 2   2 excelVerifyCellStyle borderColor bright green cell D56 textColor bright green 4   3 excelVerifyCellStyle cell F56 fillColor bright green 5   4 excelVerifyCellStyle cell G56 fillBackgroundColor bright green 5 17   28 iteration wrapper Iteration 58   # Result Name Parameter Duration   1 excelStoreCellValue cell D58 property color 2   2 excelVerifyCellStyle borderColor turquoise cell D58 textColor turquoise 4   3 excelVerifyCellStyle cell F58 fillColor turquoise 4   4 excelVerifyCellStyle cell G58 fillBackgroundColor turquoise 4 16   29 iteration wrapper Iteration 60   # Result Name Parameter Duration   1 excelStoreCellValue cell D60 property color 2   2 excelVerifyCellStyle borderColor sky blue cell D60 textColor sky blue 57   3 excelVerifyCellStyle cell F60 fillColor sky blue 4   4 excelVerifyCellStyle cell G60 fillBackgroundColor sky blue 4 70   30 iteration wrapper Iteration 62   # Result Name Parameter Duration   1 excelStoreCellValue cell D62 property color 2   2 excelVerifyCellStyle borderColor plum cell D62 textColor plum 3   3 excelVerifyCellStyle cell F62 fillColor plum 4   4 excelVerifyCellStyle cell G62 fillBackgroundColor plum 4 17   31 iteration wrapper Iteration 64   # Result Name Parameter Duration   1 excelStoreCellValue cell D64 property color 2   2 excelVerifyCellStyle borderColor 25% gray cell D64 textColor 25% gray 4   3 excelVerifyCellStyle cell F64 fillColor 25% gray 4   4 excelVerifyCellStyle cell G64 fillBackgroundColor 25% gray 4 17   32 iteration wrapper Iteration 66   # Result Name Parameter Duration   1 excelStoreCellValue cell D66 property color 2   2 excelVerifyCellStyle borderColor rose cell D66 textColor rose 4   3 excelVerifyCellStyle cell F66 fillColor rose 4   4 excelVerifyCellStyle cell G66 fillBackgroundColor rose 4 16   33 iteration wrapper Iteration 68   # Result Name Parameter Duration   1 excelStoreCellValue cell D68 property color 2   2 excelVerifyCellStyle borderColor tan cell D68 textColor tan 4   3 excelVerifyCellStyle cell F68 fillColor tan 4   4 excelVerifyCellStyle cell G68 fillBackgroundColor tan 4 18   34 iteration wrapper Iteration 70   # Result Name Parameter Duration   1 excelStoreCellValue cell D70 property color 2   2 excelVerifyCellStyle borderColor pale blue cell D70 textColor pale blue 4   3 excelVerifyCellStyle cell F70 fillColor pale blue 4   4 excelVerifyCellStyle cell G70 fillBackgroundColor pale blue 4 17   35 iteration wrapper Iteration 72   # Result Name Parameter Duration   1 excelStoreCellValue cell D72 property color 3   2 excelVerifyCellStyle borderColor lavender cell D72 textColor lavender 3   3 excelVerifyCellStyle cell F72 fillColor lavender 4   4 excelVerifyCellStyle cell G72 fillBackgroundColor lavender 4 17   36 iteration wrapper Iteration 74   # Result Name Parameter Duration   1 excelStoreCellValue cell D74 property color 2   2 excelVerifyCellStyle borderColor periwinkle cell D74 textColor periwinkle 3   3 excelVerifyCellStyle cell F74 fillColor periwinkle 4   4 excelVerifyCellStyle cell G74 fillBackgroundColor periwinkle 4 17   37 iteration wrapper Iteration 76   # Result Name Parameter Duration   1 excelStoreCellValue cell D76 property color 3   2 excelVerifyCellStyle borderColor dark purple cell D76 textColor dark purple 3   3 excelVerifyCellStyle cell F76 fillColor dark purple 4   4 excelVerifyCellStyle cell G76 fillBackgroundColor dark purple 4 19   38 iteration wrapper Iteration 78   # Result Name Parameter Duration   1 excelStoreCellValue cell D78 property color 2   2 excelVerifyCellStyle borderColor coral cell D78 textColor coral 4   3 excelVerifyCellStyle cell F78 fillColor coral 4   4 excelVerifyCellStyle cell G78 fillBackgroundColor coral 4 17   39 iteration wrapper Iteration 80   # Result Name Parameter Duration   1 excelStoreCellValue cell D80 property color 2   2 excelVerifyCellStyle borderColor ocean blue cell D80 textColor ocean blue 4   3 excelVerifyCellStyle cell F80 fillColor ocean blue 5   4 excelVerifyCellStyle cell G80 fillBackgroundColor ocean blue 4 16   40 iteration wrapper Iteration 82   # Result Name Parameter Duration   1 excelStoreCellValue cell D82 property color 2   2 excelVerifyCellStyle borderColor ice blue cell D82 textColor ice blue 4   3 excelVerifyCellStyle cell F82 fillColor ice blue 4   4 excelVerifyCellStyle cell G82 fillBackgroundColor ice blue 4 16   41 iteration wrapper Iteration 84   # Result Name Parameter Duration   1 excelStoreCellValue cell D84 property color 2   2 excelVerifyCellStyle borderColor yellow cell D84 textColor yellow 4   3 excelVerifyCellStyle cell F84 fillColor yellow 4   4 excelVerifyCellStyle cell G84 fillBackgroundColor yellow 4 17   42 iteration wrapper Iteration 86   # Result Name Parameter Duration   1 excelStoreCellValue cell D86 property color 2   2 excelVerifyCellStyle borderColor white cell D86 textColor white 3   3 excelVerifyCellStyle cell F86 fillColor white 4   4 excelVerifyCellStyle cell G86 fillBackgroundColor white 4 16   43 iteration wrapper Iteration 88   # Result Name Parameter Duration   1 excelStoreCellValue cell D88 property color 2   2 excelVerifyCellStyle borderColor light yellow cell D88 textColor light yellow 4   3 excelVerifyCellStyle cell F88 fillColor light yellow 4   4 excelVerifyCellStyle cell G88 fillBackgroundColor light yellow 4 15   44 iteration wrapper Iteration 90   # Result Name Parameter Duration   1 excelStoreCellValue cell D90 property color 2   2 excelVerifyCellStyle borderColor light green cell D90 textColor light green 4   3 excelVerifyCellStyle cell F90 fillColor light green 4   4 excelVerifyCellStyle cell G90 fillBackgroundColor light green 4 16   45 iteration wrapper Iteration 92   # Result Name Parameter Duration   1 excelStoreCellValue cell D92 property color 2   2 excelVerifyCellStyle borderColor light turquoise cell D92 textColor light turquoise 4   3 excelVerifyCellStyle cell F92 fillColor light turquoise 4   4 excelVerifyCellStyle cell G92 fillBackgroundColor light turquoise 4 16   46 iteration wrapper Iteration 94   # Result Name Parameter Duration   1 excelStoreCellValue cell D94 property color 2   2 excelVerifyCellStyle borderColor ivory cell D94 textColor ivory 3   3 excelVerifyCellStyle cell F94 fillColor ivory 5   4 excelVerifyCellStyle cell G94 fillBackgroundColor ivory 4 16   47 iteration wrapper Iteration 96   # Result Name Parameter Duration   1 excelStoreCellValue cell D96 property color 3   2 excelVerifyCellStyle borderColor #123456 cell D96 textColor #123456 4   3 excelVerifyCellStyle cell F96 fillColor #123456 5   4 excelVerifyCellStyle cell G96 fillBackgroundColor #123456 4 18	964
10		repeat Check Fills	counterName row endCount 38 startCount 4 step 2 # Result Name Parameter Duration   1 iteration wrapper Iteration 4   # Result Name Parameter Duration   1 excelStoreCellValue cell I4 property pattern 2   2 excelVerifyCellStyle cell J4 fillPattern solid 4 8   2 iteration wrapper Iteration 6   # Result Name Parameter Duration   1 excelStoreCellValue cell I6 property pattern 3   2 excelVerifyCellStyle cell J6 fillPattern 75% gray 4 8   3 iteration wrapper Iteration 8   # Result Name Parameter Duration   1 excelStoreCellValue cell I8 property pattern 2   2 excelVerifyCellStyle cell J8 fillPattern 50% gray 4 8   4 iteration wrapper Iteration 10   # Result Name Parameter Duration   1 excelStoreCellValue cell I10 property pattern 2   2 excelVerifyCellStyle cell J10 fillPattern 25% gray 4 9   5 iteration wrapper Iteration 12   # Result Name Parameter Duration   1 excelStoreCellValue cell I12 property pattern 2   2 excelVerifyCellStyle cell J12 fillPattern 12.5% gray 4 8   6 iteration wrapper Iteration 14   # Result Name Parameter Duration   1 excelStoreCellValue cell I14 property pattern 2   2 excelVerifyCellStyle cell J14 fillPattern 6.25% gray 4 8   7 iteration wrapper Iteration 16   # Result Name Parameter Duration   1 excelStoreCellValue cell I16 property pattern 1   2 excelVerifyCellStyle cell J16 fillPattern horizontal stripe 4 8   8 iteration wrapper Iteration 18   # Result Name Parameter Duration   1 excelStoreCellValue cell I18 property pattern 2   2 excelVerifyCellStyle cell J18 fillPattern vertical stripe 5 8   9 iteration wrapper Iteration 20   # Result Name Parameter Duration   1 excelStoreCellValue cell I20 property pattern 2   2 excelVerifyCellStyle cell J20 fillPattern reverse diagonal stripe 4 9   10 iteration wrapper Iteration 22   # Result Name Parameter Duration   1 excelStoreCellValue cell I22 property pattern 2   2 excelVerifyCellStyle cell J22 fillPattern diagonal stripe 39 43   11 iteration wrapper Iteration 24   # Result Name Parameter Duration   1 excelStoreCellValue cell I24 property pattern 2   2 excelVerifyCellStyle cell J24 fillPattern diagonal crosshatch 4 9   12 iteration wrapper Iteration 26   # Result Name Parameter Duration   1 excelStoreCellValue cell I26 property pattern 2   2 excelVerifyCellStyle cell J26 fillPattern thick diagonal crosshatch 4 8   13 iteration wrapper Iteration 28   # Result Name Parameter Duration   1 excelStoreCellValue cell I28 property pattern 2   2 excelVerifyCellStyle cell J28 fillPattern thin horizontal stripe 4 8   14 iteration wrapper Iteration 30   # Result Name Parameter Duration   1 excelStoreCellValue cell I30 property pattern 2   2 excelVerifyCellStyle cell J30 fillPattern thin vertical stripe 4 9   15 iteration wrapper Iteration 32   # Result Name Parameter Duration   1 excelStoreCellValue cell I32 property pattern 2   2 excelVerifyCellStyle cell J32 fillPattern thin reverse diagonal stripe 5 9   16 iteration wrapper Iteration 34   # Result Name Parameter Duration   1 excelStoreCellValue cell I34 property pattern 2   2 excelVerifyCellStyle cell J34 fillPattern thin diagonal stripe 4 8   17 iteration wrapper Iteration 36   # Result Name Parameter Duration   1 excelStoreCellValue cell I36 property pattern 2   2 excelVerifyCellStyle cell J36 fillPattern thin horizontal crosshatch 4 8   18 iteration wrapper Iteration 38   # Result Name Parameter Duration   1 excelStoreCellValue cell I38 property pattern 2   2 excelVerifyCellStyle cell J38 fillPattern thin diagonal crosshatch 4 7	193
11		repeat Check Font Styles	counterName row endCount 14 startCount 4 # Result Name Parameter Duration   1 iteration wrapper Iteration 4   # Result Name Parameter Duration   1 excelStoreCellValue cell L4 property style 2   2 excelVerifyCellStyle cell L4 fontStyle normal 4 12   2 iteration wrapper Iteration 5   # Result Name Parameter Duration   1 excelStoreCellValue cell L5 property style 2   2 excelVerifyCellStyle cell L5 fontStyle bold 4 9   3 iteration wrapper Iteration 6   # Result Name Parameter Duration   1 excelStoreCellValue cell L6 property style 3   2 excelVerifyCellStyle cell L6 fontStyle italic 4 8   4 iteration wrapper Iteration 7   # Result Name Parameter Duration   1 excelStoreCellValue cell L7 property style 2   2 excelVerifyCellStyle cell L7 fontStyle underline 4 8   5 iteration wrapper Iteration 8   # Result Name Parameter Duration   1 excelStoreCellValue cell L8 property style 2   2 excelVerifyCellStyle cell L8 fontStyle underline-accounting 5 8   6 iteration wrapper Iteration 9   # Result Name Parameter Duration   1 excelStoreCellValue cell L9 property style 2   2 excelVerifyCellStyle cell L9 fontStyle underline-double 5 8   7 iteration wrapper Iteration 10   # Result Name Parameter Duration   1 excelStoreCellValue cell L10 property style 2   2 excelVerifyCellStyle cell L10 fontStyle underline-double-accounting 4 8   8 iteration wrapper Iteration 11   # Result Name Parameter Duration   1 excelStoreCellValue cell L11 property style 2   2 excelVerifyCellStyle cell L11 fontStyle subscript 5 8   9 iteration wrapper Iteration 12   # Result Name Parameter Duration   1 excelStoreCellValue cell L12 property style 3   2 excelVerifyCellStyle cell L12 fontStyle superscript 5 9   10 iteration wrapper Iteration 13   # Result Name Parameter Duration   1 excelStoreCellValue cell L13 property style 3   2 excelVerifyCellStyle cell L13 fontStyle strikethrough 6 12   11 iteration wrapper Iteration 14   # Result Name Parameter Duration   1 excelStoreCellValue cell L14 property style 3   2 excelVerifyCellStyle cell L14 fontStyle bold italic underline strikethrough 6 11	112
12		repeat Check Font Names	counterName row endCount 22 startCount 20 # Result Name Parameter Duration   1 iteration wrapper Iteration 20   # Result Name Parameter Duration   1 excelStoreCellValue cell L20 property name 3   2 excelVerifyCellStyle cell L20 fontName Arial 5 12   2 iteration wrapper Iteration 21   # Result Name Parameter Duration   1 excelStoreCellValue cell L21 property name 3   2 excelVerifyCellStyle cell L21 fontName Times New Roman 4 9   3 iteration wrapper Iteration 22   # Result Name Parameter Duration   1 excelStoreCellValue cell L22 property name 3   2 excelVerifyCellStyle cell L22 fontName Courier New 5 9	34
13		repeat Check Font Sizes	counterName row endCount 32 startCount 28 # Result Name Parameter Duration   1 iteration wrapper Iteration 28   # Result Name Parameter Duration   1 excelStoreCellValue cell L28 property size 3   2 excelVerifyCellStyle cell L28 fontSize 8 4 9   2 iteration wrapper Iteration 29   # Result Name Parameter Duration   1 excelStoreCellValue cell L29 property size 2   2 excelVerifyCellStyle cell L29 fontSize 10 4 8   3 iteration wrapper Iteration 30   # Result Name Parameter Duration   1 excelStoreCellValue cell L30 property size 2   2 excelVerifyCellStyle cell L30 fontSize 12 5 8   4 iteration wrapper Iteration 31   # Result Name Parameter Duration   1 excelStoreCellValue cell L31 property size 2   2 excelVerifyCellStyle cell L31 fontSize 16 4 9   5 iteration wrapper Iteration 32   # Result Name Parameter Duration   1 excelStoreCellValue cell L32 property size 10   2 excelVerifyCellStyle cell L32 fontSize 24 5 17	55
14		repeat Check Alignments	counterName row endCount 10 startCount 4 # Result Name Parameter Duration   1 iteration wrapper Iteration 4   # Result Name Parameter Duration   1 excelStoreCellValue cell M4 property pattern 2   2 excelVerifyCellStyle align general cell M4 4 9   2 iteration wrapper Iteration 5   # Result Name Parameter Duration   1 excelStoreCellValue cell M5 property pattern 2   2 excelVerifyCellStyle align left cell M5 4 9   3 iteration wrapper Iteration 6   # Result Name Parameter Duration   1 excelStoreCellValue cell M6 property pattern 2   2 excelVerifyCellStyle align center cell M6 4 9   4 iteration wrapper Iteration 7   # Result Name Parameter Duration   1 excelStoreCellValue cell M7 property pattern 2   2 excelVerifyCellStyle align right cell M7 4 9   5 iteration wrapper Iteration 8   # Result Name Parameter Duration   1 excelStoreCellValue cell M8 property pattern 2   2 excelVerifyCellStyle align fill cell M8 5 9   6 iteration wrapper Iteration 9   # Result Name Parameter Duration   1 excelStoreCellValue cell M9 property pattern 2   2 excelVerifyCellStyle align justify cell M9 5 8   7 iteration wrapper Iteration 10   # Result Name Parameter Duration   1 excelStoreCellValue cell M10 property pattern 2   2 excelVerifyCellStyle align center-selection cell M10 4 8	65
15		repeat Check Vertical Alignments	counterName row endCount 15 startCount 12 # Result Name Parameter Duration   1 iteration wrapper Iteration 12   # Result Name Parameter Duration   1 excelStoreCellValue cell M12 property pattern 3   2 excelVerifyCellStyle cell M12 valign top 4 9   2 iteration wrapper Iteration 13   # Result Name Parameter Duration   1 excelStoreCellValue cell M13 property pattern 2   2 excelVerifyCellStyle cell M13 valign center 4 9   3 iteration wrapper Iteration 14   # Result Name Parameter Duration   1 excelStoreCellValue cell M14 property pattern 2   2 excelVerifyCellStyle cell M14 valign bottom 4 9   4 iteration wrapper Iteration 15   # Result Name Parameter Duration   1 excelStoreCellValue cell M15 property pattern 2   2 excelVerifyCellStyle cell M15 valign justify 5 9	43
16		repeat Check Cell Type	counterName row endCount 24 startCount 20 # Result Name Parameter Duration   1 iteration wrapper Iteration 20   # Result Name Parameter Duration   1 excelStoreCellValue cell M20 property type 2   2 excelVerifyCellStyle cell N20 type string 4 9   2 iteration wrapper Iteration 21   # Result Name Parameter Duration   1 excelStoreCellValue cell M21 property type 2   2 excelVerifyCellStyle cell N21 type numeric 5 9   3 iteration wrapper Iteration 22   # Result Name Parameter Duration   1 excelStoreCellValue cell M22 property type 2   2 excelVerifyCellStyle cell N22 type blank 4 8   4 iteration wrapper Iteration 23   # Result Name Parameter Duration   1 excelStoreCellValue cell M23 property type 3   2 excelVerifyCellStyle cell N23 type boolean 4 9   5 iteration wrapper Iteration 24   # Result Name Parameter Duration   1 excelStoreCellValue cell M24 property type 2   2 excelVerifyCellStyle cell N24 type formula 5 9	49
17		repeat Check Cell Format	counterName row endCount 31 startCount 28 # Result Name Parameter Duration   1 iteration wrapper Iteration 28   # Result Name Parameter Duration   1 excelStoreCellValue cell M28 property format 2   2 excelVerifyCellStyle cell N28 format 0.00 67 70   2 iteration wrapper Iteration 29   # Result Name Parameter Duration   1 excelStoreCellValue cell M29 property format 2   2 excelVerifyCellStyle cell N29 format General 4 8   3 iteration wrapper Iteration 30   # Result Name Parameter Duration   1 excelStoreCellValue cell M30 property format 2   2 excelVerifyCellStyle cell N30 format 0.00% 4 7   4 iteration wrapper Iteration 31   # Result Name Parameter Duration   1 excelStoreCellValue cell M31 property format 2   2 excelVerifyCellStyle cell N31 format m/d/yy 5 8	99
18		excelVerifyCellStyle	cell O4 locked true	4
19		excelVerifyCellStyle	cell O5 locked false	4
20		excelVerifyCellStyle	cell O7 wrap true	4
21		excelVerifyCellStyle	cell O8 wrap false	4