ClosedXML.Signed 0.94.0-rc2

Prefix Reserved
This is a prerelease version of ClosedXML.Signed.
There is a newer version of this package available.
See the version list below for details.
dotnet add package ClosedXML.Signed --version 0.94.0-rc2                
NuGet\Install-Package ClosedXML.Signed -Version 0.94.0-rc2                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="ClosedXML.Signed" Version="0.94.0-rc2" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add ClosedXML.Signed --version 0.94.0-rc2                
#r "nuget: ClosedXML.Signed, 0.94.0-rc2"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install ClosedXML.Signed as a Cake Addin
#addin nuget:?package=ClosedXML.Signed&version=0.94.0-rc2&prerelease

// Install ClosedXML.Signed as a Cake Tool
#tool nuget:?package=ClosedXML.Signed&version=0.94.0-rc2&prerelease                

Breaking changes

  • IDisposable interface removed from IXLWorksheet. See #1049
  • IXLPictures interface has changed to accept parameters of type IXLCell instead of IXLAddress. See #930
  • IXLBaseAutoFilter removed and replaced with the existing IXLAutoFilter. See #909
  • IXLRange.ToString() and IXLRangeAddress.ToString() now return context aware range strings. See #1021

Enhancements

  • #856 Clear pivot table rendered range upon loading to avoid conflict on rendered cells when opening the file.
  • #877 Add helper property VisibleRows for autofilters
  • #884 Allow pivot tables to have no theme
  • #904 Implement the full range of Item subclasses for pivot tables
  • #905 Don't choke on pivot table saving when formulas fail
  • #908 New methods to append and replace table data
  • #909 New method to reapply autofilter
  • #926 Disallow table with null .DataRange when saving
  • #930 Store picture markers against a range to allow shifting when inserting and deleting
  • #932 Optionally propagate extra table columns when changing data
  • #945 Allow Guid values to be inserted when dumping data
  • #962 Add ability to set cell value to an enum value
  • #978 Add table helper methods: IXLTables.TryGetTable()
  • #996 Allow table field names consisting of only whitespace
  • #999 Allow names to start with backslash
  • #1005 Ignore print areas that point to external workbooks
  • #1019 Improve XLCell.TryGetValue and implement additional tests
  • #1021 Return simpler range address values
  • #1025 Lazy initialize graphics
  • #1033 Optimize the performance of searching range intersections on small collections
  • #1035 Improve implicit string casting
  • #1036 Don't validate named ranges when loading file
  • #1044 Add check that data validation value length does not exceed 255 chars
  • #1064 Make TryGetValue_decimal_Good2test environment-independent

Bug fixes

  • #876 Correctly unprotect worksheet without password
  • #887 Correctly determine used range when there are merged ranges on a worksheet
  • #903 Clear all cell contents (formats too) in pivot table range upon loading.
  • #906 Maintain pivot table page field order
  • #931 Delete table rows correctly
  • #947 Fix pivot table integrity when saving multiple times
  • #956 Do not quote worksheet name with whitespace when saving pivot table worksheet source
  • #969 Fix ranges consolidation
  • #985 Set XLPivotField.ShowBlankItems by default to false and fix treatment of defaults from loading file
  • #988 FIX for XLConditionalFormat equality comparer fails for ColorScale
  • #998 Copies of tables should have RelId default to null
  • #1023 Sort ranges to shift before enumerating through them to avoid new target address conflicting with existing range
  • #1028 Copy row/column visibility setting
  • #1029 CellsUsed refactoring and fix
  • #1031 Fix for merging cells
  • #1032 Change the way invalid ranges are saved
  • #1041 Autofilter with multiple columns with filters
  • #1047 String comparisons should be case-insensitive
  • #1048 Shift data validation ranges when inserting / delete ranges
Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net40 is compatible.  net403 was computed.  net45 was computed.  net451 was computed.  net452 was computed.  net46 is compatible.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (10)

Showing the top 5 NuGet packages that depend on ClosedXML.Signed:

Package Downloads
AMain.ExcelHelper

A library for reading and writing Excel files. Extremely fast, flexible, and easy to use. The primary purpose of this library is to support reading Excel files into Plain Old C# Objects (POCO's) with a high performance parser for converting the records from Excel intil C# objects. Supports reading and writing of custom class objects. Supports reading Excel files in all formats including the newer OpenXML formats as well as the older binary BIFF8 and BIFF5 formats using the awesome ExcelDataReader project. Supports writing XML files only in the OpenXML format using the awesome ClosedXML library.

LiquidTechnologies.DataMapper.Runtime

JSON, XML, Database, CSV, EDI and Excel Data Mapper (Runtime Library). Download Liquid Data Mapper from the project page.

DataBooster.DbWebApi.Oracle.ODP

An out-of-the-box Web API for invoking database stored procedures, transforming the results as JSON, BSON, JSONP, XML, CSV, Excel xlsx, or any text generated by Razor dynamic template. Please visit https://github.com/DataBooster/DbWebApi for detail.

DataBooster.DbWebApi.SqlServer

An out-of-the-box Web API for invoking database stored procedures, transforming the results as JSON, BSON, JSONP, XML, CSV, Excel xlsx, or any text generated by Razor dynamic template. Please visit https://github.com/DataBooster/DbWebApi for detail.

DataBooster.DbWebApi.Oracle.Managed

An out-of-the-box Web API for invoking database stored procedures, transforming the results as JSON, BSON, JSONP, XML, CSV, Excel xlsx, or any text generated by Razor dynamic template. Please visit https://github.com/DataBooster/DbWebApi for detail.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
0.95.4 323,224 12/16/2020 0.95.4 is deprecated because it is no longer maintained.
0.95.3 103,076 5/25/2020
0.95.2 28,147 4/26/2020
0.95.1 788 4/23/2020
0.95.0 6,596 4/15/2020
0.95.0-beta2 1,633 8/21/2019
0.95.0-beta1 2,153 4/4/2019
0.94.2 135,839 12/18/2018
0.94.0 1,331 12/12/2018
0.94.0-rc2 874 11/29/2018
0.94.0-rc1 704 11/11/2018
0.93.1 11,723 8/7/2018
0.93.0 5,673 6/25/2018
0.93.0-rc3 835 6/7/2018
0.93.0-rc2 946 5/31/2018