1
vote
1answer
238 views

How to show only the last two digits of a number in LibreOffice Calc?

I have a spreadsheet like this in LibreOffice Calc: 1 2 A 012345678 Henry B 012345679 George The first column displays some ID numbers. I need to display a shorter form of this ...
16
votes
4answers
27k views

Convert a .xlsx (MS Excel) file to .csv on command line with semicolon separated fields

I realize that this is not an entirely unix/linux related question. But since this is something I'll do on linux, I hope someone has an answer. I have an online excel file (.xlsx) which gets updated ...
14
votes
1answer
16k views

Libre Office Calc: How to maintain (top) row visible while scrolling?

I did it once, but cannot find out how any more: how to keep the top row of my Libre Office Calc sheet visible when scrolling? (Intuitively it should be either in view or format, at best in ...