ClosedXML.Signed 0.95.0-beta1

Prefix Reserved
.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. .NET Framework 4.0 This package targets .NET Framework 4.0. The package is compatible with this framework or higher.
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.95.0-beta1                

                    
                

            
NuGet\Install-Package ClosedXML.Signed -Version 0.95.0-beta1
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.95.0-beta1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add ClosedXML.Signed --version 0.95.0-beta1                

                    
                

            
#r "nuget: ClosedXML.Signed, 0.95.0-beta1"
#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.95.0-beta1&prerelease

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

Breaking changes

  • Range strings, e.g. A1:B2 are now always treated as absolute, i.e. relative to A1 instead of relative to the top left cell of a given range.
  • IXLSheetProtection has been totally refactored and now uses a flag based enum to control the elements that are allowed or locked.
  • Removed IXLSheetProtection.IsProtected setter
  • XLClearOptions and XLCellUsedOptions 's flags are now aligned

Enhancements

  • #1015 Text join func enhancement (Thanks @James-Whitfield)
  • #1038 IXLSheetProtection refactoring
  • #1054 Implement workbook FileSharing and a few of the properties
  • #1058 Dont recalculate formula cached values after load
  • #1077 Refactor digit and letter parsing to allow Unicode characters
  • #1109 Don't automatically adjust columns width to contents when inserting datatable. Some users want to opt out because of PlatformNotSupportedException
  • #1129 Implementation pivot table formats (Thanks @b0bi79)
  • #1130 Enhance TRUNC function for additional parameter
  • #1136 Implement NUMBERVALUE function
  • #1151 Performance improvement to delete entire columns
  • #1158 Check that print titles are valid row ranges or column ranges
  • #1170 Remove IXLSheetProtection.IsProtected public setter

Bug fixes

  • #1063 Copy comment style correctly when shifting ranges
  • #1108 Correctly save empty cell with quote prefix (do not treat as empty)
  • #1132 <c> elements with missing r attribute: XLAddress constructor had parameters swapped
  • #1133 Enumerate ranges in a deterministic order
  • #1134 Correctly propagate worksheet style to cells from a worksheet
  • #1135 Correctly load column-wide styles
  • #1137 Fix changing inner borders of the range
  • #1150 Correctly clear inline string when required
  • #1153 Correctly throw DivisionByZeroException when denominator is zero.
  • #1155 Ignore _X (capital X) as XML escaping char
  • #1161 Avoid creation of new item in Internals.RowsCollection when adding comment
  • #1168 Fix initialization of default styles for XLCells, XLRows, XLColumns and XLRanges

Thanks to @Pankraty for many PRs, as usual.

  • @igitur
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.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.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 353,435 12/16/2020 0.95.4 is deprecated because it is no longer maintained.
0.95.3 105,517 5/25/2020
0.95.2 29,666 4/26/2020
0.95.1 801 4/23/2020
0.95.0 7,206 4/15/2020
0.95.0-beta2 1,669 8/21/2019
0.95.0-beta1 2,194 4/4/2019
0.94.2 139,090 12/18/2018
0.94.0 1,353 12/12/2018
0.94.0-rc2 885 11/29/2018
0.94.0-rc1 715 11/11/2018
0.93.1 11,955 8/7/2018
0.93.0 5,709 6/25/2018
0.93.0-rc3 842 6/7/2018
0.93.0-rc2 953 5/31/2018

See https://github.com/ClosedXML/ClosedXML/releases/tag/0.95.0-beta1