1. Where do I get the SSL certificate of the API server?

    If you are using HTTPS (we always recommend you do this) for connecting with the API server, you might get a SSL certification validation error: ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-29024: Certificate validation failure.

    In this case you will have to load the SSL certificate of the root certification authority, in our case, that of Amazon. You can get this certificate by visiting cloudofficeprint.com and looking at the certificate information. For example in firefox:

  2. Can Cloud Office Print print directly to a printer?

    Cloud Office Print includes the ability to print directly to an IP printer, as long as it's available from the server Cloud Office Print is running on.

  3. Can you repeat the Table Header in Word and Excel?

    Yes, this is a setting in Office. When you right click on your header row in Word, you can go to Table Properties > Row and check the "Repeat as header row at the top of every page".

  4. Does Cloud Office Print support Pivots in Excel?

    Yes, you can use the transpose function in Excel to pivot your data. Cloud Office Print can also loop vertically by using the {:tag}.

  5. Why is there a difference between an output in Word and PDF?

    When going from Word to PDF, we use an external converter, MS Office or LibreOffice. It might be that if your template was built on your desktop in MS Office (Word), but your server is using LibreOffice (Linux) a font is different or there are minimal changes. The easiest way to find out what the difference is, is to open the template in LibreOffice on your desktop and see why LibreOffice is treating it different. In most cases, it works just fine going from one to the other, but sometimes it's in the details.

  6. Can I use dynamic page break in Word?

    Yes. In some cases, you might want to start a new page for every record, for example for when creating certificates. You can use the {current_child_index} tag and an angular expression to find out the length of records/cursors. {current_child_index} will resolve to the current index of the record array, starting from 0.

    You can use the follow tag to insert a page break for every record except for the last:

    --------------- page break ---------------

    Please note that if you wish to output to pdf, the same can be achieved by using the PowerPoint template and {!slides_loop} tag.

  7. Is there a way to stop Word from replacing my "Straight Quotes" with "Curly Quotes/Smart Quotes"?

    Yes. In order to stop word from replacing your straight quotes, click File, Options, Proofing, AutoCorrect, uncheck in Replace as you type "Straight quotes" with “smart quotes”.

  8. Is there a way to stop Word from adding a blank space between brackets when I paste the tag name?

    Yes. In order to stop word from adding a black space between brackets, click File, Options, Advanced, Cut, Copy and Paste, Use smart cut and paste “Settings” button, uncheck Adjust paragraph spacing on paste.

  9. How can I make the words stick together (non-breaking space)?

    In Word / PDF output you might want to not let the data of a tag get broken between lines. In this case you can use the non-breaking space.

  10. PDF output through Excel template has different decimal separators (Windows)?

    This is most probably because of your region settings for the user running Cloud Office Print. Please change the region settings accordingly. Hereby the steps to change the region settings for Service user: