update to 1.4.0

1 files changed, 299 insertions, 16 deletions

diff --git a/REFLECTION b/REFLECTION
index f4b9a13..5c7744f 100644
--- a/REFLECTION
+++ b/REFLECTION
@@ -1,4 +1,4 @@
-Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
+Extension [ <persistent> extension #107 xlswriter version 1.4.0 ] {
 
   - Functions {
     Function [ <internal:xlswriter> function xlswriter_get_version ] {
@@ -13,7 +13,7 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
     }
   }
 
-  - Classes [4] {
+  - Classes [5] {
     Class [ <internal:xlswriter> class Vtiful\Kernel\Exception extends Exception implements Throwable ] {
 
       - Constants [0] {
@@ -73,7 +73,7 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
 
     Class [ <internal:xlswriter> class Vtiful\Kernel\Excel ] {
 
-      - Constants [13] {
+      - Constants [53] {
         Constant [ public int SKIP_NONE ] { 0 }
         Constant [ public int SKIP_EMPTY_ROW ] { 1 }
         Constant [ public int SKIP_HIDDEN_ROW ] { 8 }
@@ -83,6 +83,46 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
         Constant [ public int GRIDLINES_SHOW_ALL ] { 3 }
         Constant [ public int GRIDLINES_SHOW_PRINT ] { 2 }
         Constant [ public int GRIDLINES_SHOW_SCREEN ] { 1 }
+        Constant [ public int PAPER_DEFAULT ] { 0 }
+        Constant [ public int PAPER_LETTER ] { 1 }
+        Constant [ public int PAPER_LETTER_SMALL ] { 2 }
+        Constant [ public int PAPER_TABLOID ] { 3 }
+        Constant [ public int PAPER_LEDGER ] { 4 }
+        Constant [ public int PAPER_LEGAL ] { 5 }
+        Constant [ public int PAPER_STATEMENT ] { 6 }
+        Constant [ public int PAPER_EXECUTIVE ] { 7 }
+        Constant [ public int PAPER_A3 ] { 8 }
+        Constant [ public int PAPER_A4 ] { 9 }
+        Constant [ public int PAPER_A4_SMALL ] { 10 }
+        Constant [ public int PAPER_A5 ] { 11 }
+        Constant [ public int PAPER_B4 ] { 12 }
+        Constant [ public int PAPER_B5 ] { 13 }
+        Constant [ public int PAPER_FOLIO ] { 14 }
+        Constant [ public int PAPER_QUARTO ] { 15 }
+        Constant [ public int PAPER_NOTE ] { 18 }
+        Constant [ public int PAPER_ENVELOPE_9 ] { 19 }
+        Constant [ public int PAPER_ENVELOPE_10 ] { 20 }
+        Constant [ public int PAPER_ENVELOPE_11 ] { 21 }
+        Constant [ public int PAPER_ENVELOPE_12 ] { 22 }
+        Constant [ public int PAPER_ENVELOPE_14 ] { 23 }
+        Constant [ public int PAPER_C_SIZE_SHEET ] { 24 }
+        Constant [ public int PAPER_D_SIZE_SHEET ] { 25 }
+        Constant [ public int PAPER_E_SIZE_SHEET ] { 26 }
+        Constant [ public int PAPER_ENVELOPE_DL ] { 27 }
+        Constant [ public int PAPER_ENVELOPE_C3 ] { 28 }
+        Constant [ public int PAPER_ENVELOPE_C4 ] { 29 }
+        Constant [ public int PAPER_ENVELOPE_C5 ] { 30 }
+        Constant [ public int PAPER_ENVELOPE_C6 ] { 31 }
+        Constant [ public int PAPER_ENVELOPE_C65 ] { 32 }
+        Constant [ public int PAPER_ENVELOPE_B4 ] { 33 }
+        Constant [ public int PAPER_ENVELOPE_B5 ] { 34 }
+        Constant [ public int PAPER_ENVELOPE_B6 ] { 35 }
+        Constant [ public int PAPER_ENVELOPE_1 ] { 36 }
+        Constant [ public int PAPER_MONARCH ] { 37 }
+        Constant [ public int PAPER_ENVELOPE_2 ] { 38 }
+        Constant [ public int PAPER_FANFOLD ] { 39 }
+        Constant [ public int PAPER_GERMAN_STD_FANFOLD ] { 40 }
+        Constant [ public int PAPER_GERMAN_LEGAL_FANFOLD ] { 41 }
         Constant [ public int TYPE_INT ] { 2 }
         Constant [ public int TYPE_DOUBLE ] { 4 }
         Constant [ public int TYPE_STRING ] { 1 }
@@ -121,7 +161,7 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
         Property [ <default> private $read_row_type ]
       }
 
-      - Methods [42] {
+      - Methods [47] {
         Method [ <internal:xlswriter, ctor> public method __construct ] {
 
           - Parameters [1] {
@@ -129,6 +169,12 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
           }
         }
 
+        Method [ <internal:xlswriter> public method close ] {
+
+          - Parameters [0] {
+          }
+        }
+
         Method [ <internal:xlswriter> public method fileName ] {
 
           - Parameters [2] {
@@ -144,6 +190,13 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
           }
         }
 
+        Method [ <internal:xlswriter> public method existSheet ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $sheet_name ]
+          }
+        }
+
         Method [ <internal:xlswriter> public method checkoutSheet ] {
 
           - Parameters [1] {
@@ -328,6 +381,14 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
           }
         }
 
+        Method [ <internal:xlswriter> public method validation ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $range ]
+            Parameter #1 [ <required> $validation_resource ]
+          }
+        }
+
         Method [ <internal:xlswriter> public method zoom ] {
 
           - Parameters [1] {
@@ -342,13 +403,30 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
           }
         }
 
-        Method [ <internal:xlswriter> public method setPrintedPortrait ] {
+        Method [ <internal:xlswriter> public method setPaper ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $paper ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method setMargins ] {
+
+          - Parameters [4] {
+            Parameter #0 [ <required> $left ]
+            Parameter #1 [ <required> $right ]
+            Parameter #2 [ <required> $top ]
+            Parameter #3 [ <required> $bottom ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method setPortrait ] {
 
           - Parameters [0] {
           }
         }
 
-        Method [ <internal:xlswriter> public method setPrintedLandscape ] {
+        Method [ <internal:xlswriter> public method setLandscape ] {
 
           - Parameters [0] {
           }
@@ -636,7 +714,7 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
 
     Class [ <internal:xlswriter> class Vtiful\Kernel\Chart ] {
 
-      - Constants [27] {
+      - Constants [29] {
         Constant [ public int CHART_BAR ] { 4 }
         Constant [ public int CHART_BAR_STACKED ] { 5 }
         Constant [ public int CHART_BAR_STACKED_PERCENT ] { 6 }
@@ -648,15 +726,15 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
         Constant [ public int CHART_COLUMN_STACKED ] { 8 }
         Constant [ public int CHART_COLUMN_STACKED_PERCENT ] { 9 }
         Constant [ public int CHART_DOUGHNUT ] { 10 }
-        Constant [ public int CHART_PIE ] { 12 }
-        Constant [ public int CHART_SCATTER ] { 13 }
-        Constant [ public int CHART_SCATTER_STRAIGHT ] { 14 }
-        Constant [ public int CHART_SCATTER_STRAIGHT_WITH_MARKERS ] { 15 }
-        Constant [ public int CHART_SCATTER_SMOOTH ] { 16 }
-        Constant [ public int CHART_SCATTER_SMOOTH_WITH_MARKERS ] { 17 }
-        Constant [ public int CHART_RADAR ] { 18 }
-        Constant [ public int CHART_RADAR_WITH_MARKERS ] { 19 }
-        Constant [ public int CHART_RADAR_FILLED ] { 20 }
+        Constant [ public int CHART_PIE ] { 14 }
+        Constant [ public int CHART_SCATTER ] { 15 }
+        Constant [ public int CHART_SCATTER_STRAIGHT ] { 16 }
+        Constant [ public int CHART_SCATTER_STRAIGHT_WITH_MARKERS ] { 17 }
+        Constant [ public int CHART_SCATTER_SMOOTH ] { 18 }
+        Constant [ public int CHART_SCATTER_SMOOTH_WITH_MARKERS ] { 19 }
+        Constant [ public int CHART_RADAR ] { 20 }
+        Constant [ public int CHART_RADAR_WITH_MARKERS ] { 21 }
+        Constant [ public int CHART_RADAR_FILLED ] { 22 }
         Constant [ public int CHART_LEGEND_NONE ] { 0 }
         Constant [ public int CHART_LEGEND_RIGHT ] { 1 }
         Constant [ public int CHART_LEGEND_LEFT ] { 2 }
@@ -664,6 +742,8 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
         Constant [ public int CHART_LEGEND_BOTTOM ] { 4 }
         Constant [ public int CHART_LEGEND_OVERLAY_RIGHT ] { 6 }
         Constant [ public int CHART_LEGEND_OVERLAY_LEFT ] { 7 }
+        Constant [ public int CHART_LINE_STACKED ] { 12 }
+        Constant [ public int CHART_LINE_STACKED_PERCENT ] { 13 }
       }
 
       - Static properties [0] {
@@ -741,6 +821,209 @@ Extension [ <persistent> extension #106 xlswriter version 1.3.7 ] {
         }
       }
     }
+
+    Class [ <internal:xlswriter> class Vtiful\Kernel\Validation ] {
+
+      - Constants [27] {
+        Constant [ public int TYPE_INTEGER ] { 1 }
+        Constant [ public int TYPE_INTEGER_FORMULA ] { 2 }
+        Constant [ public int TYPE_DECIMAL ] { 3 }
+        Constant [ public int TYPE_DECIMAL_FORMULA ] { 4 }
+        Constant [ public int TYPE_LIST ] { 5 }
+        Constant [ public int TYPE_LIST_FORMULA ] { 6 }
+        Constant [ public int TYPE_DATE ] { 7 }
+        Constant [ public int TYPE_DATE_FORMULA ] { 8 }
+        Constant [ public int TYPE_DATE_NUMBER ] { 9 }
+        Constant [ public int TYPE_TIME ] { 10 }
+        Constant [ public int TYPE_TIME_FORMULA ] { 11 }
+        Constant [ public int TYPE_TIME_NUMBER ] { 12 }
+        Constant [ public int TYPE_LENGTH ] { 13 }
+        Constant [ public int TYPE_LENGTH_FORMULA ] { 14 }
+        Constant [ public int TYPE_CUSTOM_FORMULA ] { 15 }
+        Constant [ public int TYPE_ANY ] { 16 }
+        Constant [ public int CRITERIA_BETWEEN ] { 1 }
+        Constant [ public int CRITERIA_NOT_BETWEEN ] { 2 }
+        Constant [ public int CRITERIA_EQUAL_TO ] { 3 }
+        Constant [ public int CRITERIA_NOT_EQUAL_TO ] { 4 }
+        Constant [ public int CRITERIA_GREATER_THAN ] { 5 }
+        Constant [ public int CRITERIA_LESS_THAN ] { 6 }
+        Constant [ public int CRITERIA_GREATER_THAN_OR_EQUAL_TO ] { 7 }
+        Constant [ public int CRITERIA_LESS_THAN_OR_EQUAL_TO ] { 8 }
+        Constant [ public int ERROR_TYPE_STOP ] { 0 }
+        Constant [ public int ERROR_TYPE_WARNING ] { 1 }
+        Constant [ public int ERROR_TYPE_INFORMATION ] { 2 }
+      }
+
+      - Static properties [0] {
+      }
+
+      - Static methods [0] {
+      }
+
+      - Properties [0] {
+      }
+
+      - Methods [23] {
+        Method [ <internal:xlswriter, ctor> public method __construct ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method validationType ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $type ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method criteriaType ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $type ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method ignoreBlank ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $ignore_blank ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method showInput ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $show_input ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method showError ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $show_error ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method errorType ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $error_type ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method dropdown ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $dropdown ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method valueNumber ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value_number ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method valueFormula ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value_formula ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method valueList ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value_list ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method valueDatetime ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $timestamp ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method minimumNumber ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $minimum_number ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method minimumFormula ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $minimum_formula ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method minimumDatetime ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $timestamp ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method maximumNumber ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $maximum_number ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method maximumFormula ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $maximum_formula ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method maximumDatetime ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $maximum_datetime ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method inputTitle ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $input_title ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method inputMessage ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $input_message ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method errorTitle ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $error_titile ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method errorMessage ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $error_message ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method toResource ] {
+
+          - Parameters [0] {
+          }
+        }
+      }
+    }
   }
 }