Cannot change the author workbook property

[Elsa]

Hi! I am using an Excel template to create another file.

workbook = application.Workbooks.Open(templatePath);

// Save the Excel workbook to the user''s file system before processing the nodes and the table of contents.
workbook.Author = EnvironmentSettings.GetApplicationName();
workbook.SaveAs(fileName);

I followed your example to change the Author property on the workbook. I check the value of this property while the application is running and it shows what I expect. When I open the workbook and view the properties (File, Properties), the value that I expect is not there. I''ll appreciate if somebody knows the solution to this.

[Elsa]

I''m using 4.1.0.62

[Administrator]

Hi Elsa,

This seems to be a bug when creating a spreadsheet based on another template

http://www.syncfusion.com/support/issues/xlsio/Default.aspx?ToDo=view&questId=1829

We will fix this as soon as possible.

Thanks,

Stephen.

>Hi! I am using an Excel template to create another file.
>
> workbook = application.Workbooks.Open(templatePath);
>
> // Save the Excel workbook to the user''s file system before processing the nodes and the table of contents.
> workbook.Author = EnvironmentSettings.GetApplicationName();
> workbook.SaveAs(fileName);
>
>I followed your example to change the Author property on the workbook. I check the value of this property while the application is running and it shows what I expect. When I open the workbook and view the properties (File, Properties), the value that I expect is not there. I''ll appreciate if somebody knows the solution to this.

[Elsa]

FYI--This was fixed in version 4.2.