Missing text in labels

Aspose.Cells Product Family
1

Hi,

when I try to get an image from a chart in Excel, only parts of the labels are picked.
In the example, you will see that ‘Type…’ is missing.

Here is the code:

Aspose.Cells.License lic = new Cells.License();
lic.SetLicense(“Aspose.Total.lic”);
Workbook wb = new Workbook(“PivotCharts_V7.xlsx”);
string rangeName = “BIPLI_BorrowingPortfolioByCategory_VA”;
Worksheet excelWorksheet = wb.Worksheets[“Output”];

CellsHelper.DPI = 96;
Aspose.Cells.Range range = excelWorksheet.Workbook.Worksheets.GetRangeByName(rangeName);
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.OnePagePerSheet = true;
options.HorizontalResolution = 600;
options.VerticalResolution = 600;
options.OnlyArea = true;

Aspose.Cells.PageSetup pageSetup = excelWorksheet.PageSetup;
//set margins to zero.
pageSetup.LeftMargin = 0;
pageSetup.RightMargin = 0;
pageSetup.TopMargin = 0;
pageSetup.BottomMargin = 0;

pageSetup.PrintArea = rangeAddress;

SheetRender sr = new SheetRender(excelWorksheet, options);
sr.ToImage(0, “BIPLI_BorrowingPortfolioByCategory_VA.emf”);

here is the workbook
PivotCharts_V7.zip (32.6 KB)

Kind regards,
@Nachti

2

@Nachti
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-58123

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.