SmartMarker does not update cross sheet formula reference

Aspose.Cells Product Family
1

Dear support team,

I’m using aspose.cells for .net 18.5.0.
I have worksheet A. In cell A1, I have smart marker “&=entity.property(horizontal)”. In cell B1, I have a fixed value.
While in worksheet B, cell A1, I have formula “=worksheet_A!B1” or “=worksheet_A!$B$1”.
And I used Process() method of work book designer to process data.
Now In my worksheet A, original B1 moved to D1, because I have 3 items in “entity” list. But the formula in worksheet B, cell A1 doesn’t get update, it remains what it was. I need it to be “=worksheet_A!D1”.

I searched all over the forum, no solution found so far. Using “UpdateReference = true” at work book designer level doesn’t solve my problem, and I really need this feature.

Regards,
Bruce

2

@wsioncn,

Thanks for the details.

After an initial test, I am able to reproduce the issue as you mentioned by using the following sample code with the template file (attached) to test your scenario/ case. I found Smart Marker does not update cross sheet formula reference:
e.g
Sample code:

string filePath = "e:\\test2\\Bk_smcros1.xlsx";

            Workbook wb = new Workbook(filePath);

            WorkbookDesigner d = new WorkbookDesigner();

            d.Workbook = wb;

            DataTable dt = new DataTable("entity");

            dt.Columns.Add("property", typeof(int));

            dt.Rows.Add(10 );

            dt.Rows.Add(20);

            dt.Rows.Add(30 );

            d.SetDataSource(dt);
            d.UpdateReference = true;
            d.Process();

            wb.Save(filePath + ".out.xlsx");

I have logged a ticket with an id “CELLSNET-46782” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.
files1.zip (13.6 KB)

3

@wsioncn,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@wsioncn,

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

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.6.1 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.6.1 For .Net4.0.Zip (4.9 MB)

5

@Amjad_Sahi
Thanks for having this issue fixed.

6

@wsioncn,
Good to know that your issue is sorted out. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

7

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