Unix and Linux Stack Exchange
Unix and Linux Stack Exchange

Questions tagged [spreadsheet]

45 questions
55
votes
10 answers

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. before X became so widespread)? I know the "correct"…
Baard Kopperud
  • 7,023
  • 6
  • 42
  • 62
50
votes
1 answer

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 right-click menu, but I can't see anything related ... )
neydroydrec
  • 3,777
  • 8
  • 32
  • 42
35
votes
4 answers

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 periodically (by someone else). I want to write a…
allrite
  • 453
  • 1
  • 4
  • 5
14
votes
2 answers

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 'A\tB\tC\tD\n\tb1\t\td1\n\t\t\td2\na3\t\t\td3' > in.tsv $ hexdump -C…
Grzegorz Wierzowiecki
  • 13,865
  • 23
  • 89
  • 137
12
votes
3 answers

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 to have a graphical comparison (some sort of…
Debugger
  • 427
  • 2
  • 4
  • 5
7
votes
2 answers

Converting multiple .xls format files to .xlsx format

I am new to Linux. I know that there are ways to convert between file formats in Linux through the terminal. But is there any way I achieve the following? I have 3 folders, inside those folders, there are 15 more folders. Each of those folders has…
Marble
  • 173
  • 6
6
votes
3 answers

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 create versions in RCS before big changes, and…
Jing
  • 319
  • 2
  • 8
5
votes
2 answers

How to find out if a cell is (visibly) blank in LibreOffice Calc?

In LibreOffice Calc the =BLANK() formula will only return TRUE on cells with the underlying datatype ”blank”. In other words: If the cell contains a formula that returns nothing (or if it contains the empty text string), =BLANK() will be FALSE. Is…
leo
  • 152
  • 7
5
votes
2 answers

how to read xls file in Linux

I copied a .xls file from mail to server. when i opened it, it is in non-readable format. At the bottom i could see "[noeol][converted]" I need to extract the data from xls file.
Ramkumar
  • 113
  • 1
  • 1
  • 8
5
votes
2 answers

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 echo on a topic that prints out a ton of data. So…
AAC
  • 51
  • 1
  • 1
  • 3
3
votes
0 answers

What would make the Simple Emacs Spreadsheet more friendly?

I am familiarizing myself with ses. So far, things that I find unobvious, or confusing, or disturbing; M-x apropos spreadsheet returns nothing at all. I knew I had seen something about a built-in spreadsheet in Emacs somewhere recently. But…
tripleee
  • 7,506
  • 2
  • 32
  • 42
3
votes
0 answers

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 to use xls2csv (catdoc) to convert the .xls files…
Spartanblogger
  • 587
  • 3
  • 9
  • 16
3
votes
1 answer

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 11111111111111111111111111111111111111111111111111 …
Grzegorz Wierzowiecki
  • 13,865
  • 23
  • 89
  • 137
3
votes
1 answer

Calc: How to convert a numeric column in-place?

In Libreoffice Calc, is there a way to convert a column of numbers "in-place", such as converting from miles to kilometers, or percent to decimal? I know how to do it by: adding a temporary column, applying a formula, copying the new column,…
user140663
3
votes
1 answer

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 saving the Excel file as a comma-delimited .csv file,…
PollPenn
  • 135
  • 1
  • 4
1
2 3