ONLYOFFICE
Edit tools using a touchscreen
OnlyOffice 8.2, released in late October, adds touchscreen support for every tool in the suite – documents, PDF forms, presentations and spreadsheets. It means you can edit on any device that has a touchscreen, including PCs and laptops, using your fingers as well as your mouse.
For example, we pressed cell B4 to highlight it (1 in our screenshot above), then long-pressed it to bring up the right-click menu 2.
LIBREOFFICE CALC
Lock your search filters in spreadsheets
The latest version of LibreOffice Calc (24.8) adds a Lock option when using AutoFilter, which keeps your search filter activated when you search your spreadsheet. This stops any subsequent search you make overriding the filter you chose.
First, select the cells you want to add filters to,…
