Skip to main content
Unix & Linux

Questions tagged [spreadsheet]

Ask Question

The tag has no summary.

49 questions
Newest Active Bountied Unanswered
0 votes
0 answers
39 views

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 ...
matj1's user avatar
  • 141
0 votes
1 answer
92 views

Are there office suites or software for Solaris 11? OpenOffice, OnlyOffice, LibreOffice, etc.
Logos's user avatar
  • 3
0 votes
1 answer
178 views

I have a CSV file that has a single value: 40.23314545498907. When I open the CSV file with LibreOffice Calc, the value appears rounded to 40.2331454549891. Here is a screenshot of LibreOffice Calc: ...
B612's user avatar
  • 3
0 votes
1 answer
727 views

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. ...
anol's user avatar
  • 835
1 vote
2 answers
558 views

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 ...
DeJeL's user avatar
  • 350
-1 votes
1 answer
465 views

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 ...
wvz93427's user avatar
  • 1
0 votes
1 answer
2k views

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 ...
jzz11's user avatar
  • 11
0 votes
1 answer
516 views

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. ...
jzz11's user avatar
  • 11
7 votes
2 answers
3k views

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 ...
Marble's user avatar
  • 173
7 votes
3 answers
5k views

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 ...
leo's user avatar
  • 172
1 vote
0 answers
252 views

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 ...
smartblonde's user avatar
  • 11
1 vote
1 answer
370 views

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 ...
Rob G's user avatar
  • 13
1 vote
0 answers
486 views

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 ...
Angel Octavio Parada Flores's user avatar
  • 111
2 votes
1 answer
211 views

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 $ ...
dexter_danny's user avatar
  • 23
0 votes
4 answers
483 views

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 ...
kutlus's user avatar
  • 375

15 30 50 per page
1
2 3 4