• 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.
  • 相关阅读:
    virsh 基本命令与创建存储池＼存储卷
    为什么索引要用B+树来实现呢，而不是B树
    Android学习笔记 47. Intent
    谷粒商城 (二十三) --------- 商品服务 API 属性分组 ④ 品牌分类关联与级联更新
    nginx中deny和allow详解
    Unity ScriptableObject 实例不随资源文件更新的解决方案
    【网页设计】期末大作业html+css（音乐网站）
    [pytorch] 2D + 3D ResNet代码实现, 改写
    搭建内部知识库，解决企业内部琐碎信息问题
    从0到1，企业如何快速构建自己的销售体系
  • 原文地址：https://blog.csdn.net/john_dwh/article/details/128075207