Excel file display as like A4 papers. Sheets are looking different

GroupDocs.Viewer Product Family
,
1

Hello,

In our .Net Project with Groupdocs Viewer. Customers upload excel files but the expected images are different. Can I make it more similar to display like opened in Microsoft Excel Program?

Im gonna attach photos to show how it looks like and Im adding the project too.

Thank you!

.NetGroupdocsProject-Issue1.PNG (173.3 KB)

ExcelPhoto.PNG (129.1 KB)

GroupDocsViewerNetProjectCode.zip (144.0 KB)

Excel File AS Zip:
Mail ve Bildirim Textler v2 (3).zip (9.8 KB)

2

@caglaraydogan

To render a spreadsheet similar to how you see it in Excel (one-page-per-sheet.png) use the following code

config.ConfigureHtmlViewOptions(viewOptions =>
{
    viewOptions.SpreadsheetOptions = SpreadsheetOptions.ForOnePagePerSheet();
});

In addition, there are a couple of ways to render worksheets:

  1. Split worksheet by page breaks
  2. Split worksheet by rows
  3. Split worksheet by rows and columns
  4. Render a print area
  5. Render a worksheet on one page
  6. Render worksheet by page breaks and print area
3

Hello,

I tried like this its show like in Excel. But Excel not display the left start of the sheet. It start with like scrolled right side but the vertical scrollbar at the bottom cant go left more. If I do Zoom-Out to %60 I can see all of it okay.
I attach the photos for this issue. You can check the column names at top to see.

Startup.PNG (111.6 KB)

ExcelShotV1.PNG (115.7 KB)

ExcelShotV2.PNG (156.4 KB)

Note:
Btw. I tried to look incognite mode like your photo or change resolution and update the groupdocs nuget packages latest and delete some startup code for if they have effect but it was all the same.

Thank you

4

@caglaraydogan

Thank you for attaching the screenshots. We’ll try reproducing this issue.

5

@caglaraydogan

Unfortunately, we can’t reproduce this issue locally. Could you please save the web page? Possibly it will help to locate the issue.