Excel 2003 Pie Chart labels locations are not preserved when converting to Excel 2007

Aspose.Cells Product Family
1

Hi,

We uncovered an issue related to pie charts saved in Excel 2003. The labels’ locations are not preserved when we are trying to save the file in Excel 2007 format.

The code we using is the following:

byte[] workbookContent; //we load the content of the Excel file
using (var stream = new MemoryStream(workbookContent))
{
var asposeDocument = new Workbook(stream);
var saveOptions = new OoxmlSaveOptions(SaveFormat.Xlsx) { RefreshChartCache = true };
asposeDocument.Save(@“c:\out.docx”, saveOptions);
}

The original Excel 2003 document is attached as in.xls. The resulting Excel 2007 document is out.xlsx.

Please note the locations of the labels are not kept after the conversion. For particular cell values the resulting locations might even overlap.

We are using Aspose.Cells 7.5.2.0.

Thank you,
Bogdan Ungureanu,
IBM Romania

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We were able to replicate this issue using the following code with the latest version. The lables locations are not preserved when the file is converted from xls to xlsx. We have logged this issue in our database. We will look into it and resolve 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-42001.

C#


string filePath = @“F:\Shak-Data-RW\Downloads<span class=“kwrd”>in.xls”;


Workbook workbook = new Workbook(filePath);

workbook.Save(filePath + “.out.xlsx”, SaveFormat.Xlsx);
Screenshot:
3

Hello,

Do you have any updates around this issue, or an estimate when this will be solved ?

Thank you,
Mihai Andrei
Sr Software Engineer
IBM Romania

4

Hi Mihai,

Thanks for your posting and using Aspose.Cells.

We are afraid, there is no update for you currently. However, we have logged your comment in our database and requested the development team to provide some ETA or update for this issue. Once, there is some news for you, we will let you know asap.