_xll attached infront of formula name

Aspose.Cells Product Family
1

I have a custom formula, called “BDP” in excel, I implemented it and works fine in v18.3
But in v18.5, the formulaname attaches a “_xll.” in front of the formula name, is this by design or a bug ?

In ICustomFunction interface implementation
public object CalculateCustomFunction(string functionName, ArrayList paramsList, ArrayList contextObjects)

Computing _xll.BDP in Worksheet = ‘Daily_TS’, ‘=IF(ISBLANK(A136),"",BDP($C$1,“interval_end_value”,“end_date_override”,TEXT(A136,“yyyymmdd”)))’ = ‘#NAME?’

2

@sthetakali,

Please provide us a sample excel file and a working compilable console application which can be used for reproducing this issue here. Provide detailed description of the issue so that we may observe the problem and provide our feedback here.

P.S. This seems to be separate issue, therefor I have split it from the original post.

3

Please see the attached code and example data.

  1. Create a folder C:\Dev
  2. Extract the contents to this folder.
  3. Run the program and watch the console output.
    The Function Name “Bdp” is coming inside the ICustomFunction implementation ( Bdp class ) as “_xll.Bdp”.
    in the method CalculateCustomFunction().
    Input data and custom formula is in Bug_SourceData.xlsx

CustomFormulaBug.zip (5.2 MB)

4

@sthetakali,

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-46338 - _xll attached infront of formula name
5

@sthetakali,

This is to inform you that your issue has been fixed. We will soon provide you the fix after performing QA and incorporating other enhancements and fixes.

6

@sthetakali,

Please try our latest version/fix: Aspose.Cells for .NET v18.9.1 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells18.9.1 For .Net2_AuthenticodeSigned.Zip (4.6 MB)
Aspose.Cells18.9.1 For .Net4.0.Zip (4.7 MB)

7

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