Questions tagged [spreadsheet]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
4answers
42 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 ...
3
votes
2answers
47 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
62 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
238 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
47 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
182 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
34 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
203 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
27 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
1answer
712 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
102 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
364 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
5k 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
482 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
300 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
10k 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
4k 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
104 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
16k 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
247 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 ...
30
votes
10answers
36k 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. ...
0
votes
1answer
9k 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 ...
2
votes
0answers
627 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
997 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
1k 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
5k 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
149 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 ...
12
votes
2answers
5k 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\...
8
votes
3answers
11k 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 ...
31
votes
4answers
102k 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 ...
44
votes
1answer
39k 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-...