Questions tagged [spreadsheet]
The spreadsheet tag has no usage guidance.
40
questions
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 ...
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 ...
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 ...
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 ...
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
$ ...
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 ...
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.
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 ...
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 ...
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 ...
-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....
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: ...
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 ...
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 ...
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 ...
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, ...
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 ...
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) ...
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....
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, ...
-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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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 ...
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
...
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\...
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 ...
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 ...
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-...