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

Failing test added

Sorted using satements

Added unit test to verify SpreadsheetDocumentType based on SaveAs file extensions.

Fixed GetSpreadsheetDocumentType method to get Template and MacroEnabledTemplate types.

IXLRangeIndex defined ...

Range indexing using QuadTree implemented
Replace searches of intersected ranges with the optimized version

Add and implement XLNamedRangeScope

Park files that don't load correctly yet. We have to tackle them one by one

Remove 2 files with vulnerabilities. They're not supposed to be loaded

Add and test LO files

Refactor TestHelper and ResourceFileExtractor

CodeMaid clean ResourceFileExtractor.cs

Shift the try/catch deeper into the formula parsing. ...

Add parameter check in XLHelper.GetColumnLetterFromNumber

Catch the exceptions when the formula is not valid (i.e. shifted too far).

Ranges handling redesign (proof-of-concept) (#766) ...

* Immutable range addresses implementation start

* Immutable range addresses implementation continue

* Range addresses made immutable

* Helper methods for range addresses introduced

* XLRangeRepository introduced

* Range factory introduced

* XLRow and XLColumn constructor calls replaced with factory methods.

* Range shifting with no callback actions implemented

* Ranges shifting improved

* Shifting of worksheet data called explicitly. Shifting of CF ranges fixed

* MergedRanges copying removed as it's performed with rows copying. Minor changes in reference file

* Test fixed (arguments reordered)

* Sharing implemented for tables

* Addresses comparison fixed. Formula shifting fixed

* Setters for FixedRow and FixedColumn removed

* Clean-up

* Flaky test fixed.

* Merge conflicts solved

* Make most of the classes non-disposable

* Clean up

* Merged ranges shifting fixed

* Remove redundant variables, clean up usings.

* Restore usings needed for Release configuration. Remove unused constructor (has been replaced with a method in XLWorksheet).

Add support for named ranges referring to expressions or to multiple ranges

Change XLTable.Theme default value to TableStyleMedium2 to align with Excel

Use pattern matching for ToInvariantString

Make extension methods internal. ...

Replace with morelinq in Examples project

Сonsolidation of conditional formats and data validation rules (#761) ...

* Failing test added

* Multiple ranges for conditional format

* Clearing ranges of CF fixed.

* XLConditionalFormat.Range implemented via Ranges.

* Tests for CF copying added

* XLRangeConsolidationEngine implemented

* Conditional formats consolidation re-implemented.

* Data validaton rules consolidation implemented

* Tests fixed

* CF formula adjustment implemented

* Fix clearing formats not covered by cleared range

* Reference files updated (uncertain about changes). Adjusting CF formulas fixed

* Fix multi-range conditional formats loading. Fix CF consolidation to prevent reordering of rules.

* Fix formula shifting for multi-ranged conditional formats.

* Merge conflicts solved

* Range property made non-obsolete and returning First rather than Single