Microsoft Excel file rendering options in GroupDocs.Viewer Cloud API

Just a quick question: what options are supported for the embedded cloud-hosted Viewer when it comes to rendering files? I’m aware of the “quality” option which is a value from 0 to 100 (which apparently signifies the level of fidelity you want the output to be with regards to the input file). I also see that there is a “use_pdf” option; what does that do exactly? My colleagues and I noticed that even with quality=100, many Microsoft Excel files were completely pixelated and un-readable, but once I flipped the “use_pdf” option from “False” to “True”, the quality improved many times over and the file was very readable.


What other options are there that we can pass to the viewer? I also read that there is an HTML-based rendering engine that can give even better viewer quality; is that available with the cloud-hosted Viewer?

Hello Nick,

Thank you for your inquiry.

Yes, you are right, you can configure the quality for document rendering via “quality” parameter .The “use_pdf” parameter means, that your document will be rendered, as file with .pdf format . Also this parameter permits to select a text from the document.

Could you please share with us your .exel files, that we can check them. We are trying to make our Cloud service better and if you have any issues with rendering of the documents, then please share them with us.

About HTML-based rendering engine - this engine is available only for our stand-alone libraries for .NET and Java platforms. At this moment for best rendering of the documents via our Viewer for Cloud service you can use only these two parameters: “quality” and “use_pdf”.

If you will have more questions please feel free to contact us.


Best regards,
Evgen Efimov

http://groupdocs.com
Your Document Collaboration APIs
Follow us on LinkedIn, Twitter, Facebook and Google+

The issues you have found earlier (filed as WEB-2102) have been fixed in this update .


This message was posted using Notification2Forum from Downloads module by GroupDocsNotifier .

Great; I’m glad to hear that I’m using those options correctly.

And to follow up on your request, here is one of the spreadsheets we were testing with that had horrible rendering problems: http://puu.sh/ksAWM/15f9568016.xlsx

Compare this (quality=100; use_pdf=False) with this (quality=100; use_pdf=True). The difference in terms of readability is night-and-day.

Hello Nick,

We have fixed your issue with the search in the .pdf file. Seems that the reason was in the incorrect cache of the document and now after regenerating the cache, search works well.

Please check this and let us know about your results .


Best regards,
Evgen Efimov

http://groupdocs.com
Your Document Collaboration APIs
Follow us on LinkedIn, Twitter, Facebook and Google+

Hello Nick,

Thank you for your file examples.

We will investigate them and when we will have any results we will notify you in this thread.


Best regards,

Evgen Efimov

http://groupdocs.com
Your Document Collaboration APIs
Follow us on LinkedIn, Twitter, Facebook and Google+

Hello again,

We have tested your file and have managed to reproduce the same issue . We have logged this problem in our issue tracking system as WEB-2102. Also we have linked this forum thread to the same issue and you will be notified via this forum thread once this issue is resolved.

We apologize for the inconvenience.


Best regards,
Evgen Efimov

http://groupdocs.com
Your Document Collaboration APIs
Follow us on LinkedIn, Twitter, Facebook and Google+

Thanks for giving this your attention. Also on the topic of the Viewer’s options, is it possible to turn off the search bar? In my company’s testing, we found that the search function is not very consistent and often either does not work or it highlights the wrong portions of documents. We therefore would like to disable searching entirely before we expose the viewer to our clients.


Thanks again!

Hello Nick,

Could you please share with us the details of the issue that you have with “search” widget (bar). Please check your browser console for any errors and share them with us .Also will be useful if you share with us some screenshots of the search issue and file example. We will investigate your issue and will fix it as soon as possible.

We are sorry, but at the moment you can’t turn off the search widget. We have discussed this features with our Product team and they will investigate the issue and will try to implement it, if it will not take a lot of time, because at this moment for the GroupDocs.Viewer for Cloud service we provide only bug fixing.

Please come back to us with these details and we will be glad to help you.


Best regards,
Evgen Efimov

http://groupdocs.com
Your Document Collaboration APIs
Follow us on LinkedIn, Twitter, Facebook and Google+

Hi, here are some of the use-cases that I am referring to:

  • Sometimes, the search simply doesn’t do anything. There are no errors in the browser’s console log. Please refer to this video. In this video, I have compared the behavior of the Mac OS X Preview application with the GroupDocs viewer functionality for a single PDF file. As you can see, the document is searchable with the Preview application, but not with the GroupDocs Viewer. You can view the iframe source here.
  • Other times (and I haven’t managed to capture video footage of it, but I have seen it, as have many other individuals within my company in their own testing), the text highlighting will be off. It’s difficult to describe, but the areas of the document that end up highlighted by the search feature will not correspond to the text searched for. Generally, it will be close, but the actual highlighting will be shifted some number of pixels off-target. If I manage to get video recording of this issue, I will post it here.=

Hello Nick,

Thank you for the details.

We have tested your scenario and found out that you used incorrect Viewer url for “iframe” tag. Also we have downloaded your document and have checked it on our side. The search feature works well for us, as you can see on a screenshot. We have used this “iframe” :

About your next issue with search feature - we have found that when use_pdf parameter sets as False, then we can see this issue . Is it the same issue that you meant in your previous post? If yes, then please let us know.

We will wait your results.


Best regards,
Evgen Efimov

http://groupdocs.com
Your Document Collaboration APIs
Follow us on LinkedIn, Twitter, Facebook and Google+

Thanks for catching the encoded characters in the query string; I think it got messed up when copy-pasting on my side.


Still, after fixing the ampersands, the document is not searchable still. Can you explain how the src url is wrong? I see that in your example you dialed the quality back to 50 (from 100); I tried that and it is still not searchable. Other than that (and the different document GUIDs), I don’t see any other differences between my example and yours. In fact, your example works even if I increase the quality to 100.

Hello Nick,

Thank you for coming back.

We have checked your account nick.byrd@teachscape.com and found out that you use 2014-07-Api-Monthly.Startup Basic plan and we can see that ViewsPerMonthLimit is 0 . Seems that we can assume that you have the issue with search, because you have spent all your credits.

Please update your subscription plan or contact to our sales team sales@groupdocs.com


Best regards,
Evgen Efimov

http://groupdocs.com
Your Document Collaboration APIs
Follow us on LinkedIn, Twitter, Facebook and Google+

Huh, really? I don’t see that information anywhere.


In my profile page, I see that I have used 228 out of 750 Document Tokens.

When I query the subscription plan API, I get this.

Hello Nick,

Seems, that we need some time for additional investigation of the issue. Our Product team was informed about it and we have created a ticket in our system (WEB-2170).

We will let you know, when we will have any results from our Product team.

Thanks for your patience.


Best regards,
Evgen Efimov

http://groupdocs.com
Your Document Collaboration APIs
Follow us on LinkedIn, Twitter, Facebook and Google+

Hello Nick,

We have good news for you.

Our Product team has released a new feature that you requested (disable search bar in the Viewer) . And now you can disable this bar in your account settings , as shown on the screenshot.

Please try to use it and notify us about your results.


Best regards,
Evgen Efimov

http://groupdocs.com
Your Document Collaboration APIs
Follow us on LinkedIn, Twitter, Facebook and Google+