Update some tests with new methods

Remove CreatePivotTable overload that doesn't provide a name

Fix XLRangeBase.CreatePivotTable destination sheet - must equal targetCell's

Simplify adding table to pivot table

Rename IXLPivotTables.AddNew to Add and make the old methods obsolete

Remove IXLPivotTables.Add() - wasn't used

Add method AddNew to add pivot table directly from table

Remove ArgumentException from XLCell.Value ...

Add possible ArgumentException when changing XLCell.DataType

Simplify XLCell.cs()

Load file's cached value into XLCell.CachedValue - need to some refactoring of the internal parsing in XLCell

Use autoproperty for XLCell.Worksheet

Cache parsed values for value cells too

Add test for changing data type (Thanks @prankaty )

Update ISSUE_TEMPLATE.md

Test saving cell value with leading quotation mark and formula correctly

Simplify pivot table example

Make pivot table name case insensitive and validate name after change

Extract and consolidate ValidateName

Remove _rangeList and implement auto-property for XLNamedRange

Extract new method ValidateName

Add more .Contains methods and clean up internal dictionaries with StringComparer.OrdinalIgnoreCase ...

Add IXLPivotTable.Worksheet property
Add XLPivotTable.Name validation (copied from XLTable's Name validation)

CodeMaid reorganise and clean XLPivotTables

CodeMaid organise and clean IXLWorksheets

Add test for persisting cached value under different culture.

Change call .ToString() to .ToInvariantString() ...

Change call .ToString() to .ToInvariantString() when save workbook

Update test framework

Add request to test with latest development build first.

Simplify and rename RebaseShapeIds to RebaseNonVisualDrawingPropertiesIds

Update CI links

Fix determining the first column of used range