Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
0
votes
0 answers

Refer between cells in LibreOffice Calc

This is my LibreOffice Calc sheet, now I want to sort the ID in order of the RandomNum column. Now I want my sheet to fill the last Fullname column with the name of the person with the id from the first Fullname column. I hope someone understands…
coderocket
  • 584
  • 3
  • 11
0
votes
1 answer

Mismatch when converting unix timestamp to date

I have a database (in CSV) with unix timestamps. I try to convert them in LibreOffice Calc into a human readable date. Everything is ok... except a one-day-lag. For example, my timestamp is -518144400 (in E2 cell). My function is :…
jonathan
  • 149
  • 4
  • 11
0
votes
1 answer

Format number of decimals in cells containing complex numbers

I have a spreadsheet containing both real and complex numbers. Some of them are like 0.48686 while others are like 4.85609+j3.24184 I am trying to round them, in order to have only two decimal places. While Format > Cells works on the real…
Anthony
  • 443
  • 1
  • 5
  • 16
0
votes
1 answer

LibreOffice calc conversion formula to string

How to change formula, e.g. =2+2 or =CONCATENATE("hello","world") to const string value in cell?
user3383675
  • 1,041
  • 5
  • 12
  • 31
0
votes
1 answer

libreoffice calc concatenation of strings, function name in different language

The function =CONCATENATE("troll1","troll2") can concatenate strings, but in translated version of application, function names are different, so how can I easily find equivalent of english function in trollish or any other language even if…
user3383675
  • 1,041
  • 5
  • 12
  • 31
0
votes
1 answer

Copy data from one table to an other at a specific index position

I try to do something that would be a JOIN in SQL...but I have to do it in LibeOffice Calc: There are two table-sheets, one containing an index value and an text, the other one contains an index and some other values. So it looks like this: Table A:…
Elmi
  • 5,899
  • 15
  • 72
  • 143
0
votes
1 answer

Grouping price ranges

I am trying to group some price ranges from an .ods file, but have no idea how to do that. e.g. I have a column with different prices like this: 11,61 6,15 13,68 7,69 6,00 What I want is to tell Calc to group everything from 0,00~10,99 and output…
user3292026
  • 80
  • 1
  • 10
0
votes
2 answers

Autofilter with empty cells

I need some help using the autofilter in LibreOffice. Each of my filtered columns should also include empty cells. For instance, if this is the data: and I want to filter for GMC and truck, I would get this on each column (done in Excel using…
jnewt
  • 197
  • 1
  • 3
  • 13
0
votes
1 answer

How to pass in a cell, not a cell's value, to LibreOffice function?

I want the user to be able to select cells, then have my function operate on those cells. How do I do that? "ByRef" and "as Object" seem to do the right thing, but then Excel/{Libre,Open}Office reject the function call because the user's input is…
SaburoutaMishima
  • 269
  • 4
  • 15
0
votes
3 answers

Adding 15 years to an existing date

Sample data column1 01-JAN-10 01-jan-90 like so much data is there I want out put like column2 31-dec-25 31-dec-15 For this give me formula. I tried like =Year(A1)+15 but it doesn't giving proper output
Ram
  • 147
  • 3
  • 6
  • 16
0
votes
1 answer

Return a range of values fulfilling a certain condition

I have a 28 numbers, and every day in the month of February a new number will be added to the list. All the cells that haven't been filled in yet are zero (so at the start of the month the whole column was 28 zeroes). I'm looking for a method that…
Lou
  • 2,200
  • 2
  • 33
  • 66
0
votes
1 answer

Copy string array for pasting to LibreOffice Calc

How do I copy an array of strings to the clipboard to paste to OpenOffice or LibreOffice? This CSV version works for Excel, but not for OpenOffice or LibreOffice. Input example = "A" "B" "C" "D" "E" "F" "G" "H" "I" "J" Here is my current code: …
user1815222
  • 31
  • 5
0
votes
2 answers

Calculate means

I have a column with 20000 numbers and I have to calculate the mean at intervals of 10 numbers. So I must have the mean for the first ten numbers, from 1-10, the mean for the elements (11-20) and so on. How can I write a function which can do this…
SegFault
  • 2,020
  • 4
  • 26
  • 41
0
votes
1 answer

In Libroffice calc, is it possible to transform comments into cell content?

I have an excel spreadsheet which has comments on many cells. I wish to transform these into the cell content in the adjacent column. Is this possible? How?
To Do
  • 135
  • 9
0
votes
2 answers

How can I create another row in excel sheet in C

I have written a c program which captures the packets from Ethernet in promiscuous mode and writes them into a .csv file. It is as follows: But I want my csv file as follows: How can I do it? Code for writing to the csv file is : int…
Beginner
  • 286
  • 4
  • 17
1 2 3
…
57 58