Exporting more than 26 columns from MPP to Excel skips Column Z and puts the data in column AA

Aspose.Tasks Product Family
1

Hi,

I am trying to use the GanttChartColumn to get the data exported to Excel file. The problem is that I have more than 25 columns to be exported. The Excel generated is skipping column Z and adding the data to Column AA. This is causing me further issues. Is this a registered bug? Do we have a solution to this issue?

var columns = new List
{
new GanttChartColumn(“Unique Task ID”, 50, Field.TaskUniqueID),
new GanttChartColumn(“Task Name”, 100, trimTaskNameConverter),
new GanttChartColumn(“Duration”, 100, durationConverter),
new GanttChartColumn(“Task Mode”, 50, Field.TaskManual),
new GanttChartColumn(“% Complete”, 50, Field.TaskPercentComplete),var columns = new List
{
new GanttChartColumn(“Unique Task ID”, 50, Field.TaskUniqueID),
new GanttChartColumn(“Task Name”, 100, trimTaskNameConverter),
new GanttChartColumn(“Duration”, 100, durationConverter),
new GanttChartColumn(“Task Mode”, 50, Field.TaskManual),
new GanttChartColumn(“% Complete”, 50, Field.TaskPercentComplete),

2

@abhargava

It appears that you are encountering an issue where exporting more than 25 columns from MPP to Excel results in data being placed in column AA instead of column Z. This behavior may be related to a known issue that has been tracked in the Aspose issue tracking system under the ID TASKSNET-3899.

The good news is that this issue has been addressed in a subsequent update. You can find the fix in the latest version of Aspose.Tasks for .NET, specifically in version 20.4. It is recommended to update to this version or later to resolve the problem you are experiencing.

If you continue to face issues after updating, please consider providing additional details about your implementation or any error messages you may be receiving, as this will help in diagnosing the problem further.

For more information on the update, you can refer to the release notes here.

Sources:
[1]: Field.OutlineCode not working when saving to xlsx

3

No. It is not related to this issue.

4

@abhargava,
we were able to reproduce the issue.
The following new ticket was opened in our internal issue tracking system. The fix will be delivered according to the terms mentioned in Free Support Policies.

Issue ID(s): TASKSNET-11347

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.