Tag: release

Full PDF Export for Spreadsheets

Cor Nouws 1 Comment

Review the full content of one spreadsheet-sheet as one page in PDF export

Have you ever wanted to have a way to see the full content of a spreadsheet document in a PDF, without the usual slicing of the sheets into separate printable pages?

Interesting new feature – also with Collabora document conversion

We publish some screenshots, showing why you should use Full PDF Export. First of a sheet containing some data and graphics:

Sample Sheet
Sample Sheet

And this is how it looks like when exported to pdf in the old/usual way:

Usual PDF Output
Usual PDF Output

Not enough? Think about what happens when there are multiple such sheets all with different sizes… 🙂
An very interesting use case is with (automated) document conversion. Full PDF Export makes it possible to do easier reviewing, evaluating, of the conversion.

How do I use it?

* Open your spreadsheet document in LibreOffice Calc
* From the menu, select **File – Export as PDF…**
* On the **General** tab of the **PDF Options** dialog, check the option named **Full-Sheet Previews**
* Click the **Export** button, and choose a location for your preview pdf
* Enjoy your pdf file of full sheet previews

Full-Sheet Preview PDF
Full-Sheet Preview PDF

Option on the dialog

Full-Sheet Previews option on the PDF Export Dialog
Full-Sheet Previews option on the PDF Export Dialog

Also available in the LibreOffice/Collabora Online api

If you happen to use the LibreOffice/Collabora Online REST api for document conversions, here is a command to get a preview output of your sheet:

curl --insecure -F "data=@YourSpreadSheetDocument.ods" -F "FullSheetPreview=true" https://localhost:9980/lool/convert-to/pdf > out.pdf

You can read more info about the REST api on the document conversion page.

Where and when?

The feature was developed on the cp-6.2 branch of LibreOffice code-base, which is the base for Collabora Office 6.2. Therefore Full PDF Export is already available in Collabora Office snaphots. And it is being backported to LibreOffice master, so it is available in LibreOffice development builds.

Tips

* Currently, this option disregards most of the other options on the pdf export dialog
* Preview pages will have different sizes (same as the source sheets)
* This is not meant for printing
* The export dialog remembers your last choice, so better not forget to uncheck this option next time you would like to get a regular (for-printing) output

More (technical) info

More (technical) info can be found on the blog-post by our developer Muhammet Kara. Thanks, Muhammet!

Use and test these new features

You noticed some glitches on the screenshots? We did too!
It’s work in progress and our developers work hard to get all right.
Regular updates will be released – so your feedback and of course patches are much appreciated.

Get & Test Collabora Office Snapshot

For more information

Follow @CollaboraOffice on Twitter or send us an email to hello@collaboraoffice.com

Powerful Function Wizard in Collabora Online Spreadsheet

Cor Nouws Leave a comment

Doing your formulas right

Working with formulas is a great thing, and can even be fun with the proper tools 🙂 So therefore we’re proud to introduce the full Formula Wizard in Calc Online!

Let’s just show it in some pictures from our latest snapshot.

Collabora Online Function Wizard - Start
Start of the Function Wizard – and use off the Search function
Collabora Online Function Wizard - argumentts
Function Wizard – Filling all arguments
Collabora Online Function Wizard - Structure
Function Wizard – investigate formula structure
Collabora Online Function Wizard - results
Function Wizard – Make use of the results

 

Use and test these new features

You noticed some glitches on the screenshots? We did too!
It’s work in progress and our developers work hard to get all right.
Regular updates will be released – so your feedback and of course patches are much appreciated.

Get & Test Snapshot

For more information

Follow @CollaboraOffice on Twitter or send us an email to hello@collaboraoffice.com

Easily working with Tables in Collabora Online

Cor Nouws 9 Comments

Another new feature in the Collabora Online snapshot!

Resizing tables with the tips of your fingers on your smart devices – or the cursor working on the PC.
This is how it looks in our latest snapshot.

 

Start using and testing the new features

You can get a snapshot of Collabora Office and try it right now – and we love to hear your feed back.
Regular updates will be released – so stay tuned!

Get & Test Snapshot

For more information

Follow @CollaboraOffice on Twitter or send us an email to hello@collaboraoffice.com

Rich Table of Contents feature in Collabora Online

Cor Nouws Leave a comment

Try this new rich feature in the Collabora Online snapshot!

Why not have full control over the Table of Contents while working online?! How hyperlinks are used, formatting is done, and settings as columns and background..
Well, that is what we bring to you in Collabora Online now. It gives you the same rich scale of features that are known from the LibreOffice desktop, or of course our enterprise supported Collabora Office.

This is how it looks in our latest snapshot.

You’ll notice that the context menu of the index, allows you to update or delete it. To get access to the dialog with all the settings, use Insert > Table of Contents and Index >… while the index has the focus.

Start using and testing the new features

You can get a snapshot of Collabora Office and try it out yourself right now!
There’s a flow of new features to be expected. We’ll blog about it regularly, so stay tuned! And of course we love you to use and test it and let us know what you find.

Get & Test Snapshot

For more information

Follow @CollaboraOffice on Twitter or send us an email to hello@collaboraoffice.com

Automatic Redaction – now more efficient redaction in Collabora Office

Cor Nouws 3 Comments

 

The new Automatic Redaction makes redacting even more efficient

The Redaction tool has been extended, for fast and automatic marking of text. This tool is designed you to hide words and other portions of a document that are sensitive, classified or private, so that you can safely share an image-pdf of the file with others. Its details are explained in a previous article.

And now, the new feature Automatic Redaction allows you to add words and patterns that then are found in the document and marked for redaction. It extends on features such as cooperating, preview, choice in style of hiding information. This makes redacting documents in Collabora Office really efficient. It works faster and helps considerably doing the job correct. Here is how it works.

How to use the Automatic Redaction?

  • The next image from Writer shows how to start from Tools > Auto-Redact.

  • The dialog has a list for redaction targets. It is simple to add items.

  • The selection list Type also allows to use regular expressions or choose from pre-defined types.


  • Also interesting is the possibility to save the list of targets to a json-file, and load them likewise.

  • Then with OK the file is converted to image with marked areas, and opened in Draw for further redaction, reviewing and final export as PDF.

As said, a previous article explains all basic features.

Want to start using the Redaction tool?

You can get a snapshot / demo of Collabora Office and try it out yourself right now!

Try Unstable Snapshot

Collabora is a major contributor to LibreOffice and all of this work will be available in TDF’s next release too.

 

For more information:

Follow @CollaboraOffice on Twitter or send us an email to hello@collaboraoffice.com