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" way of doing wordprocessing in Unix is using a markup-language like LaTeX or GROFF together with a simple editor like vi or emacs... But what I'm wondering about, is if there is - or was (anybody remember an older program that did this?) - something like the old MS-DOS (pre-Windows) WordPerfect-like program for Unix? Where you didn't have true WYSIWYG, but where things like emphesize and underline was marked in the text with colors, reverse video and such. Programs that are more "front ends" for LaTeX or some XML-format to create wordprocess-documents are also of interest, provided they use the terminal and use colors and such to mark things like emphesized text (rather than you see the latex format-code). Eg. you press CTRL-I, the text you write turns reverse video, and is written to file inbetween format-codes for emphesize.

I have a large table of numbers using the wrong decimal separator for my locale (dot instead of comma), so LibreOffice Calc does not parse them as numbers, but as strings. I can apply this function to a cell (A1 in this case) to parse it as a number: NUMBERVALUE(A1; "."; "") I know that I can create a side table where I would calculate the values using cell references and copy the results back to the original table. But that is impractical for a large table. How can I apply the function to all these cells at once without using any other cells?

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 rotate back to a version if needed. I am wondering if there is a better way to do it. Thanks.

Are there office suites or software for Solaris 11? OpenOffice, OnlyOffice, LibreOffice, etc.

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 there a way to check if a cell contains displayable content, such as a text string or a number? In the screenshot below, the =ISBLANK(B3) formula in C3 returns FALSE, as the cell contains a formula returning nothing. How would I go about to check is a B:B cell is ”blank” in the sense of not containing any data?

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.

I have a CSV file that has a single value: 40.233145454989**07**. When I open the CSV file with LibreOffice Calc, the value appears rounded to 40.233145454989**1**. Here is a screenshot of LibreOffice Calc: **What I have tried**: I went to *Tools* -> *LibreOffice Calc* -> *Calculate*. Then I cheked "*Limit Decimals for general number format*" and "*precision as shown*". But the program keeps rounding the value. Here is a screenshot of the settings of my LibreOffice Calc: **My Question**: How do I configure LibreOffice Calc so that it does not round numbers? In other words, how do I make LibreOffice Calc display the original number 40.233145454989**07** instead of the number 40.233145454989**1**

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 kompare way). The tool should be available in linux platform. Any ideas ?

I used a VLOOKUP function on some cells, and got lots of #N/A among some results. I then later copy/pasted them *as values* to another sheet. So now I have a column with a few numbers and several #N/As. I simply want to textually replace all #N/As with zero. But if I use the *Edit -> Find and Replace...* menu, and then put #N/A in the "Find:" field, it doesn't find anything. The same happens if I search #N/A in the Find bar (via Ctrl+F). How can I just quickly find and replace these values? I don't want to modify the formulas I use; other spreadsheet editors do allow searching for such values without issues.

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 12 files in .xls format, and some other .R files and pdf files. Is there a way to create an exact duplicate of these 3 folders, inside which all the .xls are converted to .xlsx format? If the following seems too unsubstantial, what is the way to just convert all the .xls files in one folder into .xlsx file format? Then I can replicate the aforesaid. note: I don't have LibreOffice, I use WPS. If the following requires LibreOffice I can install it if necessary.

In a LibreOffice Calc I am trying to retrieve the value from a random cell within a group of cells, some of those cells *may* contain the word "None", I don't want any of those chosen when the random cell is chosen...example: |Input|Output| |----:|:-----| |Maybe|Time| |Time|Time| |Wants|Maybe| |None|Wants| |Of|Tell| |My|My| |Effort|Time| |None|Can| |Can|My| |Tell|Effort| However, the only randomization methods I've been able to figure out for myself do full randomization, example: |Input|Output| |----:|:-----| |Maybe|None| |Time|Time| |Wants|Maybe| |None|Wants| |Of|None| |My|My| |Effort|Time| |None|Can| |Can|None| |Tell|Effort|

I am trying to randomize a list of words in LibreOffice Calc. Column A contains numbers 1 to 15, indicating the initial order of the words. Column B contains the words themselves. Here is the original data set(A1-B16):

No.	Words
1	alike
2	bear
3	cane
4	dark
5	easy
6	fill
7	grass
8	hike
9	iron
10	joke
11	kilo
12	long
13	moan
14	nose
15	ouch

Then I wrote

=RAND()

to C2-C16, which generates a random number between 0 and 1 that will be used to shuffle the list.

No.	Words	RNG
1	alike	0.865621083224796
2	bear	0.931833626420918
3	cane	0.227839223621858
4	dark	0.832537867713207
5	easy	0.969775037455717
6	fill	0.896303834396809
7	grass	0.432228403811195
8	hike	0.075830198639415
9	iron	0.867408144812027
10	joke	0.603695010104631
11	kilo	0.410994968775223
12	long	0.840853885814879
13	moan	0.919710215557461
14	nose	0.181802316389395
15	ouch	0.016758784630857

Then I selected A1-C16 and sorted in ascending order using RNG as the key. This is the result:

No.	Words	RNG
15	ouch	0.766843532872873
8	hike	0.947070486803519
14	nose	0.935710387458581
3	cane	0.907095084669842
11	kilo	0.998591593185233
7	grass	0.262657114008517
10	joke	0.508633980155267
4	dark	0.686797433391668
12	long	0.124417578504844
1	alike	0.316587339544393
9	iron	0.780943260363561
6	fill	0.020870056655958
13	moan	0.421603151053937
2	bear	0.017301889523655
5	easy	0.904484088935699

Note that Column C was recalculated while sorting, but the sorting was done according to the old values. So it does not look like the list was properly sorted when viewed by a 3rd party. I soon found out that they are regenerated every time I do any operation such as changing the font, font size, color, copying, pasting, etc. This means that I cannot simply copy Column C to Column D. The original values are lost, and both Column C and Column D get new values.

No.	Words	RNG	
15	ouch	0.53812335792605	0.043562592479011
8	hike	0.398881655918106	0.64370811632297
14	nose	0.201867181513088	0.755510523771107
3	cane	0.394920269465235	0.28416412724015
11	kilo	0.152969079524211	0.799996173130015
7	grass	0.902568202601681	0.663629657403564
10	joke	0.435628762542454	0.334338520877465
4	dark	0.096763206996108	0.886593020939989
12	long	0.385578268172482	0.379263717906069
1	alike	0.678912726335666	0.74399580956146
9	iron	0.838382502021304	0.609345470240727
6	fill	0.025112459308232	0.365339519963588
13	moan	0.321684809269134	0.92230175892848
2	bear	0.013301554887914	0.274360792567395
5	easy	0.308874453562179	0.640593438289194

I could just manually type the values on a separate column but then I can no longer prove that they were actually generated by RAND(). If I click the manually copied cells the expression is the number itself, not

=RAND()

anymore. How can I create an expression or modify RAND's behavior so that RAND's values are fixed once generated?

I'm looking for an app to display & edit CSV files as a tabular data in cells, similar to GUI spreadsheets like LibreOffice Calc. I just need simple viewing, cell editing & easy navigation between cells, w/o complex vim-like shortcuts. Any suggestions?. Thanks

Is there an app to edit LO Calc spreadsheets in the terminal, i.e. in text mode w/o the GUI?. It doesn't need to be a LO package, anything will do. It needs to be able to save in Calc's .ods format. Thanks

In sc (spreadsheet calculator), I formatted a column with ` but was unable to insert a valid date in its cells. If I digit (or other similar notations, with or without the initial ^D`, I only get a string with no possibility to calculate date-differences. Could somebody give me any hints?

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 closest: https://developers.google.com/sheets/api/quickstart/apps-script where we have to create a script on the Google site and run that script? I believe there used to be wget/curl methods.

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 total consumed, so that the remaining 10% is distributed across the rest in negligible amounts. In Excel, I was able to Group those other countries into their own category ("Others"), aggregating their consumption, yielding cleaner tables and graphs (my table/graph now had 6 data rows, instead of 20-- one for each of the 4 big countries, the "Others," and the Total), making the whole thing easier to read. When I try to do the same in LibreOffice, countries get grouped in alphabetical order (rather than by volume), creating a useless mess: I have the Others category, but it doesn't contain the right countries. In theory, I could do it manually, by adding a column Country2, and using VLOOKUP to flag as Others the smaller countries. But that seems overkill: there should be a way to do it automatically. Here's what I do and the results I get at each step: 1. Create the Pivot Table, adding first the Pasta field, and then the Country field 2. Select the country rows, go to Data, Sort... and sort by Column B, Descending. 3. Drag-select from Guatemala downwards (so, Rows 8 - 24), click on Data, Group and Outline, Group. (Or press F12, if not bound to Guake, like me). You'll notice that the countries are back in alphabetical order, though Group 1 was created with Rows 8 - 24, just not how I had them sorted.

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 in bash, searching for specific data in this file, and I'm formatting this data to generate a .csv file, which can be opened in LibreOffice Calc. But I can't format fields in .csv, change font size and so on. What I want instead of using .csv files is opening an existing .odt spreadsheet file (with formatted and colored cells, margins...) and insert data directly from bash into some cells.

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 problem because the background of Writer is white). I read in the arch linux wiki that the bad integration with dark themes of KDE is usual . However, I don't know how to execute it with the command that they suggest. I also saw this , but it's the same. And I don't know how difficult things are having installed it from snap (the path to run this application is not in bin/et, /usr/bin/wps or something like that).

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 $ samtools view -c -f 1 -F 12 HG00173.chrom11.ILLUMINA.bwa.FIN.low_coverage.20111114.bam for this i am getting output in some numbers as 1222456. My requirement is, I should get the output for all the input bam files in a csv file with 2 columns with naming column 1) Bam-id , column 2) No_of_mapped_reads.