I’m generating Excel Workbooks that uses a formula that utilizes the Scan() function. The Scan funtion needs a LAMBDA function as input. For example:
=Scan(0, columname, LAMBDA(acc,n,acc+n))
The Workbook is created wit…...Invalid Name error when using a SCAN and Lambda function Aspose.Cells...that utilizes the SCAN() function. The SCAN funtion needs a LAMBDA...