Spreadsheet component of the LibreOffice suite
Questions tagged [libreoffice-calc]
667 questions
65
votes
3 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
- 8,746
- 16
- 54
- 65
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
- 689
- 2
- 7
- 12
42
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,293
- 28
- 70
- 99
31
votes
5 answers
How to set decimal separator in Libre Office Calc?
How do I set the decimal separator in Libre Office Calc?
I want the decimal separator to be dot (.), not comma (,):
I want to set this system-wide and as default (don't want to set this for each cell).
Dims
- 12,244
- 78
- 161
- 252
30
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,347
- 2
- 13
- 18
28
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
- 479
- 1
- 4
- 7
22
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
- 221
- 1
- 2
- 3
20
votes
1 answer
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
- 568
- 7
- 16
20
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
- 201
- 1
- 2
- 4
18
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
- 618
- 5
- 9
- 23
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,100
- 39
- 108
- 145
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
- 277
- 1
- 2
- 8
17
votes
3 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
- 798
- 3
- 12
- 32
15
votes
1 answer
How to scale a long LibreOffice Calc sheet to fit on two pages when exporting to PDF?
I have Libreoffice and I want to export a long calc sheet to a pdf document with the fit-to-page function from the page preview in the file menu but it doesn't seems to work. I want to fit my sheet up to 2 pages because it's unreadable otherwise.…
Micromega
- 1,914
- 7
- 33
- 43
14
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
- 445
- 1
- 5
- 14