I try to convert a excel file to image. The file contains a calculated cell.
This cell doesn't render the calculated value when converting to image.
------
IApplication application = excelEngine.Excel;
IWorkbook workbook = application.Workbooks.Open(filePath);
int startRangeRow = sheet.UsedRange.Row;
int startRangeColumn = sheet.UsedRange.Column;
int endRangeRow = sheet.UsedRange.LastRow;
int endRangeColumn = sheet.UsedRange.LastColumn;
Image image = sheet.ConvertToImage(startRangeRow, startRangeColumn, endRangeRow, endRangeColumn, ImageType.Metafile, null);
-------
Version of XlsIO.Base : 15.1400.0.41
Attachment:
test_9e70abe5.zip