Hello
I have a problem with DataTable used in chart. When I convert the .xlsm file to .png the datatable in the chart on the first sheet draws on the wrong place.See attachment (ConvertedWith_7_1_1_5.png) version 7.1.1.5
If I try to do that in an older version from 5.3.2.0 see attachment (ConvertedWith_5_3_2_0.png) the table draws on the right place, but the conversion DateTime to "MMM" don´t work.
.Net Code:
protected void Page_Load(object sender, EventArgs e)
{
String filename = @"C:\Temp\Samlingsrapport_MS.xlsm";
//Define ImageOrPrintOptions
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
//Specify the image format
imgOptions.ImageFormat = System.Drawing.Imaging.
ImageFormat.Png;
//Only one page for the whole sheet would be rendered
imgOptions.OnePagePerSheet =
true;
Workbook asposeWorkbook = new Aspose.Cells.Workbook(filename);
Aspose.Cells.
Worksheet aspoWorksheet;
aspoWorksheet = asposeWorkbook.Worksheets[0];
SheetRender sr = new SheetRender(aspoWorksheet, imgOptions);
//Render the image for the sheet
Bitmap bitmap = sr.ToImage(0);
//Create Memorystream
MemoryStream OutputMemoryStream = new MemoryStream();
//Save the image file specifying its image format.
bitmap.Save(OutputMemoryStream,
ImageFormat.Png);
Response.ContentType =
"image/png";
OutputMemoryStream.WriteTo(Response.OutputStream);
Response.End();
}