The spreadsheet tag has no wiki summary.
8
votes
4answers
17k 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 ...
1
vote
1answer
45 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 ...
0
votes
0answers
41 views
Spreadsheet::XLSX returning < > and & instead of < > &
I'm using
...
use Spreadsheet::XLSX;
use Spreadsheet::XLSX::Fmt2007;
use Spreadsheet::XLSX::Utility2007;
...
to parse an xlsx spreadsheet where a cell contains the value
() appear in ...
11
votes
1answer
9k 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 ...
2
votes
1answer
154 views
How to undo in spreadsheet calculator sc?
spreadsheet calculator sc is a very old console-based program. It does what the name says. I cannot find how to undo an operation in its man page. I currently use it together with RCS, ie. manually ...
1
vote
2answers
338 views
How can I save as Excel files (.xls) in Calligra sheets?
Would someone tell me if it is possible to save as Microsoft Excel (.xls) in Calligra sheets?
0
votes
1answer
1k views
Automating excel report
Could you please help me for the below concerns.
I'll be executing one script which gives some output
Have to arrange them in a table format in excel
Attach the excel and send it through mail
...
4
votes
3answers
1k views
Tool to compare 2 excel sheets in linux
I want to be able to compare 2 excel sheets in linux. I am not interested in converting them to csv format as they have a complicated formating that is not supported in csv.
I would like to be able ...
3
votes
1answer
100 views
Wrapping long cells in a tsv to keep them in same column
Formatting a TSV with long cells with column makes its readability very low. It simply breaks lines like this:
$ python3 -c 'for i in (1,2,3): print(((str(i)*50)+"\t")*3)' | column -s $'\t' -t
...
3
votes
1answer
301 views
How to display TSV (csv) in console, when empty cells are missed by: `column -t -s $'\t' `
I have file with columns spearated with tab.
I have file when some rows have empty cells (on begining, in middle).
In such cases column -t -s $'\t' simply fails:
Input:
$ echo -e ...
