Questions tagged [spreadsheet]
The spreadsheet tag has no usage guidance.
39
questions
1
vote
1answer
44 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
0answers
176 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 ...
0
votes
0answers
17 views
Calc: Customize formula autocomplete key
If I type =aver in a cell, Calc shows me a list of formulas. I can hit the Enter key to autocomplete the formula.
However in Excel, and a ton of other apps, the autocomplete key is TAB.
This is quite ...
2
votes
1answer
85 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
4answers
124 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
2answers
9k 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
1answer
131 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
1answer
568 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
1answer
210 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
1answer
583 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
1answer
35 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
1answer
869 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
0answers
28 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
2answers
994 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
0answers
157 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
1answer
641 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
3answers
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
1answer
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
1answer
568 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
1answer
364 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
1answer
1k 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
12k 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
1answer
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
1answer
110 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
2answers
20k 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
268 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 ...
42
votes
10answers
52k 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
1answer
11k 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
0answers
686 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
1answer
5k 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
0answers
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
3answers
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
2answers
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
1answer
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
1answer
154 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
...
asked Jan 17 '12 at 18:49
Grzegorz Wierzowiecki
11.8k20 gold badges80 silver badges123 bronze badges
13
votes
2answers
7k 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\...
asked Jan 13 '12 at 12:43
Grzegorz Wierzowiecki
11.8k20 gold badges80 silver badges123 bronze badges
9
votes
3answers
15k 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 ...
33
votes
4answers
115k 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 ...
46
votes
1answer
41k 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-...
