Free Support Forum -

Error with non-array function


Our customer sees an error when Aspose is used, but there’s no error when the file is open in Excel.
Please see attached file: (8 KB)

Formula calculated in Aspose:
Screen Shot 2018-08-22 at 14.27.23.png (13.9 KB)

Opened in Excel:
Screen Shot 2018-08-22 at 14.26.22.png (4.1 KB)

Sample code:
using System;
using System.IO;
using Aspose.Cells;
using Aspose.Cells.Rendering;

namespace AsposeTest
	class Program
		static void Main(string[] args)
			var book = new Workbook(@"C:\temp\Test_Formula_Aspose.xlsx");
			var frontend = book.Worksheets["frontend"];
			frontend.CalculateFormula(true, false, null);
			// Get cell --> for debugging
			var cell = frontend.Cells["C15"];
			// Or save as SVG --> real use scenario

//			var imgOptions = new ImageOrPrintOptions
//			{
//				OnePagePerSheet = true,
//				PrintingPage = PrintingPageType.IgnoreBlank,
//				SaveFormat = SaveFormat.SVG
//			};
//			var imgStream = new MemoryStream();
//			var render = new SheetRender(frontend, imgOptions);
//			render.ToImage(0, imgStream);
//			imgStream.Seek(0, SeekOrigin.Begin);
//			using (var file = File.Create(@"C:\temp\out.svg"))
//			{
//				imgStream.CopyTo(file);
//			}

Best regards,


We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46303- Formula not calculated properly


This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46303”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


Please try our latest version/fix: Aspose.Cells for .NET v18.8.3:

Your issue should be fixed in it.

Let us know your feedback.

The issues you have found earlier (filed as CELLSNET-46303) have been fixed in Aspose.Cells for .NET v18.9. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi