update to 2.0.0

open https://github.com/viest/php-ext-xlswriter/issues/565 test failures with PHP 7.0

3 files changed, 759 insertions, 14 deletions

diff --git a/PHPINFO b/PHPINFO
index fa75d77..a499e58 100644
--- a/PHPINFO
+++ b/PHPINFO
@@ -2,6 +2,6 @@
 xlswriter
 
 xlswriter support => enabled
-Version => 1.5.8
-bundled libxlsxwriter version => 1.1.3
-bundled libxlsxio version => 0.2.27
+Version => 2.0.0
+bundled libxlsxwriter version => 1.1.6
+bundled libxlsxreader version => self-maintained
diff --git a/REFLECTION b/REFLECTION
index c3c7e7b..c09feae 100644
--- a/REFLECTION
+++ b/REFLECTION
@@ -1,4 +1,4 @@
-Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
+Extension [ <persistent> extension #138 xlswriter version 2.0.0 ] {
 
   - Functions {
     Function [ <internal:xlswriter> function xlswriter_get_version ] {
@@ -13,7 +13,7 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
     }
   }
 
-  - Classes [6] {
+  - Classes [8] {
     Class [ <internal:xlswriter> class Vtiful\Kernel\Exception extends Exception implements Throwable, Stringable ] {
 
       - Constants [0] {
@@ -108,12 +108,14 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
 
     Class [ <internal:xlswriter> class Vtiful\Kernel\Excel ] {
 
-      - Constants [53] {
+      - Constants [58] {
         Constant [ public int SKIP_NONE ] { 0 }
         Constant [ public int SKIP_EMPTY_ROW ] { 1 }
         Constant [ public int SKIP_HIDDEN_ROW ] { 8 }
         Constant [ public int SKIP_EMPTY_CELLS ] { 2 }
         Constant [ public int SKIP_EMPTY_VALUE ] { 256 }
+        Constant [ public int SKIP_MERGED_FOLLOW ] { 16 }
+        Constant [ public int FORMULA_VERBOSE ] { 32 }
         Constant [ public int GRIDLINES_HIDE_ALL ] { 0 }
         Constant [ public int GRIDLINES_SHOW_ALL ] { 3 }
         Constant [ public int GRIDLINES_SHOW_PRINT ] { 2 }
@@ -158,6 +160,9 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
         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 COMMENT_DISPLAY_DEFAULT ] { 0 }
+        Constant [ public int COMMENT_DISPLAY_HIDDEN ] { 1 }
+        Constant [ public int COMMENT_DISPLAY_VISIBLE ] { 2 }
         Constant [ public int TYPE_INT ] { 2 }
         Constant [ public int TYPE_DOUBLE ] { 4 }
         Constant [ public int TYPE_STRING ] { 1 }
@@ -167,7 +172,7 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
       - Static properties [0] {
       }
 
-      - Static methods [3] {
+      - Static methods [4] {
         Method [ <internal:xlswriter> static public method columnIndexFromString ] {
 
           - Parameters [1] {
@@ -188,6 +193,13 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
             Parameter #0 [ <required> $index ]
           }
         }
+
+        Method [ <internal:xlswriter> static public method getFormulaAst ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $formula ]
+          }
+        }
       }
 
       - Properties [3] {
@@ -196,7 +208,7 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
         Property [ private $read_row_type = NULL ]
       }
 
-      - Methods [52] {
+      - Methods [90] {
         Method [ <internal:xlswriter, ctor> public method __construct ] {
 
           - Parameters [1] {
@@ -525,6 +537,155 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
           }
         }
 
+        Method [ <internal:xlswriter> public method insertCommentOpt ] {
+
+          - Parameters [4] {
+            Parameter #0 [ <required> $row ]
+            Parameter #1 [ <required> $column ]
+            Parameter #2 [ <required> $text ]
+            Parameter #3 [ <required> $options ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method insertImageBuffer ] {
+
+          - Parameters [4] {
+            Parameter #0 [ <required> $row ]
+            Parameter #1 [ <required> $column ]
+            Parameter #2 [ <required> $bytes ]
+            Parameter #3 [ <optional> $options = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method setHeader ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $value ]
+            Parameter #1 [ <optional> $options = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method setFooter ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $value ]
+            Parameter #1 [ <optional> $options = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method repeatRows ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $range ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method repeatColumns ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $range ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method printArea ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $range ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method horizontalPageBreaks ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $breaks ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method verticalPageBreaks ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $breaks ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method fitToPages ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $width ]
+            Parameter #1 [ <required> $height ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method setTabColor ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $rgb ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method setProperties ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $props ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method setCustomProperty ] {
+
+          - Parameters [3] {
+            Parameter #0 [ <required> $name ]
+            Parameter #1 [ <required> $value ]
+            Parameter #2 [ <optional> $type = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method defineName ] {
+
+          - Parameters [3] {
+            Parameter #0 [ <required> $name ]
+            Parameter #1 [ <required> $formula ]
+            Parameter #2 [ <optional> $scopeSheet = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method setBackgroundImage ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $path ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method setBackgroundImageBuffer ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $bytes ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method conditionalFormatCell ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $range ]
+            Parameter #1 [ <required> $conditional_format ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method conditionalFormatRange ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $range ]
+            Parameter #1 [ <required> $conditional_format ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method addTable ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $range ]
+            Parameter #1 [ <optional> $options = <default> ]
+          }
+        }
+
         Method [ <internal:xlswriter> public method openFile ] {
 
           - Parameters [1] {
@@ -567,6 +728,108 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
           }
         }
 
+        Method [ <internal:xlswriter> public method sheetListWithMeta ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getMergedCells ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getHyperlinks ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getSheetProtection ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getRowOptions ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $row ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getColumnOptions ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $colA1 ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getDefaultRowHeight ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getDefaultColumnWidth ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getDefinedNames ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getDataValidations ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getAutoFilter ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getPageSetup ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method nextRowRich ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getConditionalFormats ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method iterateComments ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $callable ]
+            Parameter #1 [ <optional> $sheet = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method iterateCharts ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $callable ]
+            Parameter #1 [ <optional> $sheet = <default> ]
+          }
+        }
+
         Method [ <internal:xlswriter> public method setType ] {
 
           - Parameters [1] {
@@ -601,6 +864,27 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
           }
         }
 
+        Method [ <internal:xlswriter> public method nextRowWithFormula ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method getStyleFormat ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $style_id ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method iterateImages ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $callback ]
+            Parameter #1 [ <optional> $sheet_name = <default> ]
+          }
+        }
+
         Method [ <internal:xlswriter> public method nextCellCallback ] {
 
           - Parameters [2] {
@@ -690,7 +974,7 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
       - Properties [0] {
       }
 
-      - Methods [19] {
+      - Methods [22] {
         Method [ <internal:xlswriter, ctor> public method __construct ] {
 
           - Parameters [1] {
@@ -804,6 +1088,18 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
           }
         }
 
+        Method [ <internal:xlswriter> public method locked ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method hidden ] {
+
+          - Parameters [0] {
+          }
+        }
+
         Method [ <internal:xlswriter> public method rotation ] {
 
           - Parameters [1] {
@@ -811,6 +1107,13 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
           }
         }
 
+        Method [ <internal:xlswriter> public method indent ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $level ]
+          }
+        }
+
         Method [ <internal:xlswriter> public method toResource ] {
 
           - Parameters [0] {
@@ -1164,6 +1467,438 @@ Extension [ <persistent> extension #108 xlswriter version 1.5.8 ] {
         }
       }
     }
+
+    Class [ <internal:xlswriter> class Vtiful\Kernel\ConditionalFormat ] {
+
+      - Constants [71] {
+        Constant [ public int TYPE_CELL ] { 1 }
+        Constant [ public int TYPE_TEXT ] { 2 }
+        Constant [ public int TYPE_TIME_PERIOD ] { 3 }
+        Constant [ public int TYPE_AVERAGE ] { 4 }
+        Constant [ public int TYPE_DUPLICATE ] { 5 }
+        Constant [ public int TYPE_UNIQUE ] { 6 }
+        Constant [ public int TYPE_TOP ] { 7 }
+        Constant [ public int TYPE_BOTTOM ] { 8 }
+        Constant [ public int TYPE_BLANKS ] { 9 }
+        Constant [ public int TYPE_NO_BLANKS ] { 10 }
+        Constant [ public int TYPE_ERRORS ] { 11 }
+        Constant [ public int TYPE_NO_ERRORS ] { 12 }
+        Constant [ public int TYPE_FORMULA ] { 13 }
+        Constant [ public int TYPE_2_COLOR_SCALE ] { 14 }
+        Constant [ public int TYPE_3_COLOR_SCALE ] { 15 }
+        Constant [ public int TYPE_DATA_BAR ] { 16 }
+        Constant [ public int TYPE_ICON_SETS ] { 17 }
+        Constant [ public int CRITERIA_EQUAL_TO ] { 1 }
+        Constant [ public int CRITERIA_NOT_EQUAL_TO ] { 2 }
+        Constant [ public int CRITERIA_GREATER_THAN ] { 3 }
+        Constant [ public int CRITERIA_LESS_THAN ] { 4 }
+        Constant [ public int CRITERIA_GREATER_THAN_OR_EQUAL_TO ] { 5 }
+        Constant [ public int CRITERIA_LESS_THAN_OR_EQUAL_TO ] { 6 }
+        Constant [ public int CRITERIA_BETWEEN ] { 7 }
+        Constant [ public int CRITERIA_NOT_BETWEEN ] { 8 }
+        Constant [ public int CRITERIA_TEXT_CONTAINING ] { 9 }
+        Constant [ public int CRITERIA_TEXT_NOT_CONTAINING ] { 10 }
+        Constant [ public int CRITERIA_TEXT_BEGINS_WITH ] { 11 }
+        Constant [ public int CRITERIA_TEXT_ENDS_WITH ] { 12 }
+        Constant [ public int CRITERIA_TIME_PERIOD_YESTERDAY ] { 13 }
+        Constant [ public int CRITERIA_TIME_PERIOD_TODAY ] { 14 }
+        Constant [ public int CRITERIA_TIME_PERIOD_TOMORROW ] { 15 }
+        Constant [ public int CRITERIA_TIME_PERIOD_LAST_7_DAYS ] { 16 }
+        Constant [ public int CRITERIA_TIME_PERIOD_LAST_WEEK ] { 17 }
+        Constant [ public int CRITERIA_TIME_PERIOD_THIS_WEEK ] { 18 }
+        Constant [ public int CRITERIA_TIME_PERIOD_NEXT_WEEK ] { 19 }
+        Constant [ public int CRITERIA_TIME_PERIOD_LAST_MONTH ] { 20 }
+        Constant [ public int CRITERIA_TIME_PERIOD_THIS_MONTH ] { 21 }
+        Constant [ public int CRITERIA_TIME_PERIOD_NEXT_MONTH ] { 22 }
+        Constant [ public int CRITERIA_AVERAGE_ABOVE ] { 23 }
+        Constant [ public int CRITERIA_AVERAGE_BELOW ] { 24 }
+        Constant [ public int CRITERIA_TOP_OR_BOTTOM_PERCENT ] { 33 }
+        Constant [ public int RULE_MINIMUM ] { 1 }
+        Constant [ public int RULE_NUMBER ] { 2 }
+        Constant [ public int RULE_PERCENT ] { 3 }
+        Constant [ public int RULE_PERCENTILE ] { 4 }
+        Constant [ public int RULE_FORMULA ] { 5 }
+        Constant [ public int RULE_MAXIMUM ] { 6 }
+        Constant [ public int BAR_DIRECTION_CONTEXT ] { 0 }
+        Constant [ public int BAR_DIRECTION_LEFT_TO_RIGHT ] { 2 }
+        Constant [ public int BAR_DIRECTION_RIGHT_TO_LEFT ] { 1 }
+        Constant [ public int BAR_AXIS_AUTOMATIC ] { 0 }
+        Constant [ public int BAR_AXIS_MIDPOINT ] { 1 }
+        Constant [ public int BAR_AXIS_NONE ] { 2 }
+        Constant [ public int ICONS_3_ARROWS_COLORED ] { 0 }
+        Constant [ public int ICONS_3_ARROWS_GRAY ] { 1 }
+        Constant [ public int ICONS_3_FLAGS ] { 2 }
+        Constant [ public int ICONS_3_TRAFFIC_LIGHTS_UNRIMMED ] { 3 }
+        Constant [ public int ICONS_3_TRAFFIC_LIGHTS_RIMMED ] { 4 }
+        Constant [ public int ICONS_3_SIGNS ] { 5 }
+        Constant [ public int ICONS_3_SYMBOLS_CIRCLED ] { 6 }
+        Constant [ public int ICONS_3_SYMBOLS_UNCIRCLED ] { 7 }
+        Constant [ public int ICONS_4_ARROWS_COLORED ] { 8 }
+        Constant [ public int ICONS_4_ARROWS_GRAY ] { 9 }
+        Constant [ public int ICONS_4_RED_TO_BLACK ] { 10 }
+        Constant [ public int ICONS_4_RATINGS ] { 11 }
+        Constant [ public int ICONS_4_TRAFFIC_LIGHTS ] { 12 }
+        Constant [ public int ICONS_5_ARROWS_COLORED ] { 13 }
+        Constant [ public int ICONS_5_ARROWS_GRAY ] { 14 }
+        Constant [ public int ICONS_5_RATINGS ] { 15 }
+        Constant [ public int ICONS_5_QUARTERS ] { 16 }
+      }
+
+      - Static properties [0] {
+      }
+
+      - Static methods [0] {
+      }
+
+      - Properties [0] {
+      }
+
+      - Methods [34] {
+        Method [ <internal:xlswriter, ctor> public method __construct ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method type ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method criteria ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method value ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method valueString ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method minimum ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method minimumString ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method minimumRule ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method minimumColor ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method middle ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method middleString ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method middleRule ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method middleColor ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method maximum ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method maximumString ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method maximumRule ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method maximumColor ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method format ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $format ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method barColor ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method barOnly ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method dataBar2010 ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method barSolid ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method barNegativeColor ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method barBorderColor ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method barNegativeBorderColor ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method barNoBorder ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method barDirection ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method barAxisPosition ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method barAxisColor ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method iconStyle ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method reverseIcons ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method iconsOnly ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method multiRange ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method stopIfTrue ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+      }
+    }
+
+    Class [ <internal:xlswriter> class Vtiful\Kernel\Table ] {
+
+      - Constants [13] {
+        Constant [ public int STYLE_TYPE_DEFAULT ] { 0 }
+        Constant [ public int STYLE_TYPE_LIGHT ] { 1 }
+        Constant [ public int STYLE_TYPE_MEDIUM ] { 2 }
+        Constant [ public int STYLE_TYPE_DARK ] { 3 }
+        Constant [ public int FUNCTION_NONE ] { 0 }
+        Constant [ public int FUNCTION_AVERAGE ] { 101 }
+        Constant [ public int FUNCTION_COUNT_NUMS ] { 102 }
+        Constant [ public int FUNCTION_COUNT ] { 103 }
+        Constant [ public int FUNCTION_MAX ] { 104 }
+        Constant [ public int FUNCTION_MIN ] { 105 }
+        Constant [ public int FUNCTION_STD_DEV ] { 107 }
+        Constant [ public int FUNCTION_SUM ] { 109 }
+        Constant [ public int FUNCTION_VAR ] { 110 }
+      }
+
+      - Static properties [0] {
+      }
+
+      - Static methods [0] {
+      }
+
+      - Properties [0] {
+      }
+
+      - Methods [11] {
+        Method [ <internal:xlswriter, ctor> public method __construct ] {
+
+          - Parameters [0] {
+          }
+        }
+
+        Method [ <internal:xlswriter> public method name ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $value ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method noHeaderRow ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method noAutofilter ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method noBandedRows ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method bandedColumns ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method firstColumn ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method lastColumn ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method totalRow ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <optional> $on = <default> ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method style ] {
+
+          - Parameters [2] {
+            Parameter #0 [ <required> $type ]
+            Parameter #1 [ <required> $number ]
+          }
+        }
+
+        Method [ <internal:xlswriter> public method columns ] {
+
+          - Parameters [1] {
+            Parameter #0 [ <required> $columns ]
+          }
+        }
+      }
+    }
   }
 }
 
diff --git a/php-pecl-xlswriter.spec b/php-pecl-xlswriter.spec
index 4e5520c..07c3b55 100644
--- a/php-pecl-xlswriter.spec
+++ b/php-pecl-xlswriter.spec
@@ -27,8 +27,8 @@
 Name:           %{?scl_prefix}php-pecl-%{pecl_name}
 Summary:        An efficient and fast xlsx file extension
 License:        BSD-2-Clause
-Version:        1.5.8
-Release:        2%{?dist}
+Version:        2.0.0
+Release:        1%{?dist}
 %forgemeta
 URL:            %{forgeurl}
 # use makesrc.sh to create a recursive snapshot
@@ -42,9 +42,9 @@ BuildRequires:  %{?scl_prefix}php-devel >= 7.0
 Requires:       %{?scl_prefix}php(zend-abi) = %{php_zend_api}
 Requires:       %{?scl_prefix}php(api) = %{php_core_api}
 # see library/libxlsxwriter/include/xlsxwriter.h
-Provides:       bundled(libxlsxwriter) = 1.1.3
-# see library/libxlsxio/include/xlsxio_version.h
-Provides:       bundled(libxlsxio) = 0.2.27
+Provides:       bundled(libxlsxwriter) = 1.1.6
+# self-maintained
+Provides:       bundled(libxlsreader)
 
 # Extension
 Provides:       %{?scl_prefix}php-%{pecl_name}                 = %{version}
@@ -156,6 +156,12 @@ OPT="-q -P --show-diff"
 %if "%{php_version}" > "7.4"
 OPT="$OPT %{?_smp_mflags}"
 %endif
+%if "%{php_version}" < "7.1"
+# See https://github.com/viest/php-ext-xlswriter/issues/565
+rm tests/conditional_format.phpt
+rm tests/examples_smoke.phpt
+rm tests/open_xlsx_next_row_with_formula.phpt
+%endif
 
 : Minimal load test for NTS extension
 %{__php} --no-php-ini \
@@ -200,6 +206,10 @@ cd ..
 
 
 %changelog
+* Mon May 18 2026 Remi Collet <remi@remirepo.net> - 2.0.0-1
+- update to 2.0.0
+- open https://github.com/viest/php-ext-xlswriter/issues/565 test failures with PHP 7.0
+
 * Thu Apr 23 2026 Remi Collet <remi@remirepo.net> - 1.5.8-2
 - drop pear/pecl dependency
 - sources from github