The tag has no wiki summary.

learn more… | top users | synonyms

-1
votes
0answers
23 views

Libreoffice calc formula IF then ADD value to a cell

Can libreoffice calc or any other linux spreadsheet do: IF condition THEN cell B1 = B1 +20 ELSE B1=B1
-1
votes
0answers
18 views

librecalc: match with multiple criteria

I am using Libreoffice's spreadsheet program Calc. I am trying to use match to find the row that matches 2 criteria. In the future, it may be more. Vlookup only supports a single criteria, to my ...
2
votes
1answer
35 views

Openoffice Calc does not extend formula on cells

I am on this CentOS machine, fighting with openoffice 3 Calc, just to do some very simple operations. I have a column of values, and I want to perform the same operation on a certain number of ...
0
votes
1answer
175 views

Save file as Tab delimited text and spreadsheet

I am using the following command line in Linux to save the content of my input file (txt file consisted of columns) as a spreadsheet: less input_file > out_put.csv my output file is The ...
0
votes
1answer
70 views

How can I convert this excel file so that it is not only one row?

I've got an Excel file, shown in the picture below, and available for download here. What I need is to extract the variables under Item (Column B) and the values in column G. As a start, I tried ...
0
votes
0answers
25 views

Shell Script for tracking number of times each command executes

How to have a shell script that takes input from /var/log/sudo.log and sends results to a spreadsheet that displays graph for each command execution? I want to record how many times each command ...
0
votes
1answer
53 views

Changing file name from dbf to ods problem?

I was trying to change the file name from gdf to csv in the folder using $for i in *.dbf; do mv $i ${i%.dbf}.ods; done script. The code changed all the gdf to csv, but the content of the new ...
3
votes
1answer
410 views

How to export data in the terminal to a file (e.g. csv file)

I am a complete beginner in using Linux and I would like to know how to export a bunch of data in the command line to a csv or spreadsheet file (or even text would work). Right now I am simply using ...
2
votes
1answer
61 views

LibreOffice Calc Didn't Read Data with a formula (Error?)

So I have a data like this : (First Number) (=RIGHT(A1, 3)) 19132 132 56112 112 So, the second column formula is =RIGHT(A1,3) and so on. When I created the graph, it's show zero data, there are no ...
5
votes
5answers
2k 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
2k 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 ...
2
votes
0answers
238 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
528 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 ...
2
votes
0answers
279 views

How to unprotect Excel sheets in Linux (Debian/Squeeze)

I have a fairly complex (by my standards) process that extracts Excel files (.xls) from certain inbound emails and saves them in a directory on my Debian/Squeeze machine. My next step would have been ...
3
votes
2answers
437 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
851 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
3k 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
123 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
2answers
954 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
3k 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 ...
17
votes
4answers
38k 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 ...
25
votes
1answer
20k views

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 LibreOffice Calc sheet visible when scrolling? (Intuitively it should be either in view or format, at best in ...