LibreCalc - Ubuntu How to print full sheet on single page in landscape mode

LibreCalc - Ubuntu How to print full sheet on single page in landscape mode - Latest

Problem: We use Librecalc to draft a pretty looking excelsheet and then we want to print it. You happily hit Ctrl + P, just to see that the sheet has been split over multiple pages to print.

What do you do now?

For starters, you continue reading this post.

1. Go to 'Format' in the Menu bar, Go to 'Page', Choose 'Landscape' and set other borders etc. incase you wanna change that

2. Now under, 'Sheet' in the same window, look at this section 'Scale'. Choose 'Fit print range(s) on number of pages' and keep 'Number of pages' as 1. And we are done!

And we are done here. Now when you print and choose Landscape orientation, you can see in the preview that the whole sheet is now printing on a single page.

Comments

Formatting XML in Kate - KDE Editor

TLDR; Kate is one awesome editor ( If you don't like Vim for its 'CLI'ness ) When working from the command line we can use a handy tool ' xmllint ' to format XML files using its --format option. But it is a tedious task to use it when you have some content in Kate ( more so if it is an unsaved file ) and want to format it. Incase, you don't have xmllint installed, simply hit sudo apt-get install libxml2-utils and that will install it for you. If you use xmllint you would do something like this, Save File ( MySavedFile.xml ) Go to Command Line cat MySavedFile.txt | xmllint --format - > MySavedFile.txt and then reload our file in Kate . If you wish to remain in Kate and get this done then you would need to do, Select text ( Complete or Partial ) Hit ' Ctrl + \ ' or go to Tools -> Filter Text Incase your Kate does not have the option for 'Filter Text' under tools, you just need to enable the 'Text F

Formatting JSON in Kate - KDE Editor

Some years ago, I wrote a post on Formatting XML in Kate - KDE Editor . This one below is for JSON format. Like the XML one this one also makes use of a tool installed on your machine and is invoked from Kate as a filter. TLDR; Kate is one awesome editor ( If you don't like Vim for its 'CLI'ness ) When working from the command line we can use a handy tool ' jq ' to format JSON files and pretty print them. Well, the good news is we can use the same from within Kate as well But it is a tedious task to use it when you have some content in Kate ( more so if it is an unsaved file ) and want to format it. Incase, you don't have jq installed, simply hit sudo apt-get install jq and that will install it for you. If you use jq you would do something like this, Save File ( MySavedFile.xml ) Go to Command Line cat MySavedFile.txt | jq '.' - > MySavedFile.txt and then reload our file in Kate . If you wish to remain in Kate and get this done then

Setting up HMA on Ubuntu

There are variety of reasons for wanting to setup a proxy connection on your machine. Getting this done on a Windows OS is simple, with tools like HMA! ( Hide My Ass! ) However, the surprise is it is quite easy to get it done on Ubuntu as well. This is for Ubuntu 18.10, I haven't really tried on another OS but the steps would remain the same. Do note that you will need a valid HMA username and password for this to work. There are 3 ways you can connect using HMA, I chose OpenVPN. Steps: First you need to setup OpenVPN on your machine if it is not available already sudo apt-get install network-manager-openvpn-gnome Next you need the download the certificate and VPN config files from official HMA website Download HMA VPN Configs Here! Save it in a folder on your machine and extract it. I prefer ~/vpn_HMA/ cd ~/ mkdir vpn_HMA/ Once you have the extracted folder in place, the next step is to connect to proxy using the Network Manager. It is pres

Now I Know That Technical Thing Too

Search This Blog