Spreadsheet component of the LibreOffice suite
Questions tagged [libreoffice-calc]
722 questions
80
votes
4 answers
How to color rows based on cell value in OpenOffice and LibreOffice
How do you automatically set the background color of an entire row based on the value of a specific column in that row in OpenOffice and LibreOffice?
There are similar questions for Excel, but this doesn't completely work in LibreOffice.
I can set a…
Cerin
- 9,652
43
votes
6 answers
How to remove a plain text protecting single quote from all the selected cells in LibreOffice Calc?
I've imported a CSV file having the first column to be date-time values in ISO 8601 format like
2012-01-01T00:00:00.000Z
for the first moment of the year 2012.
Then, willing to make LibreOffice to recognize the format (as I was looking forward…
Ivan
- 7,863
43
votes
4 answers
LibreOffice Calc: How to get total for HH:MM:SS cells
I'd like to take a group of cells in the HH:MM:SS format, and add them up. I don't want to have the value wrap on the 24 hour clock. I just want an absolute total of the values. (The sum function seems to wrap by default).
So if I…
mtyson
- 719
37
votes
2 answers
How do I create a sum for each group of data in Libre Office Calc?
I have a simple spreadsheet like this:
Invoice_Number Invoice_Date Invoice_Amt
1000 1/1/12 1
1001 1/1/12 2
1002 1/2/12 3
1003 1/3/12 4
How…
Chris Curvey
- 1,537
37
votes
4 answers
How to set decimal separator in LibreOffice Calc?
How do I set the decimal separator in LibreOffice Calc?
I want the decimal separator to be dot (.), not comma (,):
I want to set this system-wide and as default. I don't want to set this for each cell.
Dims
- 13,414
31
votes
8 answers
How to add month to date in LibreOffice calc
This seems like an obvious question.
I have a date column, and I want to create a formula to increase it by one month for each column.
10/2013, 11/2013, 12/2013, 1/2014, 2/2014, ...
How do you add one month to a date?
trimbletodd
- 509
26
votes
4 answers
how to get Libre Office to adjust row height to accommodate text entry?
I need for LibreOffice to automatically adjust row height for text entries.
I have tried to acomplish this by checking the wrap text option, which I thought would be the solution, but it is not.
How can I do that?
user212236
- 261
- 1
- 3
- 4
22
votes
2 answers
Equivalent for FILTER() formula in Libre Office
In a Google Spreadsheet, I create a report sheet by entering a formula like this in the top left cell.
=FILTER(Sheet1!A2:E, Sheet1!E2:E > 0)
This gives me all the rows in the Sheet1 from row 2 downwards where the value in column E is greater…
Keith
- 588
21
votes
1 answer
What is in LibreOffice Calc the equivalent to Excel's "Paste Special > Value"?
In my professional life, I'm limited to use Microsoft Office. In Excel there is an option ows to render the result of a formula to be pasted as a "fixed value".
For instance A1 = "I",B1 = "ride", C1 = "a" and D1 = "bike"
In E1, I can place a formula…
Rob Rijsdam
- 211
19
votes
4 answers
How do I get a chart in LibreOffice Calc to have regular time intervals when the data is not regular?
I have an area chart in LibreOffice Calc where I would like the X axis to be measured in one month intervals spaced evenly apart.
The data going into the graph, however, is not regularly spaced at one month. There can be zero, one, or two entries in…
Questioner
- 848
19
votes
1 answer
How do I get data or percentage displayed in libreoffice pie chart?
I need to get a pie-chart with values - can libreoffice do it?
Justinas Dūdėnas
- 628
17
votes
7 answers
How to get VLOOKUP to return the *last* match?
I'm used to working with VLOOKUP but this time I have a challenge. I don't want the first matching value, but the last. How? (I'm working with LibreOffice Calc but an MS Excel solution ought to be equally useful.)
The reason is that I have two text…
Torben Gundtofte-Bruun
- 18,646
17
votes
2 answers
LibreOffice pivot table group by month
Im having data like this:
Date Customer Amount Month
09-01-12 A 20 =A2 (formatted so it shows month name)
10-01-12 B 10 =A3 (formatted so it shows month name)
18-01-12 B 25 etc
05-02-12 A 15…
Lennart
- 287
17
votes
6 answers
Copy/Paste a formula in Libreoffice without adjusting the cells
I have a formula in Libreoffice Calc which I would like to move (Cut and Paste) to a different cell. I would like the formula to exactly stay the same without the cells in it being adjusted by the move. I cannot use static reference (using the $…
mat
- 1,046
16
votes
9 answers
How to find and remove external links in (Libre|Open)Office Calc spreadsheet
I have a LibreOffice Calc spreadsheet which pops up a message asking me whether I wish to update external links. I did not add external links myself, but did copy data from another Calc window at one point, after which this issue started. (I assume…
equaeghe
- 505