WRAPCOLS Excel function

We are considering purchasing a new Aspose Cells license but one of the functions we would need is the WRAPCOLS function which is not currently supported. Are there any plans to add support for this?

@LPyrah

Cause

Currently, the WRAPCOLS function is not supported in Aspose.Cells. This limitation may impact your use case, especially if you rely on this function for your Excel operations.

Solution

While there is no direct support for the WRAPCOLS function at this time, you can achieve similar functionality by manually implementing the logic in your code. You can create a custom function that mimics the behavior of WRAPCOLS by manipulating the data in your workbook.

Code

Here’s a basic example of how you might implement a custom wrapping logic using Aspose.Cells:

using Aspose.Cells;

public void WrapColumns(Workbook workbook, int startColumn, int wrapCount)
{
    Worksheet worksheet = workbook.Worksheets[0];
    int rowCount = worksheet.Cells.MaxDataRow + 1;

    for (int row = 0; row < rowCount; row++)
    {
        for (int col = startColumn; col < startColumn + wrapCount; col++)
        {
            Cell cell = worksheet.Cells[row, col];
            if (cell.Value != null)
            {
                // Logic to wrap the cell value as needed
                // For example, you can concatenate values or adjust cell formatting
            }
        }
    }
}

Next Steps

  1. Implement the custom wrapping logic in your application.
  2. Test the functionality to ensure it meets your requirements.
  3. Monitor future updates from Aspose, as new features and functions are regularly added based on user feedback.

If you have any further questions or need additional assistance, please feel free to ask!

@LPyrah,

Aspose.Cells does not support WRAPCOLS formula/function. 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-58691

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.