Aspose.Cells - Copying Column Formula Creates a Corrupted Excel File

Aspose.Cells Product Family
, ,
1

Hi,

We are are using Aspose.Cells (NET), tried with both version 24.12.0 and 25.3.0. We’re trying to expand a column formula, by getting the first cell with the formula and pasting it to the rest of the column using the following code:
{
var cellToApply = column.Range[1, 0];
if (cellToApply is { Formula: { } })
column.Formula = cellToApply.Formula;
}

Then we calculate and save the workbook as xlsx. The resulting workbook we receive is corrupted, and recovery retrieves values instead of the formulas.
Can you help?

Thanks,
Oded Belahousky

2

@oded.b

It seems that you are encountering an issue with copying a formula in Aspose.Cells, which results in a corrupted Excel file. The code snippet you provided attempts to set the formula for an entire column based on a single cell’s formula. However, this approach may not be the best way to copy formulas across a column.

Instead of directly assigning the formula to the entire column, you should consider using the CopyColumn method, which is specifically designed for this purpose. This method copies all types of data, including formulas, from a source column to a destination column while updating references appropriately.

Here’s an example of how you can use the CopyColumn method:

// Load the existing workbook
Workbook workbook = new Workbook("path_to_your_file.xlsx");

// Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];

// Copy the formula from the first column (index 0) to the second column (index 1)
worksheet.Cells.CopyColumn(worksheet.Cells, 0, 1);

// Save the workbook
workbook.Save("path_to_your_output_file.xlsx");

In this example, the formula from the first column is copied to the second column, ensuring that all references are updated correctly. This should help you avoid the corruption issue you are experiencing.

If you still encounter problems, please ensure that the source workbook is not corrupted and that you are using the latest version of Aspose.Cells, as updates may contain important bug fixes and improvements.

Feel free to reach out if you have any further questions or need additional assistance!

3

@oded.b
Would you like to provide your sample file and runnable test code? We will check it soon.

4

ExcelCorrupter.7z (125.9 KB)

Attached a small program in C# containing a test file that gets corrupted.

5

@oded.b
By testing with sample files and code on the latest version v25.3, we can reproduce the issue. Copying column formula creates a corrupted excel file.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-58028

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

6

@oded.b,

We are pleased to inform you that your issue (Ticket ID: “CELLSNET-58028”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells v25.4) that we plan to release in the first half of April 2025. You will be notified when the next version is released.