Names with PROP_ prefix

Aspose.Cells Product Family
1

Hi.

In the attached template, i created a named range called “prop_employee”. Then Excel created a documentproperty linked to the cell pointed by that name.

When I execute the code below, only cell “B4” is changed; cell “B3” remains unchanged! Could you figure out why?

I tried with Aspose.Cells v8.5.0.0 and v7.4.3.0.

The code is:

License license = new License();
license.SetLicense(@"...");
Workbook wb1 = new Workbook(Server.MapPath(".") + "\\Name_with_Prop.xls");
wb1.Worksheets[0].Cells["B3"].PutValue("aaa");
wb1.Worksheets[0].Cells["B4"].PutValue("bbb");
SaveOptions Aspose_SaveOptions;
Aspose_SaveOptions = new XlsSaveOptions(SaveFormat.Excel97To2003);
wb1.Save(Response, "output.xls", ContentDisposition.Attachment, Aspose_SaveOptions);

Thank you.

Ricardo Coimbras

2

Hi Ricardo,

Thanks for your posting and using Aspose.Cells.

We were able to replicate this issue by executing your sample code with the latest version: Aspose.Cells for .NET 8.5.0 using your source excel file. Names with PROP_ prefix are unable to be changed.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43743 - Names with PROP_ prefix are unable to be changed

3

Hi,

Thanks for using Aspose.Cells.

Please call Workbook.CustomDocumentProperties.UpdateLinkedPropertyValue() method before saving the workbook.

Please see the following code:

C#


wb1.Worksheets[0].Cells[“B3”].PutValue(“aaa”);

wb1.Worksheets[0].Cells[“B4”].PutValue(“bbb”);

wb1.CustomDocumentProperties.UpdateLinkedPropertyValue();