The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
4answers
174 views

Terminal-based spreadsheets and wordprocessor?

Are there any (good) terminal based (ie. runs in a VT, not in GUI/X) spreadsheets or wordprocessors for Unix/Linux? Can anybody remember the name of such programs which were popular before (eg. ...
0
votes
1answer
1k views

Open xlsm file in linux?

For all my spreadsheet needs, I've found Open/Libre Office works fine, and I can receive xls and xlsx files from colleagues, and send files to them. However, I have recently been sent a large xlsm ...
1
vote
0answers
134 views

What would make the Simple Emacs Spreadsheet more newbie-friendly?

I am familiarizing myself with ses and I find that it's not very welcoming towards a new user. I am preparing to submit some sort of bug report or improvement suggestion, but I'm not really sure what ...
1
vote
1answer
237 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 ...
3
votes
1answer
301 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
631 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
2k 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 ...
3
votes
1answer
116 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 ...
4
votes
1answer
559 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 ...
5
votes
3answers
2k 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 ...
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 ...