Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
10
votes
2 answers

LibreOffice Calc count the number of distinct occurrences

What formula in LibreOffice Calc will count the number of distinct Week_Number occurrences? The answer should be 2.
Dave Kirkby
  • 409
  • 1
  • 4
  • 14
9
votes
3 answers

Libreoffice Calc: date string to date/time values

I need to extract a 'date string' as separate columns representing date/time data. | A | B | C -+--------------------------+-------------------+----------------- 1| Datetime String | Date Value …
Charles Goodwin
  • 6,402
  • 3
  • 34
  • 63
8
votes
1 answer

Libre Calc: count duplicate values

I have some values in one column (A) like this: 1. 5201890000018 2. 5201890000018 3. 5201890000018 4. 5010175810538 5. 5010175810538 6. 5010175810538 7. 5010175810538 8. 50008667 9. 50008667 Is there a formula to count the duplicate values…
tse666
  • 81
  • 1
  • 3
7
votes
2 answers

How to define dynamic ranges on Calc (or Excel)?

Let's say I have a Libreoffice.org Calc (maybe this goes for MS Excel too) object defined as the range $Sheet1.$A$1:$A$4. I also have declared a constant with value 1. For this mockup purpose, let's call it startingLine. Both objects are properly…
Waldir Leoncio
  • 10,853
  • 19
  • 77
  • 107
7
votes
1 answer

How to calculate Date Time Difference in LibreOffice Calc

I need to calculate the difference between two Date Time fields in LibreOffice Calc, with the answer in hours, positive or negative. When there is a positive result =J2-I2 works, and returns answer in hours. When there should be a negative result…
CedarSage
  • 73
  • 1
  • 1
  • 3
7
votes
1 answer

Remove rows where value is *not* in column on other sheet

I have a LibreOffice Calc file with two sheets. Sheet 2 has just one column A with lots of numbers. In sheet 1, column A of every row also holds a number. I want to remove all rows from sheet 1 that have a value in column A which does not appear…
Lukas Barth
  • 2,734
  • 18
  • 43
7
votes
3 answers

how to count instances between a range in libre office calc 4

I have a range of numbers in a1:80. I want to count the total number of values in a1:a80 that fall between X and Y e.g. Value X = 30000 value Y = 35000 cell a1 = 34000 cell a42 = 33000 Goal: The formula will tell me that there are 2(two)…
pleabargain
  • 193
  • 2
  • 3
  • 16
6
votes
2 answers

Is there a way to create/read a LibreOffice Spreadsheet just like MS Office Excel with C#?

In a program that creates an excel file, i wonder if i could give the chance to the users that don't have MS Office to create an .xls file with only LibreOffice installed. What should i use instead of "using Excel =…
Christos Karapapas
  • 1,018
  • 3
  • 19
  • 40
6
votes
1 answer

How do i change the language for spellchecking in Libreoffice Calc

I have to create a table with LibeOffice Calc in another language than my native one. If I run the spellchecking, I manually have to change the language for every word in the document. How do I change it for the whole document at once? I tried to…
Kimses
  • 707
  • 7
  • 17
6
votes
1 answer

LibreOffice Calc: check if cell is a formula

I want to implement some conditional formatting in LibreOffice Calc (v5.4.4.2 but can upgrade) that will highlight cells whose values are calculated through a formula rather than entered directly. For example, a cell containing =A3 will be…
Smoke
  • 275
  • 3
  • 11
6
votes
1 answer

Referencing a sheet by index number

I've got a LibreOffice Calc spreadsheet that I use to keep track of my accounts receivable at work. Each sheet lists invoices and their status (paid, unpaid, etc) as well as info about each invoice. I'm trying to create a Summary sheet that lists…
Lee Blake
  • 341
  • 1
  • 2
  • 15
6
votes
1 answer

Calling a python function from within LibreCalc

I have the following code inside a file called calculadora.py def calcpy(numA,numB): return numA+numB Which is the proper way of calling the function calcpy() from within LibreCalc? I'd like to put, say, in cell A1=calcpy(B1,C1) and obtain the…
Lucas Aimaretto
  • 1,399
  • 1
  • 22
  • 34
6
votes
2 answers

LibreOffice Calc: Is there a possibility to copy a background color from another cell?

I have created a table that has a value on one column that I have used to generate a background colour (Format -> Conditional Formatting -> Color Scale... -> Colour Scale). Now I would like that all the row to have that colour. Is it possible to…
sop
  • 3,445
  • 8
  • 41
  • 84
6
votes
1 answer

Libre Office Calc - csv import manipulate my float

when i import following csv file: test 413.298 it becomes in libre office calc: test 413298 is that a bug or what is going wrong? in the import preview it shows correctly, but after import, the comma is gone test-file:…
gebi84
  • 111
  • 9
6
votes
2 answers

Sum minimum of corresponding column values

I have two columns with numbers. I would like to calculate in a separate cell a sum. The sum will include the minimums of corresponding cells in these two columns. Example: A | B -------- [1] 1 | 2 [2] 4 | 3 [3] 0 |…
Thalis K.
  • 7,363
  • 6
  • 39
  • 54
1
2
3
…
57 58