• 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.
  • 相关阅读:
    使用Requests发送HTTP请求
    【Sklearn学习】Sklearn的数据集介绍
    C语言函数章--第二弹(让冤种室友用你的函数，但不给他看函数源码)
    RFID电网资产全寿命周期管理解决方案
    [ROS]（09）ROS通信 —— 话题（Topic）通信之msg
    深入理解RocketMQ 广播消费
    Thread类的用法
    JVM实战：JVM运行时数据区
    AI写作工具大有用处！
    GM8775C MIPI转LVDS调试资料分享
  • 原文地址：https://blog.csdn.net/john_dwh/article/details/128075207