Textbox missing after merging charts

Aspose.Cells Product Family
1

Hello,


we use Aspose.Cells for .NET to work on Excel-reports that contain charts and labels. One of the things we need to do is merging a number of charts to a new file.

This task worked well in previous versions of Cells. Unfortunately, using the most recent versions the Textboxes on the Charts are not visible in some cases.

I’ve included two sample files and a result file created here that shows the label on Chart 2 is not visible anymore. Additionaly I’ve added some code that shows that the Shape itself seems to be included in the file - but it’s not visible when you open the file in Excel.

Here is some code to merge the input files:

// Load template and remove all not needed worksheets
var chartNames = new string[] { “Chart 1”, “Chart 2” };
var template = new Workbook(@“C:\temp\Template.xlsx”);
var checkIndex = 0;

while (template.Worksheets.Count != chartNames.Length)
{
if (!chartNames.Contains(template.Worksheets[checkIndex].Name))
{
template.Worksheets.RemoveAt(checkIndex);
}
else
{
checkIndex++;
}
}

// merge files
var source = new Workbook(@“C:\temp\source.xlsx”);
source.Combine(template);

// save and close
source.Save(@“C:\temp\Result.xlsx”);
source.Dispose();
template.Dispose();

And here is some code to show that the shape is still in the file:

// Check - open result and lookup textbox
var result = new Workbook(@“C:\temp\Result.xlsx”);
var shapeText = result.Worksheets[“Chart 2”].Charts[0].Shapes[0].Text;

Console.WriteLine(shapeText); // Output: Mittelflüsse EUR % Sum %

2

Hi,


Thanks for providing us template file and sample code.

After an initial test, I observed the issue as you mentioned by using your sample code with your template files. I found that the Textboxes are missing after merging charts while combining workbooks. I have logged a ticket with an id “CELLSNET-45107” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

Thank you.
3

Hi again,


This is to inform you that the ticket logged earlier as CELLSNET-45107 has been marked resolved by the product team. We will shortly share the fix here after ensuring the quality and incorporating other enhancements.
4
Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.1.10 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.1.10 (.NET 4.0) compiled in .NET Framework 4.0.

and let us know your feedback.
5

The issues you have found earlier (filed as CELLSNET-45107) have been fixed in Aspose.Cells for .NET 17.2.0.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.