I am attempting to ouput an image of a worksheet. The Print_range defined in the excel file corresponds to a legal size sheet of paper. Printing to hardcopy works fine.
The image file that results is truncated however. I have tried experimenting with various combinations. Currently I use the following options settings
Dim options As New Aspose.Cells.Rendering.ImageOrPrintOptions()
options.HorizontalResolution = 200
options.VerticalResolution = 200
options.OnePagePerSheet = True
With x.Worksheets("Days").PageSetup
.PaperSize = PaperSizeType.PaperLetter
.Orientation = PageOrientationType.Landscape
.TopMargin = 0.25
.BottomMargin = 0.25
.LeftMargin = 0.25
.RightMargin = 0.25
.FitToPagesTall = 1
.FitToPagesWide = 1
End With
I get an image that appears more like it is formatted to a letter size piece of paper. Am interested in purchasing your product, but worry that this needed functionality (output to image) is not present
Well, Aspose.Cells for .NET will render images for the sheet based on the print preview (of MS Excel) that is shown in Ms Excel. Please either save the Excel file with your desired PageSetup options by Aspose.Cells or perform your required options in MS Excel manually to save the file, now take the preview of the sheet in MS Excel, it should be identical to your output image.
If you still feel that MS Excel’s preview is different than its output image, please attach your template file and output image here, we will check your issue soon and figure it out.
It looks strange to us as we could not find any issue and it works fine here.
What is your Display settings in “Appearance and Personalization” under control panel for your windows? Please use “100%” (default) settings if you are using any other settings.
Well, I am afraid, you have to set your Display settings to “100%” (default)" as Aspose.Cells will give you identical results, other settings might not always give you 100% similar and accurate results.