Aspose cell: ToTiff function Issues (Extended)

shakeel.faiz · March 1, 2013, 3:28am

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have fixed the issues.

Please download and try this fix: Aspose.Cells for .NET v7.4.1.1 and let us know your feedback.

amjad.sahi · March 8, 2013, 7:55am

Hi,

Please try the attached fix/version: Aspose.Cells for .NET v7.4.1.2, we have fixed the issue logged as “CELLSNET-41440”.

Thank you.

amjad.sahi · March 8, 2013, 8:10am

Hi,

Please also try the fix Aspose.Cells for .NET v7.4.1.2

We have also solved the issues: “2. Chart axis labels are not correct in
generated Image (02-Charts in Excel sheet.rar)”.

Thank you.

rbroomehostanalytics · March 14, 2013, 5:10am

Hi Amjad,

Few more issues in image generation.

7. Image output is not in sync with excel print preview page output.

8. Hidden rows are visible in generated image

9. Columns are repated and last column data is lost in generated image.

10. Backgroud color is not visible in generated image.

You can find generated images and input excel sheets in attached zip files.

Thanks,

Nakul

amjad.sahi · March 14, 2013, 8:05am

Hi,

Thanks for the sample files and details.

rbroome@hostanalytics.com:

7. Image output is not in sync with excel print preview page output.

I can notice the issue as you have mentioned. The image output is not in matched with MS Excel's print preview page output.

Sample code:

//Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\07-Page Output Mismatch\ExcelSheet.xlsx");
//Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\08-Hidden Rows Visible in image\Host_2012_Events_analysis_-_Dental_Live_P11.xlsx");
//Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\09-Column Repeated\03-LossOfData.xls");
Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\10-Model Backroundcolor not displayed- Page mismatch\ExcelSheet.xls");

Worksheet sheet = workbook.Worksheets[0];

ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Tiff;
imgOptions.VerticalResolution = 200;
imgOptions.HorizontalResolution = 200;

SheetRender sr = new SheetRender(sheet, imgOptions);

for (int j = 0; j < sr.PageCount; j++)
{
sr.ToImage(j, @"E:\test2\aspose.cells totiff\10-Model Backroundcolor not displayed- Page mismatch\wsheettiff" + j.ToString() + ".tiff");

}

I have logged a ticket with an id "CELLSNET-41483" for your issue. We will look into it soon.

rbroome@hostanalytics.com:

8. Hidden rows are visible in generated image

I can notice the issue as you have mentioned. The hidden row/data is visible in the output image.

Sample code:

//Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\07-Page Output Mismatch\ExcelSheet.xlsx");
//Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\08-Hidden Rows Visible in image\Host_2012_Events_analysis_-_Dental_Live_P11.xlsx");
//Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\09-Column Repeated\03-LossOfData.xls");
Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\10-Model Backroundcolor not displayed- Page mismatch\ExcelSheet.xls");

Worksheet sheet = workbook.Worksheets[0];

ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Tiff;
imgOptions.VerticalResolution = 200;
imgOptions.HorizontalResolution = 200;

SheetRender sr = new SheetRender(sheet, imgOptions);

for (int j = 0; j < sr.PageCount; j++)
{
sr.ToImage(j, @"E:\test2\aspose.cells totiff\10-Model Backroundcolor not displayed- Page mismatch\wsheettiff" + j.ToString() + ".tiff");

}

I have logged a ticket with an id "CELLSNET-41484" for the issue. We will look into it soon.

rbroome@hostanalytics.com:

9. Columns are repated and last column data is lost in generated image.

I could not find the issue, it works as per the print preview shown in MS Excel. I think as there are Rows to repeat at top and Columns to repeat at left settings are set (you may check it opening the PageSetup dialog box and click on Sheet tab) , also the printable area is set with a range here. So, it works as per these settings and print preview shown in MS Excel. If you still find any difference or issue, kindly give us screen shots to highlight the problematic areas comparing the images with MS Excel print preview, we will check it soon.

rbroome@hostanalytics.com:

10. Backgroud color is not visible in generated image.

I can notice the issue as you have mentioned. The background color for some cells in the second page is shown in the generated image.

Sample code:

//Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\07-Page Output Mismatch\ExcelSheet.xlsx");
//Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\08-Hidden Rows Visible in image\Host_2012_Events_analysis_-_Dental_Live_P11.xlsx");
//Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\09-Column Repeated\03-LossOfData.xls");
Workbook workbook = new Workbook(@"E:\test2\aspose.cells totiff\10-Model Backroundcolor not displayed- Page mismatch\ExcelSheet.xls");

Worksheet sheet = workbook.Worksheets[0];

ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Tiff;
imgOptions.VerticalResolution = 200;
imgOptions.HorizontalResolution = 200;

SheetRender sr = new SheetRender(sheet, imgOptions);

for (int j = 0; j < sr.PageCount; j++)
{
sr.ToImage(j, @"E:\test2\aspose.cells totiff\10-Model Backroundcolor not displayed- Page mismatch\wsheettiff" + j.ToString() + ".tiff");

}

I have logged a ticket with an id "CELLSNET-41485" for the issue. We will look into it soon.

Once we have any update on any of your pointed issues, we will let you know here.

Thank you.

shakeel.faiz · March 18, 2013, 2:36am

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have fixed the issues. (i.e CELLSNET-41483, CELLSNET-41484, CELLSNET-41485)

Please download and try this fix: Aspose.Cells for .NET v7.4.1.3 and let us know your feedback.

aspose.notifier · March 25, 2013, 2:40am

The issues you have found earlier (filed as CELLSNET-41440;CELLSNET-41485;CELLSNET-41484;CELLSNET-41483;CELLSNET-41442;CELLSNET-41439;CELLSNET-41437) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.

rbroomehostanalytics · April 4, 2013, 7:14am

Hi Team,

I rechecked all issue with latest Aspose Cell version 7.4.2.0. Used same data for testing

Issue Number #

01. Resolved .

02. Still there is mismatch with Excel Print Preview.

03. Resovled.

04. Partially fixed . Line quality is not same as excel print preview. You can see it clearly in output #4.

05. Header footer issue is fixed. Cloumn data is mismatchin with excel print privew output.

06.Resovled.

07. Partially fixed: Data is flowing out of cell.

08. resolved

09. Data is issue is not resolved.

10. backgroud color issue resolved. Still image is not same as excel print preview.

NEW ISSUE:

11- FONT mismatch in generated image.

Please find attached zip for issue #4 and new issue #11.

-Nakul

shakeel.faiz · April 4, 2013, 9:36pm

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

After initial investigation, we found this issue. We have logged these issues in our database. We will look into them and resolve them. Once the issues are resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41546 (Font Mismatch) and CELLSNET-41545 (Dotted Line Issue).

For your other issues, please create separate thread for each of your issue. It will help us sort out your issue easily.

rbroomehostanalytics · April 19, 2013, 2:16am

Hi Team,

Let me know estimated time to fix open issues out of 11 issues.

This issue is blocking our work.

Thanks and Regards,
Nakul

rbroomehostanalytics · April 19, 2013, 2:18am

As well I am not able to reply to original post too...

<A href="</A> There are 3 unresolved issues in this. Let me know when i will get fix for this also. -Nakul

shakeel.faiz · April 22, 2013, 7:57am

rbroome@hostanalytics.com:
Hi Team,

I rechecked all issue with latest Aspose Cell version 7.4.2.0. Used same data for testing

Issue Number #

01. Resolved .

02. Still there is mismatch with Excel Print Preview.

03. Resovled.

04. Partially fixed . Line quality is not same as excel print preview. You can see it clearly in output #4.

05. Header footer issue is fixed. Cloumn data is mismatchin with excel print privew output.

06.Resovled.

07. Partially fixed: Data is flowing out of cell.

08. resolved

09. Data is issue is not resolved.

10. backgroud color issue resolved. Still image is not same as excel print preview.

NEW ISSUE:

11- FONT mismatch in generated image.

Please find attached zip for issue #4 and new issue #11.

-Nakul

Hi,

Thanks for your posting and using Aspose.Cells.

We have checked your issues. Following are the detail about them.

1 First issue is resolved

2 Chart data does not match with Excel print preview.

3 This issue is resolved too.

4 We have already logged this issue.

5 Header footer issue is fixed. Could you highlight the column mismatching issue?

6 This issue is resolved too.

7 Data is flowing out of the cell. This issue needs to be fixed.

8 This issue is resolved too.

9 Please check this comment about issue number 9

https://forum.aspose.com/t/97617

10 Could you highlight the issue for us. It seems fine.

11 This issue is already logged.

amjad.sahi · April 28, 2013, 12:51pm

Hi,

Please try our latest fix/version: Aspose.Cells for .NET v7.4.3.1

We have fixed your issues regarding y-axis scaling charts (“CELLSNET-41438

”).

Let us know your feedback.

Thank you

NakulKapadia · May 23, 2013, 8:00am

Hi Amjad,

I have found few more issue in v7.3.4.1.

They are as below. Please find attached zip for reference

#1. 3D effect of chart is missing.

#2. Loss of legend data in chart

#3. X-Axis label are not proper

#4. Incorrect label data, garbage labels are displayed.

#5. Legend order is not in sync with excel print preview

The file name contains issue number from above list.

Please let me know of you need any information.

amjad.sahi · May 23, 2013, 9:00am

Hi,

Thanks for providing us the template file and output images and other screen shots for your mentioned issues.

1)

I am afraid, we do not support the 3D effects of charts in the rendered images. We will check if we could support this feature, it always converts the 3D effects into 2D for charts. I have logged a ticket with an id “CELLSNET-41714” for it and we will look into it. If we have any update on it, we will let you know about it here.

2) & 5)

I have seen the following issues after converting your charts in the template file’s sheet to image files:

#2. Loss of legend data in chart
#5. Legend order is not in sync with excel print preview

Sample code:

string filePath = @“E:\test2\aspose.cells_totiff2\Issue-Data\Input.xls”;
Workbook workbook = new Workbook(filePath);
Worksheet worksheet = workbook.Worksheets[“Headcount Report”];
Chart chart1 = worksheet.Charts[0];
Chart chart2 = worksheet.Charts[1];

chart1.ToImage(@“E:\test2\aspose.cells_totiff2\Issue-Data\first.out.jpg”, ImageFormat.Jpeg);
chart2.ToImage(@“E:\test2\aspose.cells_totiff2\Issue-Data\two.out.jpg”, ImageFormat.Jpeg);

I have logged a ticket with an id “CELLSNET-41715” for it and we will look into it. If we have any update on it, we will let you know about it here.

3) & 4)

I can observe the following issues after converting the charts to image files:

#3. X-Axis label are not proper
#4. Incorrect label data, garbage labels are displayed.

Sample code:

string filePath = @“E:\test2\aspose.cells_totiff2\Issue-Data\Input.xls”;
Workbook workbook = new Workbook(filePath);
Worksheet worksheet = workbook.Worksheets[“Headcount Report”];
Chart chart1 = worksheet.Charts[0];
Chart chart2 = worksheet.Charts[1];

chart1.ToImage(@“E:\test2\aspose.cells_totiff2\Issue-Data\first.out.jpg”, ImageFormat.Jpeg);
chart2.ToImage(@“E:\test2\aspose.cells_totiff2\Issue-Data\two.out.jpg”, ImageFormat.Jpeg);

I have logged a ticket with an id “CELLSNET-41716” for it and we will look into it. Once we have any update on it, we will let you know here.

Thank you.

amjad.sahi · June 28, 2013, 5:07am

Hi,

Please download and try this fix: Aspose.Cells for .NET v7.5.0.4

We update the axis’s label issues. If you open the source file with Excel 2007 or later versions, so the generated chart would be very different with Excel. If you open it in Excel 2003, the result would be same as Excel.

Please check the attachment. For your information, we try to make XLS to be same as Excel 2003 and XLSX as Excel 2007. Also, the 3D effects / styles in the charts are not supported now, we may support it later on.

Thank you.

aspose.notifier · January 13, 2014, 8:26pm

The issues you have found earlier (filed as CELLSNET-41438) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

aspose.notifier · May 19, 2015, 4:02am

The issues you have found earlier (filed as CELLSNET-41716) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

shakeel.faiz · May 28, 2015, 1:36am

Hi,

Thanks for using Aspose.Cells.

For your issue CELLSNET-41546, please download and try the latest fix: Aspose.Cells
for .NET v8.4.2.2 and let us know your feedback.

The used fonts in source excel file should be installed or using CellsHelper.FontDir to set the used font dir to get a similar view as excel does.(In the your source excel file, the used fonts are Tms Rmn Regular and Tms Rmn Bold).

shakeel.faiz · September 8, 2015, 11:24pm

Hi,

Thanks for using Aspose.Cells.

For your issue

CELLSNET-41483 - ToTiff function Issue - Image output is not in sync with Excel print preview page output

Please download and try the latest fix: Aspose.Cells
for .NET v8.5.2.2 and let us know your feedback.