Aspose Cell- ToImage function generating extra column in generated image

Aspose.Cells Product Family
7

Hi,

Normally, the fix takes 2~3 working days. If it is a difficult to resolve, it can take a week or two.

Please post your other problems with images, so that we could also look into them and fix them.

8

Hi,


I will send you some compared images soon.

Stay tuned.

Thanks,
Nakul
9

Hi,


Please let me know when I will get fix for extra column in image.

Meanwhile I am in process of sending image comparison for font and style.

-Nakul

10

Hi ,


Please find attached document for comparison of font style in images generated by word and aspose.

Let me know if you need any details.

Note: Excel sheets are embedded inside word doc.

After double click in aspose generated doc, images are generated by MS word

Thanks and Regards,
Nakul


11

Hi,

Thanks for your files.



Please highlight the problems with red circles in a screenshot.

12

Hi,

Please try the latest version:
Aspose.Cells for .NET v7.0.3.6

There is extra space left in the right because the text in the cell U3 exceeds the column.

Please let us know how did you generate a file and also we do not know your last requirement. Can you please elaborate it?

13

Hi Faiz,


Please find attached file for comparisons.

In new version one extra column is generated and also grid lines are changed

Thanks and Regards,
Nakul


14

Hi,

Thanks for your files.

As I mentioned earlier, there is extra space left in the right because the text in the cell U3 exceeds the column. Therefore it needs more space when you will take its image.

If you do not want this extra column, please set CellU3 style to wraptext.

15

Hi Faiz,


If you see image in grid this is an extra column, not free space as you are telling.

Thanks and Regards,
Nakul
16

Hi,

In our internal code, if text exceeds its own column, the text needs extra right column or columns to show all text. You can adjust right column width to see it.

17

Hi Faiz,


Any updated from your side for this issue.

Thanks and Regards,
Nakul
18

Hi,

I will update you soon after some testing.

19

Hi Nikul,

Please read our replies at the following posts: 349460 and 349497 we think our results are correct.

Please remove the text in U3 and see the difference.

20

Hi Faiz,


I have checked with dll provided by you.

1) Extra column is not generated but grid lines are changed as I mentioned in last post.
Now it is showing dotted line.

2) As well compare attached the given output file by word and aspose generated file for font weight difference.

I changed image out put to .emf file as word dose.

Please let me know if you need more details.

Thanks and Regards,
Nakul
21

Hi,

We output the dashed line the same as Excel print preview.

We do not understand your second question.

Please create screenshots and highlight problems with red circles.

22

Hi Faiz,


Please find sample images (in word document) marked for comparison.

Thanks and Regards,
Nakul


23

Hi,

Thanks for highlighting the differences. We will look into them and fix them if possible and update you asap.

24

Hi,

The font issue is because Aspose.Cells generate font using .NET framework API(s) so the font weight cannot be controlled.

There is a way to control font weight by unmanaged API(s) by Win32 GDI, but we cannot use unmanaged code in our product.

Thanks for your understanding.

25

Hi Faiz,


I checked the solution provided by you for eliminating extra white space generated in image.

But it is howing the hidden column which are at end and does not contain any data in image as white space.

Could you please check attached excel sheet and image which has white space due to hidden column.

Thanks and Regards,
Nakul
26

Hi,

The image looks fine to me. Please see the sample code below and the output emf image.

Please use the latest version:
Aspose.Cells
for .NET v7.0.4.4


C#


string path = @“F:\Shak-Data-RW\Downloads\test\v7030\ooxmlPackage2.xlsx”;

Workbook workbook = new Workbook(path);


Worksheet worksheet = workbook.Worksheets[0];


//Apply different Image / Print options.

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

options.OnePagePerSheet = true;

options.ImageFormat = ImageFormat.Emf;


SheetRender sr = new SheetRender(worksheet, options);


Bitmap bitmap = sr.ToImage(0);


bitmap.Save(path + “.out.emf”, ImageFormat.Emf);