Render Print Area in Worksheets using GroupDocs.Viewer for .NET 18.4

Document Viewer API

Here we go! Another monthly release of GroupDocs.Viewer for .NET is out now. In the current release, you will find new options to render print area and to include or exclude hidden columns and rows in the Cells documents. Furthermore, we have added the support of rendering POTX, PPTM, and EPS file formats. Below you find the list of new features, improvements, and fixes added in GroupDocs.Viewer for .NET 18.4.

Supported File Formats

We have added the support of following file formats in this version.

  • POTX (PowerPoint Open XML Presentation Template)
  • PPTM (PowerPoint Open XML Macro-Enabled Presentation)
  • EPS (Encapsulated PostScript)

Managing Text Overflow when Rendering Cells Documents

When cells documents are rendered into HTML, overflowed text inside the cell overlays subsequent cells until it meets non-empty cell. To expand the cell width to fit the overflowed text, we have added a new option TextOverflowMode.AutoFitColumn for CellsOptions.TextOverflowMode property of HtmlOptions, ImageOptions or PdfOptions classes. The following code sample shows how to use this feature.

// Setup GroupDocs.Viewer config
ViewerConfig config = new ViewerConfig();
config.StoragePath = @"C:\storage";
   
// Create html handler
ViewerHtmlHandler htmlHandler = new ViewerHtmlHandler(config);
string guid = "document.xlsx";
   
// Set Cells options to hide overflowing text
HtmlOptions options = new HtmlOptions();
options.CellsOptions.TextOverflowMode = TextOverflowMode.AutoFitColumn;
  
// Get pages 
List pages = htmlHandler.GetPages(guid, options);
   
foreach (PageHtml page in pages)
{
    Console.WriteLine("Page number: {0}", page.PageNumber);
    Console.WriteLine("Html content: {0}", page.HtmlContent);
}

For more details on this feature, please visit this documentation article.

Rendering Print Area in Cells Documents

Starting from 18.4, GroupDocs.Viewer provides a new option RenderPrintAreaOnly in GroupDocs.Viewer.Converter.Options.CellsOptions class which enables rendering sections of the worksheet(s) defined as print area. GroupDocs.Viewer renders each print area in a worksheet as a separate page. The following code sample shows how to use this feature.

// Setup GroupDocs.Viewer config
ViewerConfig config = new ViewerConfig();
config.StoragePath = @"C:\storage";
  
// Create html handler
ViewerHtmlHandler htmlHandler = new ViewerHtmlHandler(config);
string guid = "document.xlsx";
  
// Enable redering of print area
HtmlOptions options = new HtmlOptions();
options.CellsOptions.RenderPrintAreaOnly = true;
  
// Get pages 
List pages = htmlHandler.GetPages(guid, options);
  
foreach (PageHtml page in pages)
{
    Console.WriteLine("Page number: {0}", page.PageNumber);
    Console.WriteLine("Html content: {0}", page.HtmlContent);
}

For more details on this feature, please visit this documentation article.

Rendering Hidden Rows and Columns

Sometimes cells document may contain hidden columns and rows. By default, hidden columns and rows are not rendered by the API. However, you can now control the inclusion of hidden content in the rendering results using ShowHiddenRows and ShowHiddenColumns properties of GroupDocs.Viewer.Converter.Options.CellsOptions class as shown in the following code sample.

// Setup GroupDocs.Viewer config
ViewerConfig config = new ViewerConfig();
config.StoragePath = @"C:\storage";
  
// Create html handler
ViewerHtmlHandler htmlHandler = new ViewerHtmlHandler(config);
string guid = "document.xlsx";
  
// Enable redering of hidden rows and columns
HtmlOptions options = new HtmlOptions();
options.CellsOptions.ShowHiddenRows = true;
options.CellsOptions.ShowHiddenColumns = true;
  
// Get pages 
List pages = htmlHandler.GetPages(guid, options);
  
foreach (PageHtml page in pages)
{
    Console.WriteLine("Page number: {0}", page.PageNumber);
    Console.WriteLine("Html content: {0}", page.HtmlContent);
}

For more details on this feature, please visit this documentation article.

Simple File Storage Interface

Starting from v18.4, GroupDocs.Viewer provides the simple interface IFileStorage to implement custom file storage. This interface is an alternative to complex and overloaded ICacheDataHandler and IInputDataHandler interfaces. For sample implementations of custom file storage, please visit this documentation article.

Bug Fixes

Following issues are fixed in version 18.4 of GroupDocs.Viewer for .NET.

  • Invalid PDF when rendering Excel document with multiple pages per sheet
  • DefaultFontName setting is not working for rendering Text documents into PDF and image
  • Incorrect rendering of the content in header and footer of Word document
  • Local links are ignored when rendering PDF to HTML
  • Discrepancy when rendering as JPEG and HTML

Improvements

Following are the improvements that we have made in version 18.4.

  • Added prefix for CSS classes when rendering Email messages
  • Minified CSS content when rendering into HTML with EnableMinification is set to true
  • Improved rendering comments from Presentation documents
  • Added support JpegQuality option when rendering Microsoft Project documents
  • Extended support for DefaultFontName setting to PDF documents when rendering into HTML
  • Responsive HTML output required in the case of HTML representation

Related Links and Resources

We have a few channels and resources for you to download, learn, try and get technical support on our document viewer API.

Feedback

As always, if you have any questions or suggestions, feel free to write on our forum.

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

To keep up with our news, you can follow us on Twitter or follow our Facebook page.

Comments are closed.