test/perl_output/data_validate.xls in writeexcel-0.1.0 vs test/perl_output/data_validate.xls in writeexcel-0.3.0
- old
+ new
@@ -1,6 +1,7 @@
-ࡱ >
A B = \508 X " 1 Arial1 Arial1 Arial1 Arial1 Tahoma1 Arial1 Arial + ) , * x@ @ + 8 3f f f f ̙ ̙ 3f 3 f ff 3f 3f 3 33 3 3f 33 333 Sheet1 \ ; Some examples of data validation in Spreadsheet::WriteExcel Enter values in this column Sample Data Integers List data open high close Formula! Enter an integer between 1 and 10E Enter an integer that is not between 1 and 10 (using cell references) Enter an integer greater than 0 Enter an integer less than 10# Enter a decimal between 0.1 and 0.5$ Select a value from a drop down list9 Select a value from a drop down list (using a cell range), Enter a date between 1/1/2008 and 12/12/2008# Enter a time between 6:00 and 12:00' Enter a string longer than 3 characters: Enter a value if the following is true "=AND(F5=50,G5=60)"+ Displays a message when you select the cellC Display a custom error message when integer isn't between 1 and 100I Display a custom information message when integer isn't between 1 and 100 P (
+ࡱ >
A B = \508 X " 1 Arial1 Arial1 Arial1 Arial1 Arial1 Arial1 Arial1 Arial1 Tahoma1 Arial1 Arial + ) , *
+ x@ @ + 8 3f f f f ̙ ̙ 3f 3 f ff 3f 3f 3 33 3 3f 33 333 Sheet1 O . Some examples of data validation in WriteExcel Enter values in this column Sample Data Integers List data open high close Formula! Enter an integer between 1 and 10E Enter an integer that is not between 1 and 10 (using cell references) Enter an integer greater than 0 Enter an integer less than 10# Enter a decimal between 0.1 and 0.5$ Select a value from a drop down list9 Select a value from a drop down list (using a cell range), Enter a date between 1/1/2008 and 12/12/2008# Enter a time between 6:00 and 12:00' Enter a string longer than 3 characters: Enter a value if the following is true "=AND(F5=50,G5=60)"+ Displays a message when you select the cellC Display a custom error message when integer isn't between 1 and 100I Display a custom information message when integer isn't between 1 and 100 >
A * + % & ?' ?( ?) ? " d XX ? ? U } @ } } @
? $@
@@ -27,6 +28,6 @@
> @ ,
0 D D ) L ) \
8 ? ?
8 open high close / % , r 8 ? ? ) L < D 2 D < B$ L Enter an integer: between 1 and 100 d Enter an integer: Input value is not valid! between 1 and 100) It should be an integer between 1 and 100 d ! Enter an integer: Input value is not valid! between 1 and 100) It should be an integer between 1 and 100 d
- R o o t E n t r y W o r k b o o k
+ R o o t E n t r y W o r k b o o k
\ No newline at end of file