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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
3
votes
2answers
439 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 ...
0
votes
1answer
177 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
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 ...
4
votes
2answers
956 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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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
239 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
2answers
852 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?
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 ...
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 ...