knarita/ClosedXML

Fork: 0

knarita / ClosedXML

History for ClosedXML / ClosedXML_Tests / Excel / Ranges

2018-06-27	b448bcc Browse files » Exclude full span addresses from range change notifications Francois Botha committed on 27 Jun 2018
2018-06-06	32ec154 Browse files » Correctly determine used range when there are merged ranges on a worksheet (fix #881) (#887) ... * Failing tests added * Failing tests for predicates added. * Missing predicates added to LastCellUsed and FirstCellUsed * Analyze merged ranges with any value of includeFormats flag. * Use extension method instead of two comparisons * Use null propagation for predicate Aleksei authored on 1 Jun 2018 Francois Botha committed on 6 Jun 2018
2018-05-30	05b2754 Browse files » Make range address invalid on worksheet deleting. ... Handle invalid ranges in XLNamedRange. Re-implement XLAddress and XLRangeAddress ToString* methods to correctly process #REF! Aleksei authored on 14 May 2018 Francois Botha committed on 30 May 2018
2018-05-17	d5abbda Browse files » Disallow negative row or column count to be inserted (#857) ... * Disallow negative row or column count to be inserted * Disallow zero columns or rows to be inserted as well * Tests for zero numbers added. Typo fixed. Aleksei authored on 17 May 2018 Francois Botha committed on 17 May 2018
2018-04-26	faf9da9 Browse files » Failing test added Aleksei authored on 26 Apr 2018 Francois Botha committed on 26 Apr 2018
2018-04-26	aabb635 Browse files » IXLRangeIndex defined ... Range indexing using QuadTree implemented Replace searches of intersected ranges with the optimized version Aleksei authored on 21 Apr 2018 Francois Botha committed on 26 Apr 2018
2018-04-25	4997795 Browse files » 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). Aleksei authored on 25 Apr 2018 Francois Botha committed on 25 Apr 2018
2018-04-24	34f1a6c Browse files » Add support for named ranges referring to expressions or to multiple ranges Aleksei authored on 24 Apr 2018 Francois Botha committed on 24 Apr 2018
2018-04-19	0.93.0-beta1 3344f1d Browse files » С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 Aleksei authored on 19 Apr 2018 Francois Botha committed on 19 Apr 2018
2018-04-10	Unverified 0.92.0 015d7d0 Browse files » Multi-targeting: net40, net461, netstandard2.0 (#315) ... * Convert to Visual Studio 2017 format. * Force VS2017 appveyor image * Add MyGet source before CI build * Update artifacts * Implement .NET standard as far as possible. System.Drawing.Bitmap is still missing - hence the XLPicture API is incomplete * Change to VS 2017 Preview image to support .NET Standard 2 * Add APPVEYOR environment variable support * Improve color support and more * Add a basic test for OpenXml - which currently breaks in .NET Standard 2.0 * Use OpenXML 2.7.2 for all targets * Replace net452 with net40 build * Try netstandard where possible * Update NuGet on appveyor before building * Implement MetadataExtractor to get image dimensions and format * When setting culture, do it for every time a test is run. * Fix dependency issue * fix support for TIFF files * Default the image position to top left if position hasn't been set. * Test all targets * Update test framework * Add .editorconfig files back in projects * Disable OpenXML test on AppVeyor until bug is fixed * Better approximation of font sizes on netstandard2 * Workaround for OpenXML bug as per https://github.com/OfficeDev/Open-XML-SDK/issues/235 * Fix for DeflateStream not being seekable. Copy to MemoryStream * Exclude Excel temporary files when building * Use CoreCompat for measuring fonts on netstandard - remove lots of conditional code * Reindent file * Upgrade NUnit * Add support for .NET 3.5 * Fix for NET35 * Remove explicit test targets. Should work on appveyor now. * Add Microsoft.CSharp where necessary. Remove net40 from tests, for now. * Skip OpenXML document properties test * Use System.Drawing.Common instead of MetadataExtractor and CoreCompat * Sign projects * Specify test assemblies in appveyor.yml * Comment out platform in order to get CI to correctly detect test assembly path. as per https://github.com/appveyor/ci/issues/1746\#issuecomment-339187046 * Remove .NET3.5 build from artifacts * Add net40 to tests * Add reference to Microsoft.CSharp for net40 * Switch net461 to net46 Remove NU1605 warnings Clean up dependencies * Generate documentation file * Ignore warning CS1591: Missing XML comment for publicly visible type or member * Reenable some System.Drawing features for netstandard2 * Upgrade FastMember.Signed to v1.3.0 * Upgrade NUnit to 3.10 * Upgrade test framework * Remove framework distinction for netcore * Collapse empty XML elements for comparison - netcore and netframework versions of OpenXML save the internals differently. * Copy text.xlsx to output directory * Enable test for netstandard too. * Refactor TestHelper.StripColumnWidths * Align conditional compiler constants for netcore/netstandard to _NETSTANDARD2_0_ * Change documentation file declaration to enable build on Linux Francois Botha authored on 10 Apr 2018 GitHub committed on 10 Apr 2018
2018-04-05	55573f2 Browse files » RemoveAll signature changed to apply match criteria. Aleksei authored on 5 Apr 2018 Francois Botha committed on 5 Apr 2018
2018-04-05	39fb67b Browse files » Add RemoveAll method to IXLRanges Aleksei authored on 27 Mar 2018 Francois Botha committed on 5 Apr 2018
2018-03-16	43c302d Browse files » Breaking change: ... Refactor IsInvalid to IsValid Remove public setter from IXLRangeAddress.IsValid Francois Botha committed on 16 Mar 2018
2018-03-15	268c7b9 Browse files » Provide more enum options for clearing ranges. - BREAKING CHANGE Francois Botha committed on 15 Mar 2018
2018-03-15	30f705c Browse files » Clear conditional formats when clearing the range Rozhkov Alexey authored on 5 Dec 2017 Francois Botha committed on 15 Mar 2018
2018-02-06	8a1aa8f Browse files » FIX "Range is invalid" issue (#665) ... * Create failing test for inserting a column issue. * ShiftColumns and ShiftRows rewritten Aleksei authored on 6 Feb 2018 Francois Botha committed on 6 Feb 2018
2017-11-15	f8d1217 Browse files » Implementing code review feedback. Rozhkov Alexey committed on 15 Nov 2017
2017-10-07	9303c06 Browse files » Fixed copying of conditional formats while copying the range. Rozhkov Alexey committed on 7 Oct 2017
2017-09-21	9ae72dc Browse files » Add set operations (Union, Intersection, Difference) to RangeBase Francois Botha committed on 21 Sep 2017
2017-09-08	a3da404 Browse files » Fix hyperlinks - include sheet name. Francois Botha committed on 8 Sep 2017
2017-06-07	6a7bc90 Browse files » Add extension method to wrap sheet name in quotes, only if required, i.e. it contains a space in the name ... Throw exception of invalid named range is added on workbook scope Contain named range references to minimum and maximum column and row dimensions when deleting rows / columns. Fixes #328 Francois Botha committed on 7 Jun 2017
2017-05-30	8fb8848 Browse files » Unknown changes - something to do with line endings? Francois Botha committed on 30 May 2017
2017-02-24	8f1b4b6 Browse files » Don't reference cell to get row height - it will create new unused cell in cells collection. Francois Botha committed on 24 Feb 2017
2016-11-07	daa413d Browse files » Merge pull request #62 from igitur/add-openxml-validator ... Optionally validate the workbook using OpenXmlValidator when saving it. Amir authored on 7 Nov 2016 GitHub committed on 7 Nov 2016
2016-11-01	393202e Browse files » Expose new Cells() function to iterate over cells, including unused cells inside range, but excluding unused cells outside range. Francois Botha committed on 1 Nov 2016
2016-10-10	a086db4 Browse files » Enable workbook validation in tests Francois Botha committed on 10 Oct 2016
2016-09-09	5a15427 Browse files » Project hierarchy cleanup Amir committed on 9 Sep 2016