Large textbox is printed incorrectly when printing whole workbook

Aspose.Cells Product Family
1

Print attached document using WorkbookRender class will print the large textbox in first sheet on both first and second sheets.

If print using SheetRender to print sheet by sheet, it will print out correctly.

2

Hi,

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

We are unable to reproduce this issue with the latest version:
Aspose.Cells for .NET v7.0.2.7

3

I have tried both 7.0.2.7 and .7.0.3.0 but I still have this problem. The textbox is printed on both first and second page.

Code as bellow:
var workbook = new Workbook(docPath);
var options = new ImageOrPrintOptions();
options.ImageFormat = ImageFormat.Tiff;
options.PrintingPage = PrintingPageType.Default;
options.PrintWithStatusDialog = false;

var wr = new WorkbookRender(workbook, options);
wr.ToPrinter(printerName);



4

Hi,

Please let us know your .NET framework version and please also let us know if you are using ClietProfile version of .NET framework.

Please also highlight your problem with red circles in a screenshot. We will look into it and help you asap.

5

Hi,

Application is .Net4 and I am using 3.5 ClientProfile version of Aspose.Cell

I have added a screen shot for the secondsheet, with the textbox red circled.

6

Hi,

Since, you are using ClientProfile version of .NET framework, so please use the DLL under the directory “net3.5_ClientProfile” and not “net2.0”.

And please check the readme.txt under the directory
“Bin”.

7

Hi,

I have tried the following:

1. my application .net 4 client profile and using aspose .net 3.5 clientprofile dll
2. my application .net 4 full and use aspose .net2.0 dll
3. my application .net 4 full and use aspose .net3.5 client profile dll

none of them works.

8

Hi,

Your second option is correct. I have generated the images using Aspose.Cells for .NET v7.0.3.0, the are coming fine.

Please see the code below. Will you please try it using the

2. my application .net 4 full and use aspose .net2.0 dll

C#


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


//open a template excel file.

Workbook book = new Workbook(path);


ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();

imgOptions.OnePagePerSheet = true;


int i = 0;

foreach (Worksheet worksheet in book.Worksheets)

{

SheetRender sr = new SheetRender(worksheet, imgOptions);


Bitmap bitmap = sr.ToImage(0);


bitmap.Save(path + i + “.out.jpg”, ImageFormat.Jpeg);

i++;

}

9

Hi,


After analysis, we think, it works fine when you convert the workbook to image files, but it does not work fine when you do the printing. We have logged a ticket with an id: CELLSNET-40093. We will fix the issue soon.

Thank you.
10

Hi,

Thanks for the reply, it works fine if I am processing it page by page, but will have problem if I use WorkbookRender like I said in the first post.


11

Hi,


Yes, sure, we will fix the issue regarding WorkbookRender. Once we figure it out, we will let you know here.

Thank you.
12
Hi,

Please try our latest version/fix: v7.0.3.2. Your issue should be resolved now.

Thank you.