Super User Stack Exchange
Super User Stack Exchange

Questions tagged [libreoffice-calc]

Spreadsheet component of the LibreOffice suite

692 questions
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
  • 699
  • 2
  • 7
  • 12
33
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,427
23
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
  • 231
15
votes
1 answer

How do I join two tables with LibreOffice Calc?

I have two tables, each in it's own sheet in the same file: Name Age Alice 18 Bob 19 Carol 20 Dave 19 Name Gender Bob Male Dave Male Eve Female I want to automatically create a third table (sheet) that contains the joined data on the column…
Christian
  • 2,264
13
votes
5 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
  • 936
12
votes
2 answers

Libreoffice: sum of column except one cell

I want to calculate the sum of the A column excluding A1, because I want the result there. Illustration: A B C 1 =SUM(A2:Ainfinite) 2 1234 3 5678 ... I could write A2:A1048576 which would work to some…
Notinlist
  • 780
12
votes
2 answers

How to get number value with leading zeros in LibreOffic Calc?

How to get number value with leading zeros in LibreOffic Calc? FORMAT function does not want to work: I need value, not just formatting.
Dims
  • 12,713
11
votes
2 answers

Does libreoffice have a math concept like 'infinity'?

Does libreoffice calc have special numbers corresponding to -infinity and infinity similar to python's numpy? They would obey rules like: x = some number infinity + x = infinity -infinity + x = -infinity It would be handy sometimes to return such…
drevicko
  • 282
10
votes
5 answers

LibreOffice Calc: How to remove a character from multiple columns

For some reason, when I import data from a certain unnamed source (toggl.com), some of the time columns have an apostrophe in them. When I have this data loaded in Calc, is there a quick, easy way to remove these? The columns look…
mtyson
  • 699
  • 2
  • 7
  • 12
9
votes
5 answers

Currency conversion in LibreOffice Calc?

I have a *ods.-spreadsheet in LibreOffice. Some fields contain numbers in currency format (JPY), but they could also be in general number format. I want to create corresponding fields which display the amount of money in Euro and US$, doing the…
user50105
9
votes
9 answers

Quickly fill blank cells in a list in LibreOffice Calc

For example: Cell A1 = 2/3/2012        A2 is empty        A3 is empty        A4 = 3/7/2012        A5 is empty        A6 is empty        A7 is empty What I want to do is: select the complete list (A1 to A245), take some action (e.g.,…
Suryakant Singh
  • 91
  • 1
  • 1
  • 2
9
votes
2 answers

Default cell background in Calc

Whenever I create a new document with Calc the cell background is set to white. Therefore the first thing I must do before start working is modifying the background to an eye-friendly colour (usually just grey). Is there a way to set this default…
Luís de Sousa
  • 358
8
votes
4 answers

LibreOffice Calc SEARCH and FIND functions

I am trying to process some data in Calc. One of the steps involve finding if a certain string is part of one of the column. I tried using FIND and SEARCH functions. Both behave in the same way and I am not getting correct results. E.g. Say I have…
TTT
  • 81
7
votes
2 answers

How to lock a cell for editing in LibreOffice Calc?

How can I lock a cell, to prevent edits to its value for the foreseeable future?
timoseewho
  • 675
  • 4
  • 10
  • 17
7
votes
4 answers

Why does LibreOffice Calc ask about updating links in Excel 2007 .xls file when Edit | Links is disabled?

(I don't believe this is duplicate of LibreOffice Calc prompting to update “links to other files”. Why?. See below for why.) The title basically says it. I have an .xls file originally created with Excel 2007. As far as I'm aware, it doesn't have…
T.J. Crowder
  • 1,149
1
2 3
…
10 11