knarita/ClosedXML

Fork: 0

knarita / ClosedXML

History for ClosedXML / ClosedXML_Tests / Resource / Examples

2018-05-07	9677cfc Browse files » Support table sources for pivot tables Francois Botha committed on 7 May 2018
2018-05-04	89664ca Browse files » Simplify XLCell.cs() Francois Botha committed on 4 May 2018
2018-05-04	2beb1c6 Browse files » Load file's cached value into XLCell.CachedValue - need to some refactoring of the internal parsing in XLCell Francois Botha committed on 4 May 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-23	2c4c0e8 Browse files » Change XLTable.Theme default value to TableStyleMedium2 to align with Excel Francois Botha committed on 23 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-11	fc9c007 Browse files » Merge branch 'StylesRebased' of https://github.com/Pankraty/ClosedXML into Pankraty-StylesRebased ... # Conflicts: # ClosedXML/Excel/XLWorkbook_Save.cs # ClosedXML_Tests/Excel/Columns/ColumnTests.cs # ClosedXML_Tests/Excel/Rows/RowTests.cs # ClosedXML_Tests/Resource/StyleReferenceFiles/ConditionalFormattingOrder/ConditionalFormattingOrder.xlsx # ClosedXML_Tests/Resource/StyleReferenceFiles/TransparentBackgroundFill/TransparentBackgroundFill.xlsx Francois Botha committed on 11 Apr 2018
	d7eba4b Browse files » Merge branch 'develop' into Pankraty-StylesRebased ... # Conflicts: # ClosedXML/ClosedXML.csproj # ClosedXML/Excel/Style/Colors/XLColor_Public.cs # ClosedXML/Excel/Style/IXLFontBase.cs # ClosedXML/Excel/XLWorkbook.cs # ClosedXML/Excel/XLWorkbook_Save.cs # ClosedXML_Tests/ClosedXML_Tests.csproj Francois Botha committed on 11 Apr 2018
	51b656e Browse files » Merge branch 'last-before-netstandard2' into Pankraty-StylesRebased ... # Conflicts: # ClosedXML/Excel/XLWorkbook_Save.cs Francois Botha committed on 11 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-03-24	d2074b7 Browse files » Merge branch 'develop' into StylesRebased ... # Conflicts: # ClosedXML/Excel/XLWorkbook_Save.cs Aleksei committed on 24 Mar 2018
2018-03-24	c506952 Browse files » Empty fills and borders considered equal no matter what colors they are. Aleksei committed on 24 Mar 2018
2018-03-20	147f273 Browse files » Exclude empty font, border and fill sections in differential styles ... # Conflicts: # ClosedXML/Excel/XLWorkbook_Save.cs # ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx # ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx # ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx # ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx # ClosedXML_Tests/Resource/Examples/Ranges/AddingRowToTables.xlsx # ClosedXML_Tests/Resource/Examples/Tables/InsertingTables.xlsx # ClosedXML_Tests/Resource/Examples/Tables/UsingTables.xlsx Aleksei authored on 13 Mar 2018 Francois Botha committed on 20 Mar 2018
2018-03-13	b00b6d4 Browse files » Exclude empty font, border and fill sections in differential styles Aleksei committed on 13 Mar 2018
2018-03-13	d8b438d Browse files » Merge branch 'develop' of https://github.com/ClosedXML/ClosedXML into StylesRebased ... # Conflicts: # ClosedXML/Excel/XLWorkbook.cs # ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx # ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx # ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx # ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx # ClosedXML_Tests/Resource/Examples/Ranges/AddingRowToTables.xlsx # ClosedXML_Tests/Resource/Examples/Ranges/CurrentRowColumn.xlsx # ClosedXML_Tests/Resource/Examples/Ranges/DeletingRanges.xlsx # ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx # ClosedXML_Tests/Resource/Examples/Ranges/TransposeRanges.xlsx # ClosedXML_Tests/Resource/Examples/Ranges/TransposeRangesPlus.xlsx # ClosedXML_Tests/Resource/Examples/Tables/InsertingTables.xlsx # ClosedXML_Tests/Resource/Examples/Tables/UsingTables.xlsx Aleksei committed on 13 Mar 2018
2018-03-09	4836445 Browse files » Keep Table relId unchanged when re-saving Francois Botha committed on 9 Mar 2018
	742888c Browse files » Eliminate redundant styles creation during saving (#717) ... * Fix reference file with duplicate styles. Remove Alignment from comparison as it does not exist in cellStyleXfs section. * Fixed reference files having redundant styles Aleksei authored on 9 Mar 2018 Francois Botha committed on 9 Mar 2018
	82ac8db Browse files » Fix issues with data validation rules (#718) ... * Failing tests added * Modified logic of cell DataValidation rules * DataValidation.xlsx updated. It had 42 rules at sheet 2, now it has 16. * Tests muted until formula shifting fixed * Reading DataValidation rules for ranges made pure * Restore DataValidation implicit creation to avoid breaking changes. Fix clearing data validation. * Original test restored (use DataValidation instead of SetDataValidation) Aleksei authored on 9 Mar 2018 Francois Botha committed on 9 Mar 2018
2018-03-08	f592042 Browse files » FIX Shifting conditional format ranges works slow and incorrectly (#721) ... * Failing tests for conditional format shifting * Conditional formats shifting re-implemented. Reference file updated (empty cell excluded) Aleksei authored on 8 Mar 2018 Francois Botha committed on 8 Mar 2018
2018-03-07	e7378c3 Browse files » Non-initialized cell excluded from children of XLColumn and XLRow. Reference files updated (cells with default styles excluded) Aleksei committed on 7 Mar 2018
2018-03-07	1f2b05f Browse files » Reference files updated (minor changes in XML: items reordered, default style elements skipped) Aleksei committed on 7 Mar 2018
2018-03-03	a60a5b4 Browse files » #613 Pivot table Field Settings saving and loading (#616) ... * save and load PivotField options * #613 Pivot table Field Settings saving and loading * test fixed * no message Rozhkov Alexey authored on 3 Mar 2018 Francois Botha committed on 3 Mar 2018
2018-03-01	c4c8a4f Browse files » Correctly apply XLSortOrder sortOrder parameter for table sorting. Fixes #705 Francois Botha committed on 1 Mar 2018
2018-02-27	080bc22 Browse files » DiagonalBorder and DiagonalBorderColor added to comparision. Reference file fixed Aleksei authored on 27 Feb 2018 Francois Botha committed on 27 Feb 2018
2018-02-26	9caa92d Browse files » Add dategroup filtered column. Fixes #701 Francois Botha committed on 26 Feb 2018
2018-02-08	41b25a8 Browse files » Parse percentage too when setting datatype to numeric. Fixes #687 Francois Botha committed on 8 Feb 2018
2018-02-02	80db197 Browse files » FIX Page breaks duplication on saving (#677) ... * Failing test for page breaks * Fix page breaks duplication on saving * Update example file with improper page breaks. Aleksei authored on 2 Feb 2018 Francois Botha committed on 2 Feb 2018
2018-01-31	df3c1dd Browse files » Escape quotes in worksheet names Aleksei authored on 19 Jan 2018 Francois Botha committed on 31 Jan 2018
	a7442a1 Browse files » Fix active cell issue when freezing panes Francois Botha committed on 31 Jan 2018
	ee25843 Browse files » Don't explicitly use Convert.ToDecimal - it leads to bounds errors. Francois Botha committed on 31 Jan 2018