Missing numbers when creating Image from Excel

Hi,

I use following code and Aspose version (22.5.0.0) to create an image:

xlsLic.SetLicense(“Aspose.Total.lic”);

        Workbook w3 = new Workbook("Data Cache_V1.xlsx");
        Worksheet excelWorksheet = w3.Worksheets["FOREX"];
        Aspose.Cells.Range range = excelWorksheet.Workbook.Worksheets.GetRangeByName("BIPLI_graphforex");
        string startCell = CellsHelper.CellIndexToName(range.FirstRow, range.FirstColumn);
        string endCell = CellsHelper.CellIndexToName(range.FirstRow + range.RowCount - 1, range.FirstColumn + range.ColumnCount - 1);
        string rangeAddress = string.Format("{0}:{1}", startCell, endCell);

        ImageOrPrintOptions options = new ImageOrPrintOptions();
        options.AllColumnsInOnePagePerSheet = true;
        options.ImageType = Aspose.Cells.Drawing.ImageType.Emf;
        //options.ImageFormat = ImageFormat.Emf;
        options.OnePagePerSheet = true;
        options.HorizontalResolution = 600;
        options.VerticalResolution = 600;
        options.OnlyArea = true;

        Aspose.Cells.PageSetup pageSetup = excelWorksheet.PageSetup;


        pageSetup.PrintArea = rangeAddress;
        using (MemoryStream imageStream = new MemoryStream())
        {
            SheetRender sr = new SheetRender(excelWorksheet, options);
            sr.ToImage(0, imageStream);
            Image.FromStream(imageStream).Save("graphforex.png", ImageFormat.Emf);
            
        };

Here the document: Data Cache_V1.zip (35.3 KB)

Two issues:
The numbers above the blue bars are missing.
The numbers for ‘d’ and ‘e’ are positioned properly. They should not hit the bottom line.

Kind regards,
@Nachti

@Nachti,

Thanks for the template file and details.

Please notice, I am able to reproduce the issue as you mentioned by using your template file. I found/confirmed the issue(s) regarding missing numbers when creating image from MS Excel chart:

The numbers above the blue bars are missing.
The numbers for ‘d’ and ‘e’ are positioned properly. They should not hit the bottom line

I have logged a ticket with an id “CELLSNET-51211” for your issue. We will look into it soon.

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

@Nachti,

We are pleased to inform you that your issue has been resolved. The fix will be included in the next (upcoming) release (Aspose.Cells for .NET v22.6) which is scheduled before the end of this week or so. You will also be notified when the next version is published.

The issues you have found earlier (filed as CELLSNET-51211) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

The issues you have found earlier have been fixed in this update. If you have downloaded the prior one(22.6.0), please use this update to replace the downloaded one because 22.6 has a bug which sometimes may cause generated file corrupted.