Convert worksheet To Image - Image not Rendered well

Aspose.Cells Product Family
6

Hi Amjad,

Can you please give us a tentative date or a status update for this fix.

This will help me set expectations with the client appropriately. The client is waiting on us to implement the fixes ASAP.

A Quick reply will be of great help. Thank you.

7

Hi,


I am afraid the issue is not resolved yet. You may try our latest version: Aspose.Cells for .NET v7.0.3.6 in which we made further improvements but your issue might be not be fully resolved. Once we have any update we will share it here. If it takes longer time, we will try to provide you the eta for it.

Thank you.

8

Hi,

We are fixing the issues you mentioned and will provide a fix before next Friday.

9

Hi,

We understand that you have provided an ETA for this issue .but we are deadlock in this situation as without fixing the issue we don't find our project going ahead. Kindly look into this issue asap, without fixing this issues , its hard to fit aspose.cells in our project. Kindly do the needful.

Thanks.

10

Hi,

I have requested the development team to fix this issue as early as possible. I have also logged your comment in our database. Hopefully, the issue will be fixed soon.

11

Hi,

We have fixed this issue. Please download: Aspose.Cells for .NET v7.0.4.2

12

Hi,

This DLL has not fixed all issues, can you please tell us if they all showed fixed at your end.

13

Hi,


Could you give us your input Excel file and output image(s) to show the issue with sample code. Also, give us screen shots to show the problematic areas with red color. We will check it soon.

Thank you.
14

Hi PFA the Input Excel and the Images attached. Have also attached the Screenshots for your reference and have highlighted the Areas with red which describes the actual problem.Appreciate your help.

Thanks,

Abdul R Sha.

15
Hi,

Thanks for the files.

I can find the issues using your new template file as mentioned in your attached docx file ("ExcelIssuesScreenshots.docx"-screen shots).

Sample code:

Aspose.Cells.Workbook book = new Aspose.Cells.Workbook("e:\\test2\\ExcelIssuesJan2.xlsx");

Aspose.Cells.Worksheet sheet;

Aspose.Cells.Rendering.ImageOrPrintOptions imgOptions;

Aspose.Cells.Rendering.SheetRender sr;

Bitmap bitmap;

string number = "";

string[] name = new string[100];

imgOptions = new Aspose.Cells.Rendering.ImageOrPrintOptions();

for (int i = 0; i < book.Worksheets.Count; i++)
{

sheet = book.Worksheets[i];

imgOptions.HorizontalResolution = 118;

imgOptions.VerticalResolution = 112;

imgOptions.OnePagePerSheet = true;

imgOptions.IsImageFitToPage = true;

imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Tiff;

sr = new Aspose.Cells.Rendering.SheetRender(sheet, imgOptions);

if (i < 10)
{

number = "00" + i.ToString();

}

else if (i >= 10 && i < 100)
{

number = "0" + i;

}

else
{

number = i.ToString();

}

bitmap = sr.ToImage(0);

bitmap.Save("e:" + "\\test2\\convv\\qsheetimage" + sheet.Index + number + ".tiff");

}

I have reopened your issue now, we will look into it soon.

Thank you.
16

Hi,

Our Project is going Live on 23rd jan.So i request you to Solve the issue before jan 16th. And We need a confirmation that this Chart to image rendering issues will not repeat again with the fix you provided with the templates that we shared. also we need some more clarifications on the topics listed below.
i) What is the root cause of the Chart issues which was not rendered properly in the images.
ii) Is the Chart to image issues feasible or not ?

So its always better to fix the issue before this date(Jan16th) so that we have some time to test and validate the results and appropriately come back to you if it has some more unexpected bugs after this Fix.Appreciate your help.

Thanks.
17

Hi,


I have asked the concerned developer to update on the issues. We will get back to you in the early next week. Also, we will clarify about your concerns.

Thank you.
18

Thank you Amjad,

Our intention in understanding the root cause for all these issues is to make sure these issues will not repeat for similar templates created in future. Please confirm.

19
Hi,

Please try the latest version/fix v7.0.4.8.

We solved number of issues you mentioned and the others are not supported now. You may modify the template file to generate better results.

See the attachment for your reference.
20

Hi ,

We tried using your new dll.(7.1.0.0). though it solved some issues it created new issues.PFA the image file for more details. An extra date part getting added to the bottom of the image.This issue really stops our implementation plan.so kindly resolve it as soon as possible.And kindly provide the root cause for the issues that you fixed. we desparately need the root cause of the issues that were fixed.Kindly do the needfull.

21

Hi ,


We haven’t got any updates from you on the issue. Kindly look into it.

Thanks,
Abdul R Sha.
22

Hi,

I have logged your comments against the issue id: CELLSNET-40150 and reopened the issue.

Development team will investigate it and we will provide you update asap.

23

Hi,

We are now facing some more number of issues compared to previous ones.The Issues has been listed out here.

Attachments:InputExcel,Images(1.zip)- InputExcel is converted to images.

Issues:

1)Left alignment of the text in the image,whereas the text is right aligned in the Input Excel.

2)Incorrect format of X-axis in some charts.

3)Xaxis values appear in the middle of chart , Images attached for reference.

4)x-axis values getting trimmed ,Some of the x-axis values disappear in the image.

5)Unwanted date and additional text in the bottom of the image.

For all these issues images has been attached and the issue area is highlighted to describe the issue in detail.kindly look into the issues soon.

Thanks,

Abdul R Sha

24

Hi,

Thanks for your posting and feedback.

We have logged your provided information/issues in our database against the issue id: CELLSNET-40150

We will look into them and once we will have a fix or update for you, we will let you know asap.

25

Hi,.

Please download the fix:
Aspose.Cells
for .NET v7.1.0.4

We fixed the issues of charts.

If you use sheet2image feature, the generated images is same as excel print feature. As the template excel file has footer, you must get rid of it

Print->Print preview->Page setup->Header/Footer->Footer->Select none