本文主要是介绍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 | ||
| Category | ID | Description |
| New feature | SPIREXLS-4120 | Supports 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 feature | SPIREXLS-4195 | Supports BITOR formula. |
| Workbook workbook = new Workbook(); | ||
| workbook.Worksheets[0].Range["A1"].Formula = "BITOR(23,10)"; | ||
| workbook.CalculateAllValue(); | ||
| workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016); | ||
| New feature | SPIREXLS-4199 | Supports BITAND formula. |
| Workbook workbook = new Workbook(); | ||
| workbook.Worksheets[0].Range["A1"].Formula = "BITAND(23,10)"; | ||
| workbook.CalculateAllValue(); | ||
| workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016); | ||
| New feature | SPIREXLS-4212 | Supports 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 feature | SPIREXLS-4214 | Supports BITRSHIFT formula. |
| Workbook workbook = new Workbook(); | ||
| workbook.Worksheets[0].Range["A1"].Formula = "BITRSHIFT(23,2)"; | ||
| workbook.CalculateAllValue(); | ||
| workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016); | ||
| New feature | SPIREXLS-4191 | Supports 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 feature | SPIREXLS-4194 | Supports "SHA-512" encryption scheme. |
| New feature | SPIREXLS-4200 | Supports setting the layout pattern of the entire pivot table. |
| xlsPivotTable.Options.ReportLayout = PivotTableLayoutType.Tabular; | ||
| Bug | SPIREXLS-4161 | Fixes the issue that the border and the style of table lost after converting HTML to Excel. |
| Bug | SPIREXLS-4163 | Fixes the issue that the program threw System.NullReferenceException when getting the color of conditional formatting. |
| Bug | SPIREXLS-4164 | Fixes the issue that the content had an extra comma after converting chart to images. |
| Bug | SPIREXLS-4182 | Fixes the issue that the program did not throw an error when decrypting excel file with a wrong password. |
| Bug | SPIREXLS-4189 | Fixes the issue that there were blank columns after deleting hidden columns. |
| Bug | SPIREXLS-4197 | Fixes the issue that the content of the result document was different from that of the original document after the document was loaded and saved. |
| Bug | SPIREXLS-4211 | Fixes the issue that the double quotation marks were incorrect after converting Excel to CSV. |
| Bug | SPIREXLS-4218 | Fixes the issue that the result of the cell range calculation was incorrect. |
| Bug | SPIREXLS-4227 | Fixes the issue that the program threw an error "Unknown font" when getting RTF text of cell range. |
| Bug | SPIREXLS-4231 | Fixes the issue that the program threw an error "Shapes fail to be rendered" when converting Excel to PDF. |
| Bug | SPIREXLS-4245 | Fixes the issue that the program threw System.OutOfMemoryException when converting Excel to PDF. |
| Bug | SPIREXLS-4247 | Fixes the issue that the format was inconsistent after converting HTML to Excel. |
| Bug | SPIREXLS-4252 | Fixes the issue that the slicers lost after saving files as stream. |
| Bug | SPIREXLS-4254 | Fixes the issue that there was a prompt of content error when opening the saved document after OS language area was changed. |
| Bug | SPIREXLS-4258 | Fixes the issue that the program threw System.NullReferenceException when copying sheets. |
这篇关于NET:Spire.XLS 12.11.3 supports a variety of new formulas的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
