Free Support Forum - aspose.com

Error with non-array function

Hi,

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: Test_Formula_Aspose.xlsx.zip (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");
			book.CalculateFormula();
			
			var frontend = book.Worksheets["frontend"];
			frontend.CalculateFormula(true, false, null);
			
			// Get cell --> for debugging
			var cell = frontend.Cells["C15"];
			Console.WriteLine(cell.Value);
			
			// 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,
Pavlo

@denpmr,

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

@denpmr,

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.

@denpmr,

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