Xlsm file and R1C1 reference style option

Aspose.Cells Product Family
1

Hi,


I try the demo Aspose.Cells .NET 7.1.2 with an xlsm file. All I did is open/save/close the file.
I use MS Excel 2007.

The original file have the Excel Options “R1C1 reference style” activated (see Excel Options, tab Formulas).
When I save the file with Aspose.Cells, this option is deactivated.

The problem is that the original file have number in column header. When the file is saved, the column header become letters.

Is there a reason or a way to avoid this?

Regards,
2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please download and use the latest version:
Aspose.Cells
for .NET v7.1.2.7
and let us know your feedback.

If the problem still occurs, then please provide us your source files and sample code to replicate this issue.

Please also provide us your screenshots and highlight the problems with red circles to illustrate your issue.

We will look into it and help you asap.

3

Hi,


Thanks for your help. I try the version 7.1.2.7. The problem is still there. I send you my file.

Here is my code sample :

Workbook wb = new Workbook(filename);
wb.Save(filename + “.out.xlsm”, SaveFormat.Xlsm);

Regards,
4

Hi,


Thanks for the template file and sample code.

I am able to notice the issue in Excel 2010 when I opened the generated file (by Aspose.Cells APIs) into it.

I have logged a ticket with an id: CELLSNET-40574. We will look into it soon.

Thank you.
5

Hi,

Please download and try latest version:

Aspose.Cells for .NET 7.2.0