Questions tagged [spreadsheet]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
330 views

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 ...
user avatar
  • 123
1 vote
0 answers
24 views

How do I get or set individual cells in a Google Spreadsheet from bash

I could really use a way to get or set individual cells in a Google Spreadsheet from bash, without having to download the entire sheet, make an update and re-upload the entire sheet. Is this the ...
user avatar
1 vote
1 answer
83 views

How to insert a few rows of data into an existing .odt file with bash and libreoffice calc headless?

Is there a way in bash to open an existing .odt file in libreoffice calc and insert a few rows of data (in headless mode), basically manipulating an .odt file through bash? I'm reading some PDF files ...
user avatar
  • 13
1 vote
0 answers
323 views

WPS change the background and font color in Manjaro

I installed WPS with snap (my OS is Manjaro 20.0.3 "Lysia"), but when I run Spreadsheet the background is black, also the default font color in Spreadsheet and Writer is white color (It is a ...
user avatar
2 votes
1 answer
128 views

bash script to find the results from multiple input files which are using 'samtools' to a new output csv file

I have query related to Bioinformatics. I have multiple bam files, from each bam file i should find out number of mapped reads from each bam file with id's, for doing it i have the command $ ...
user avatar
0 votes
4 answers
241 views

Filename is divided when writing on a csv file

I have a directory in the terminal folder. I am using MobaXterm. This directory has a large number of files in it. File names are long and have some illegal characters. An example filename is "The ...
user avatar
  • 305
5 votes
2 answers
14k views

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.
user avatar
  • 103
0 votes
1 answer
166 views

Plot with hours that have a sign on Libreoffice-Calc

On Libreoffice calc I have a spreadsheet that can compute certain quantities in time (hours). These quantities can be positive or negative. For example, the values in the spreadsheet can be a daily ...
user avatar
  • 103
0 votes
1 answer
839 views

Keyword Search for .xlsx .ods files recovered by photorec

Photorec recovered 3+ GB of files: buried in these files is a target spreadsheet that is saved in both the .ods and .xlsx format. Although Photorec recognizes spreadsheets: it would be preferable to ...
user avatar
  • 1,094
1 vote
1 answer
387 views

Copying tab-delimited data out of the shell

I already posted this on askdifferent, but no luck. Glad to remove if out of scope. So I am running some Python scripts that print out tab-delimited data (i.e. adding the \t character during the ...
user avatar
  • 1,002
-2 votes
1 answer
949 views

How to calculate like a spreadsheet of excel in Linux? [closed]

I have a table A 1 1 1 B 2 2 2 C 3 3 3 I want to create a new row of "sum" like A 1 1 1 B 2 2 2 C 3 3 3 SUM 6 6 6 and new columns running this formula value/sum to get A 1 1 1 0.17 0.17 0....
user avatar
1 vote
1 answer
41 views

How to copy-paste cell contents of new lines into a cell?

Assume you have the following content in clipboard Yt rauhallinen. Lorem ipsun loremp. If you paste it into a cell in any spreadsheet editor, you get the content in many cells. Expected output: ...
user avatar
1 vote
1 answer
1k views

Inserting delimiter into file

I have a file with a similar format to the following: 1.1.1.5 Ensure mounting of hfsplus filesystems is disabled 1.1.1.6 Ensure mounting of squashfs filesystems is disabled 1.1.15 Ensure nodev option ...
user avatar
1 vote
0 answers
29 views

how to have a chart from only one page of multi-sheet .ods file?

I downloaded Visa stats from EU site which were unfortunately in .xlsx (MS-Excel) format. I used calligrasheets to transform the .xlsx to .ods sheet and was able to open the same in libreoffice. The ...
user avatar
  • 10.7k
1 vote
2 answers
1k views

How to group sorted rows in PivotTables?

I have a pivot table summarizing numeric values per country (say, kilos of pasta consumed per year), sorted in descending order by amount consumed. For reasons, 4 countries represent over 90% of the ...
user avatar
  • 93
1 vote
0 answers
197 views

How can I export the data from a LibreOffice Writer graph to e.g. Calc?

I have a LibreOffice Writer document (.odt; originally .docx) with a simple 2D graph containing one line. If I right-click on the graph and choose Edit, then right-click again and select Data Table, ...
user avatar
2 votes
2 answers
779 views

Insert a date in a cell in sc

In sc (spreadsheet calculator), I formatted a column with <f 12 0 3> but was unable to insert a valid date in its cells. If I digit <\^D15/12/31> (or other similar notations, with or ...
user avatar
0 votes
3 answers
2k views

simplest cell addition formula on column in libreoffice 5

sharing as an example. I have data starting from column b2 to b8 where I want to add the values (sum) and get the output in another cell, say b10. The most logical way should have been =SUM(B2,B8) ...
user avatar
  • 10.7k
0 votes
1 answer
7k views

text to xls file creation

I have 4 text files in my unix system want to put data into a xls file and send it via mail. text1.txt: 100 150 130 120 110 text2.txt: 200 230 240 250 260 .. .. .. so on ... I want to have text1....
user avatar
  • 11
3 votes
1 answer
610 views

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, ...
user avatar
-1 votes
1 answer
380 views

Spreadsheet::ParseExcel [closed]

I am using Spreadsheet::ParseExcel, and want to take the file name as an input from the user. Moreover, I want the parsing of two files to happen based on a condition provided by the user. This is ...
user avatar
  • 45
2 votes
1 answer
2k 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 ...
user avatar
  • 309
0 votes
1 answer
13k 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 problem ...
user avatar
3 votes
1 answer
5k 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 ...
user avatar
  • 135
0 votes
1 answer
111 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 ...
user avatar
  • 767
5 votes
2 answers
22k 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 ...
user avatar
  • 51
2 votes
1 answer
280 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 ...
user avatar
  • 123
46 votes
10 answers
61k 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. ...
user avatar
1 vote
1 answer
12k 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 ...
user avatar
  • 271
3 votes
0 answers
712 views

What would make the Simple Emacs Spreadsheet more friendly? [closed]

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 ...
user avatar
  • 6,921
2 votes
1 answer
6k 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 ...
user avatar
  • 5,345
3 votes
0 answers
1k 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 ...
user avatar
4 votes
3 answers
2k 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 ...
user avatar
  • 199
1 vote
2 answers
2k 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?
user avatar
0 votes
1 answer
6k 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 Anyone ...
user avatar
  • 1
3 votes
1 answer
160 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 ...
user avatar
14 votes
2 answers
8k 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 'A\tB\tC\tD\n\tb1\...
user avatar
10 votes
3 answers
17k 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 ...
user avatar
  • 407
35 votes
4 answers
121k 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 ...
user avatar
  • 453
49 votes
1 answer
42k 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 right-...
user avatar
  • 3,477