Spreadsheet component of the LibreOffice suite

**1**

vote

**1**answer

735 views

### How to copy & paste from a cell in Libre Office Calc

I have an Excel format spreadsheet that was sent to me by a colleague. It's a list of test usernames for an app we're building.
When I try to copy one of the usernames or passwords from the cell in ...

**0**

votes

**1**answer

2k views

### Adding times in the format hh:mm:ss with sumif in Libreoffice-calc?

Suppose I have a column which contains time-deltas in the form hh:mm:ss. Now I want to add those times using sumif and get the total time in the format hh:mm:ss, too. Is there a way to do this in ...

**1**

vote

**1**answer

261 views

### LibreOffice Calc function localization

I'm using LibreOffice 3.4.3 on Lubuntu. The locale I'm using is es_AR, I installed LibreOffice with sudo apt-get install libreoffice, then installed the Spanish language package with Synaptics ...

**3**

votes

**1**answer

5k views

### Can you use infinity in a cell reference in LibreOffice (or any other spreadsheat)? [duplicate]

Possible Duplicate:
Can you reference an entire column in OpenOffice Calc (like A:A in Excel)?
I'm using a Sum of a column, and it keeps growing, so I have to update the reference to which ...

**6**

votes

**3**answers

3k views

### Working with lots of data in LibreOffice

I have 150000 observations, which I am trying to work with in LibreOffice (new name for OpenOffice.org). The main thing I want to do is to have some formula calculated for all of these observations. ...

**0**

votes

**1**answer

3k views

### Copy chart from Calc spreadsheet to Writer document without linking in Libreoffice?

I've copied a chart in one of my Libreoffice 3.4.3 Calc spreadsheets into a Writer document in Mac OS X 10.6.8. However, I've noticed that the chart in the Writer document is linked to the one in the ...

**1**

vote

**1**answer

254 views

### Rearrange cells in a Open Office spreadsheet, from data in cols to data in rows

I have this spreadsheet (Open Office) and all the data is filled in so they form a col,
and I would like to change this so they fill a row instead.
Kind of mirror the doc in both axis.
This is how ...

**2**

votes

**1**answer

335 views

### Are there nonlinear optimization implementation for OpenOffice Calc?

Are there nonlinear optimization implementation for OpenOffice Calc?
I found one: http://extensions.services.openoffice.org/project/NLPSolver . But the methods provided there are evolutionary ...

**1**

vote

**1**answer

4k views

### How do I create a line graph which ignores zero values?

I want to create a graph showing trends over time, calculated from a formula of various data.
However, some data is missing, resulting in zeroes in the calculated data which the chart uses.
When ...

**7**

votes

**3**answers

3k views

### Permanently and globally stop openoffice calc from autocorrecting dates/time

When I type "15:45" or "21/12" openoffice Calc changes it to "15:45:00" and "21-12-2011".
How do I disable this globally and permanently?
I know you can use "Format cell..." and then select text, but ...

**2**

votes

**1**answer

242 views

### how to get Libre Office Calc to tell me when there are invalid characters

I have a spreadsheet in XLSX format that was generated by a python program. it turns out that the python program had left some invalid characters in the file. When I open the file in Excel, it at ...

**1**

vote

**2**answers

2k views

### Calculate sum of products in LibreOffice Calc

I am not that proficient in using Excel/Calc and I have a simple question.
I have a table of my studies, my grades and the respective credit points on those.
study grade cp
a 2.3 8
b ...

**1**

vote

**1**answer

242 views

### How to sum the multiplications of rows, being the multiplier variable in a spreadsheet

I have this spreadsheet:
I want to calculate the total income, but since the different rows are in different currencies the conversion must be done first. The currency values are mapped to codes in ...

**9**

votes

**4**answers

8k views

### How to set the default font in LibreOffice Calc?

How do you set the default font used in new documents of LibreOffice Calc? I am using LibreOffice 3.3.2.
Some answers below have been updated for LibreOffice 4 as well.

**3**

votes

**3**answers

3k views

### Adding a constant in LibreOffice Calc

How do you add a constant to a group of cells in LibreOffice Calc?
For example, here are four cells:
47 28 35 62
Now add 3 to each cell:
50 31 38 65

**3**

votes

**2**answers

4k views

### Calculations in terms of degrees minutes seconds in excel , libreoffice/openoffice or any other free spreadsheet

My dad's gotten into astrology, so he needs to do calculations for it - and most books use the Degrees Minutes Seconds nonmenclature - is there any way to set excel or open office calc to handle ...

**3**

votes

**4**answers

16k views

### How to separate number by its decimal point in Excel/Calc?

I've got a number in a spreadsheet like so: 28.686279
When I open this sheet in either LibreOffice Calc or Microsoft Excel, is there a formula function that returns the "whole number", I.e. 28. Also, ...

**1**

vote

**1**answer

462 views

### Any way to make interactive graphs in LibreOffice like Google Doc's Trend chart?

Google Docs has a nice trend viewer that can be created just like any other chart:
Is there any way to get an interactive graphic like this in OpenOffice? Manually adjusting the axes is really ...

**1**

vote

**2**answers

697 views

### How to make LibreOffice Calc to not to hide unfit content of a cell when the folowing cell contains data?

If I enter a long string into a cell it (the string) is normally displayed in its whole, taking a part of the next cell area. Line A (1) on the picture below is an example.
If I enter a long string ...

**1**

vote

**1**answer

125 views

### Incremental search in libreoffice-calc

Is there an incremental search feature in libreoffice-calc similar to that one in emacs or firefox?

**3**

votes

**1**answer

1k views

### Open Source Spreadsheet with Sensitivity Analysis

Is there any good Open Source spreadsheet program that has a solver for linear programs (either included or via an extension) that does a proper sensitivity analysis (shadow prices etc)? It seems like ...