NET:Spire.XLS 12.11.3 supports a variety of new formulas

2023-11-27 03:30
文章标签 net new spire xls formulas supports 12.11 variety

本文主要是介绍NET:Spire.XLS 12.11.3 supports a variety of new formulas，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

Spire.XLS 12.11.3 supports a variety of new formulas

发现度娘破解版Spire.XLS for .NET is a professional Excel .NET API that can be used to create, read, write, convert and print Excel files in any type of .NET ( C#, VB.NET, ASP.NET, .NET Core, .NET 5.0, .NET 6.0, MonoAndroid and Xamarin.iOS) application. Spire.XLS for .NET offers object model Excel API for speeding up Excel programming in .NET platform - create new Excel documents from template, edit existing Excel documents and convert Excel files.

Here is a list of changes made in this release
CategoryIDDescription
New featureSPIREXLS-4120Supports CEILING.MATH formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "CEILING.MATH(-2.78,5,-1)";
workbook.CalculateAllValue();
workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016);
New featureSPIREXLS-4195Supports BITOR formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "BITOR(23,10)";
workbook.CalculateAllValue();
workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016);
New featureSPIREXLS-4199Supports BITAND formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "BITAND(23,10)";
workbook.CalculateAllValue();
workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016);
New featureSPIREXLS-4212Supports BITLSHIFT formula.
Supports BITLSHIFT formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "BITLSHIFT(23,2)";
workbook.CalculateAllValue();
workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016);
New featureSPIREXLS-4214Supports BITRSHIFT formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "BITRSHIFT(23,2)";
workbook.CalculateAllValue();
workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016);
New featureSPIREXLS-4191Supports grouping shape.
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
IPrstGeomShape shape1 = worksheet.PrstGeomShapes.AddPrstGeomShape(1, 3, 50, 50, PrstGeomShapeType.RoundRect);
IPrstGeomShape shape2 = worksheet.PrstGeomShapes.AddPrstGeomShape(5, 3, 50, 50, PrstGeomShapeType.Triangle);
GroupShapeCollection groupShapeCollection = worksheet.GroupShapeCollection;
groupShapeCollection.Group(new Spire.Xls.Core.IShape[] { shape1,shape2});
workbook.SaveToFile("1.xlsx",ExcelVersion.Version2013);
New featureSPIREXLS-4194Supports "SHA-512" encryption scheme.
New featureSPIREXLS-4200Supports setting the layout pattern of the entire pivot table.
xlsPivotTable.Options.ReportLayout = PivotTableLayoutType.Tabular;
BugSPIREXLS-4161Fixes the issue that the border and the style of table lost after converting HTML to Excel.
BugSPIREXLS-4163Fixes the issue that the program threw System.NullReferenceException when getting the color of conditional formatting.
BugSPIREXLS-4164Fixes the issue that the content had an extra comma after converting chart to images.
BugSPIREXLS-4182Fixes the issue that the program did not throw an error when decrypting excel file with a wrong password.
BugSPIREXLS-4189Fixes the issue that there were blank columns after deleting hidden columns.
BugSPIREXLS-4197Fixes the issue that the content of the result document was different from that of the original document after the document was loaded and saved.
BugSPIREXLS-4211Fixes the issue that the double quotation marks were incorrect after converting Excel to CSV.
BugSPIREXLS-4218Fixes the issue that the result of the cell range calculation was incorrect.
BugSPIREXLS-4227Fixes the issue that the program threw an error "Unknown font" when getting RTF text of cell range.
BugSPIREXLS-4231Fixes the issue that the program threw an error "Shapes fail to be rendered" when converting Excel to PDF.
BugSPIREXLS-4245Fixes the issue that the program threw System.OutOfMemoryException when converting Excel to PDF.
BugSPIREXLS-4247Fixes the issue that the format was inconsistent after converting HTML to Excel.
BugSPIREXLS-4252Fixes the issue that the slicers lost after saving files as stream.
BugSPIREXLS-4254Fixes the issue that there was a prompt of content error when opening the saved document after OS language area was changed.
BugSPIREXLS-4258Fixes the issue that the program threw System.NullReferenceException when copying sheets.

这篇关于NET:Spire.XLS 12.11.3 supports a variety of new formulas的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/426967。

相关文章

Golan中 new() 、 make() 和简短声明符的区别和使用

Golan中 new() 、 make() 和简短声明符的区别和使用

《Golan中new()、make()和简短声明符的区别和使用》Go语言中的new()、make()和简短声明符的区别和使用,new()用于分配内存并返回指针,make()用于初始化切片、映射... 详细介绍golang的new() 、 make() 和简短声明符的区别和使用。文章目录 `new()`
阅读更多...
Java操作xls替换文本或图片的功能实现

Java操作xls替换文本或图片的功能实现

《Java操作xls替换文本或图片的功能实现》这篇文章主要给大家介绍了关于Java操作xls替换文本或图片功能实现的相关资料,文中通过示例代码讲解了文件上传、文件处理和Excel文件生成,需要的朋友可... 目录准备xls模板文件：template.xls准备需要替换的图片和数据功能实现包声明与导入类声明与
阅读更多...
.NET利用C#字节流动态操作Excel文件

.NET利用C#字节流动态操作Excel文件

《.NET利用C#字节流动态操作Excel文件》在.NET开发中,通过字节流动态操作Excel文件提供了一种高效且灵活的方式处理数据,本文将演示如何在.NET平台使用C#通过字节流创建,读取,编辑及保... 目录用C#创建并保存Excel工作簿为字节流用C#通过字节流直接读取Excel文件数据用C#通过字节
阅读更多...
poj 1258 Agri-Net（最小生成树模板代码）

poj 1258 Agri-Net（最小生成树模板代码）

感觉用这题来当模板更适合。 题意就是给你邻接矩阵求最小生成树啦。~ prim代码：效率很高。172k...0ms。 #include<stdio.h>#include<algorithm>using namespace std;const int MaxN = 101;const int INF = 0x3f3f3f3f;int g[MaxN][MaxN];int n
阅读更多...
如何在Visual Studio中调试.NET源码

如何在Visual Studio中调试.NET源码

今天偶然在看别人代码时，发现在他的代码里使用了Any判断List<T>是否为空。 我一般的做法是先判断是否为null，再判断Count。 看了一下Count的源码如下： 1 [__DynamicallyInvokable]2 public int Count3 {4 [__DynamicallyInvokable]5 get
阅读更多...
2、PF-Net点云补全

2、PF-Net点云补全

2、PF-Net 点云补全 PF-Net论文链接：PF-Net PF-Net （Point Fractal Network for 3D Point Cloud Completion）是一种专门为三维点云补全设计的深度学习模型。点云补全实际上和图片补全是一个逻辑，都是采用GAN模型的思想来进行补全，在图片补全中，将部分像素点删除并且标记，然后卷积特征提取预测、判别器判别，来训练模型，生成的像
阅读更多...
java线程深度解析（一）——java new 接口？匿名内部类给你答案

java线程深度解析（一）——java new 接口？匿名内部类给你答案

http://blog.csdn.net/daybreak1209/article/details/51305477 一、内部类 1、内部类初识 一般，一个类里主要包含类的方法和属性，但在Java中还提出在类中继续定义类（内部类）的概念。 内部类的定义：类的内部定义类 先来看一个实例 [html]  view plain copy pu
阅读更多...
string字符会调用new分配堆内存吗

string字符会调用new分配堆内存吗

gcc的string默认大小是32个字节，字符串小于等于15直接保存在栈上，超过之后才会使用new分配。
阅读更多...
.NET 自定义过滤器 - ActionFilterAttribute

.NET 自定义过滤器 - ActionFilterAttribute

这个代码片段定义了一个自定义的 ASP.NET Core 过滤器（GuardModelStateAttribute），用于在控制器动作执行之前验证模型状态（ModelState）。如果模型状态无效，则构造一个 ProblemDetails 对象来描述错误，并返回一个 BadRequest 响应。 代码片段： /// <summary>/// 验证 ModelState 是否有效/// </
阅读更多...
List list = new ArrayList();和ArrayList list=new ArrayList();的区别？

List list = new ArrayList();和ArrayList list=new ArrayList();的区别？

List是一个接口，而ArrayList 是一个类。 ArrayList 继承并实现了List。 List list = new ArrayList();这句创建了一个ArrayList的对象后把上溯到了List。此时它是一个List对象了，有些ArrayList有但是List没有的属性和方法，它就不能再用了。而ArrayList list=new ArrayList();创建一对象则保留了A
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2