Hello I’m using your library for a long time. And I didn’t have any issues with documents in my buisness logic. I used your library in couple with MagickImage. And I encountered on file that renders corrupted .png. It can be opened with any viewer but MagickImage library can’t work with it because it has extra incorrect IDAT chunk. More detailed explanation is here
https://magick.codeplex.com/discussions/651973For testing purpose I wrote this code snippet(if you need I will able to send you that library, but you can check this issue just by opening Page6.png). So Page6.png that will generate this logic will have extra data. ONLY this page. I don’t know what is the reason. Also I attached that XLS file.
try
{
var lic = new License();
lic.SetLicense(“Aspose.Total.lic”);
var options = new ImageOrPrintOptions();
options.HorizontalResolution = 100;
options.VerticalResolution = 100;
options.ImageFormat = System.Drawing.Imaging.ImageFormat.Png;
options.OnlyArea = true;
options.Quality = 100;
var _xlsDocument = new Workbook(“test.xlsx”);
var workSheet = _xlsDocument.Worksheets[0];
int maxRow = workSheet.Cells.MaxDataRow > workSheet.Cells.MaxRow ? workSheet.Cells.MaxDataRow : workSheet.Cells.MaxRow;
int maxColumn = workSheet.Cells.MaxDataColumn > workSheet.Cells.MaxColumn ? workSheet.Cells.MaxDataColumn : workSheet.Cells.MaxColumn;
workSheet.PageSetup.PrintArea = String.Format("{0}:{1}", “A1”, workSheet.Cells[maxRow, maxColumn].Name);
workSheet.PageSetup.TopMargin = workSheet.PageSetup.BottomMargin = workSheet.PageSetup.LeftMargin = workSheet.PageSetup.RightMargin = 0;
workSheet.PageSetup.PrintTitleColumns = workSheet.PageSetup.PrintTitleRows = null;
workSheet.PageSetup.FitToPagesTall = workSheet.PageSetup.FitToPagesWide = 0;
var sheetRender = new SheetRender(workSheet, options);
for (int pageIndex = 0; pageIndex < sheetRender.PageCount; pageIndex++)
{
sheetRender.ToImage(pageIndex, “Page” + pageIndex + “.png”);
new MagickImage(“Page” + pageIndex + “.png”); //this row can be deleted;
}
}
catch (Exception ex)
{
}