We're sorry Aspose doesn't work properply without JavaScript enabled.

# Formula gets broken while copying to 512nd column

Hi.

Using Aspose cells, we are facing an issue that the formula gets broken while copying columns to the 512nd column of the sheet.

How to reproduce:

1. In Excel sheet, put value 1 in cell SN3 and cell SN4, and formula "=SUM(SN3:SN4)" in cell SN5.

2. Save the workbook with extention xlsx.

3. Open the workbook from C# program and call CopyColumns method as below:
cells.CopyColumns(cells, 507, 508, 1);
cells.CopyColumns(cells, 507, 509, 1);
cells.CopyColumns(cells, 507, 510, 1);
cells.CopyColumns(cells, 507, 511, 1);
cells.CopyColumns(cells, 507, 512, 1);
cells.CopyColumns(cells, 507, 513, 1);
cells.CopyColumns(cells, 507, 514, 1);

4. Save the workbook.

Formula in cell SN5 is "=SUM(SN3:SN4)" as expected.
Formula in cell SO5 is "=SUM(SO3:SO4)" as expected.
Formula in cell SP5 is "=SUM(SP3:SP4)" as expected.
Formula in cell SQ5 is "=SUM(SQ3:SQ4)" as expected.
Formula in cell SR5 is "=SUM(SR3:SR4)" as expected.
Formula in cell SS5 is "=SUM(SS3:ACO4)", whereas we expect "=SUM(SS3:SS4)"
Formula in cell ST5 is "=SUM(ST3:ACP4)", whereas we expect "=SUM(ST3:ST4)"
Formula in cell SU5 is "=SUM(SU3:ACQ4)", whereas we expect "=SUM(SU3:SU4)"

Is there any way we can avoid this issue?

Hi Daisuke,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing the following sample code with the sample Excel file which is attached with this post using the latest version: Aspose.Cells for .NET 8.2.2. Formula gets broken while copying to 512th column.

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-43104.

I have also attached the output Excel file and screenshot highlighting this issue for a reference.

C#

Workbook workbook = new Workbook(filePath);

Cells cells = workbook.Worksheets.Cells;

cells.CopyColumns(cells, 507, 508, 1);

cells.CopyColumns(cells, 507, 509, 1);

cells.CopyColumns(cells, 507, 510, 1);

cells.CopyColumns(cells, 507, 511, 1);

cells.CopyColumns(cells, 507, 512, 1);

cells.CopyColumns(cells, 507, 513, 1);

cells.CopyColumns(cells, 507, 514, 1);

workbook.Save(filePath + “.out.xlsx”);

Hi Daisuke,

Thanks for using Aspose.Cells.

We have fixed
this issue now. We will provide you a fix in couple of days after
incorporating other enhancements and fixes and conducting some extensive
testing. Once, it is available for you, we will let you know asap by