**0**

votes

**1**answer

77 views

### Stop open office calc from entering in all pages at once

I must have click something by mistake. Now when I enter info in a single cell in one page, it ends up in the same cell in all of the other pages. How can I undo this please? Thanks very much.
...

**1**

vote

**1**answer

2k views

### Can two rows be reordered into one column in OpenOffice/LibreOffice Calc?

Is it possible in Open/LibreOffice Calc to take the values from a set of two or more rows, and display them in one column? In order words, make a separate column which derives its values from the ...

**1**

vote

**1**answer

77 views

### Can I use two cells in the same column as a Y axis in Libre/Open Office?

I have data arranged as following:
What I'd like to do is create a graph that looks something like the following (which I generated with graphics software):
So, for example, to generate the ...

**1**

vote

**1**answer

787 views

### Is it possible to create a chart in OpenOffice calc using columns and rows?

Is it possible in OpenOffice Calc to create a single chart where one set of data is derived from columns, and another set of data is derived from rows?

**1**

vote

**1**answer

588 views

### Is it possible to create a combination line and area chart in OpenOffice Calc?

Is there a way to create a graph that is a combination of lines and areas in OpenOffice Calc?
Currently the only way I know how is to make two charts, make the background of one transparent, and lay ...

**0**

votes

**1**answer

153 views

### Math function: What's the “this line” placeholder?

When I want to multiply a field I can say =J9*K9.
But what if I want this over a selection of rows? I've selected Line 6-25 and for all I want to say =J{THIS_LINE_NUMBER}*K{THIS_LINE_NUMBER}*.
How ...

**2**

votes

**1**answer

2k views

### Sort Numerically in OO Calc functions alphabetically

Using Open Office 3.3.0
Calc will sort a list of numbers not in numerical fashion, as would seem reasonable, logical, and rational, but in alphabetical order.
Eg: Calc thinks that 103,1000,etc come ...

**1**

vote

**1**answer

830 views

### Calc - How to combine rows from multiple sheets into 1 main sheet

I have several statements separating my various bank accounts in Calc, they all use the same columns and have a Date column which I sort them by.
I want to create a 'Overview' sheet which contains ...

**0**

votes

**1**answer

848 views

### how to find cells that have a certain text in open office's calc (excel might work also)

I need to calculate averages on my expenses spreadsheet, so I figured out I could do something like this:
- get all cells that have the text "electric bill"
- get the cell at the right of that one, ...

**3**

votes

**1**answer

1k views

### How to set 2 conditions / criterias for VLOOKUP / LOOKUP / etc in OpenOffice Calc (or Excel)

I have this spreadsheet that started as a silly aid for a game (Mafia Wars 2), but grew into a tricky spreadsheet question.
In the game your character have 9 "slots" for weapons and armors, 1 for ...

**2**

votes

**0**answers

163 views

### How do I capture filter information from a DataPilot table?

In OpenOffice Calc, how do I capture filter information from a DataPilot table?
Specifically, I have a DataPilot table which I graph on a chart, filtering on a field not appearing in the table.
I ...

**0**

votes

**1**answer

3k views

### OpenOffice Calc - how to insert BLANK in a formula?

In Calc, as in most spreadsheet applications, an IF() function exists that can be used to control behaviour, for example inserting this formula in cell C1.
=IF(A1>B1;"A";"B")
will display A in ...

**1**

vote

**1**answer

234 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

610 views

### How can I bypass the import dialog when opening CSV with OpenOffice?

A (Python, but that's not really relevant) script I'm writing will issue a command line call to open a CSV file with OpenOffice (OO). I need OO to skip over the import dialog box while opening the ...

**2**

votes

**1**answer

317 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 ...

**4**

votes

**1**answer

2k views

### Saving to CSV file always adds quotation marks in OpenOffice

I'm trying to use OpenOffice Calc for editing CSV files with TAB as delimiter. No matter what I do, Calc is insisting on adding quotation marks (") to the strings. If a cell content is number only, ...

**1**

vote

**1**answer

3k 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 ...

**1**

vote

**2**answers

327 views

### Advanced spreadsheet auto-formatting

Is it possible to autoformat spreadsheet like this
IF A1 = C1 then A1:E1 cells background becomes light gray
I use OO Calc, but it's ok if you know how to do it in MS Excel or Google spreadsheet

**3**

votes

**1**answer

1k views

### How do I make a random selection in a spreadsheet using more than one criteria

I have a spreadsheet created in OpenOffice (V3.3.0 in Windows 7 32 bit) that I use as a database of my DVD collection. After asking a question in SuperUser, I have it so it can pop up a random title ...

**0**

votes

**1**answer

1k views

### How can I determine if a number is between two values in OpenOffice Calculator?

I'm trying to write a formula that will do different things depending on which number range the number inputted to it lies in.
If the number is between 0-40 inclusive, I want it to return 0.
If the ...

**0**

votes

**1**answer

808 views

### How can I make a bar chart in OpenOffice Calc where the bars have two different colors to signify two different types of products?

I'm sure most people have seen the Intel vs. AMD charts that places like TomsHardware.com use, but just in case you haven't, here is my chart:
I want the PV bars in black, and the Solar Hot Water ...

**1**

vote

**1**answer

940 views

### Cell value string to Int in OpenOffice Calc?

I have "1 hour", "2 hours", in a column in Calc, and I would like to extract the numbers only. I've tried VALUE(A9), but it doesn't work.

**3**

votes

**2**answers

1k views

### Open Office Calc - Round to 5?

Is there a way I can have a cell round a number to the the nearest 5?
For example, the number 114 would round to 115, or 62 would round to 60

**2**

votes

**2**answers

2k views

### Get adjacent column value in OpenOffice.org Calc

I'm trying to get the value of adjacent columns in OpenOffice.org Calc.
I have several rows, each with a column that should have its value incremented by one when a column immediately to the right ...

**8**

votes

**4**answers

7k 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.

**0**

votes

**1**answer

284 views

### OpenOffice Calc getting slower and slower

I am running OpenOffice 3.2.0 Calc on my Ubuntu (10.04) desktop. I have a huge data entry task to complete today and Calc is getting slower and slower moving between cells on the sheet.
When I rename ...

**0**

votes

**2**answers

5k views

**2**

votes

**2**answers

2k views

### Sorting in Calc: how to make column headers become dropdowns menus for sorting

In OpenOffice Calc, the only feature I miss from Excel is the ability to create those dropdown dialogs to sort data:
Does OpenOffice Calc have the same feature and I just missed it?
Note: I know ...

**1**

vote

**0**answers

481 views

### Copy “true” value from OpenOffice (for pasting in external app)

Is there some way to get OpenOffice Calc to copy the real value stored/calculated in a cell. I realize it must still be text, but is there some way to get OpenOffice to copy a higher precision value ...

**0**

votes

**1**answer

455 views

### summing data in Open Office Calc

I have a huge data containing time in the following format
0055:24
0020:24
0034:24
0025:24
There are 50,000 records that need to be added up all these time.
Is there a quick macro for Open ...

**2**

votes

**1**answer

541 views

### Copy only cell content in OOCalc

In OOCalc, when I copy a cell with ctrl-c ctrl-v, it copies everything, also the style, from source to destination.
However, I want to copy only the content, leaving the formatting of the destination ...

**4**

votes

**2**answers

670 views

### How can I split a formula into multiple lines in OpenOffice calc?

I have this simple formula:
=CONCATENATE("foo";"bar")
which renders foobar on the cell.
How can I lay this formula in multiple lines in the same cell? I'd like to be able to do something like the ...

**1**

vote

**1**answer

4k views

### How to conditionally highlight cells in OpenOffice Calc?

I have a big chunk of data in an OpenOffice spreadsheet. To make real information standout more, I would like cells with an absolute value over a certain threshold to be highlighted in red.
Is there ...

**5**

votes

**1**answer

2k views

### Copy value in Open Office Calc

I have a handful of cells in several spreadsheets that contain =AVERAGE(<some range>) and when I try to copy them into another spreadsheet I just copy the function and get #REF!.
Is there any ...

**0**

votes

**1**answer

831 views

### How to add a line between every two rows in a spread sheet?

I was wondering in Openoffice Calc spreadsheet, how to add a line between every two rows? I want to print a spreadsheet, with a line separating every two rows.
Thanks and regards!

**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 ...

**0**

votes

**1**answer

414 views

### Count the number of contiguous empty cells at the end of a row

I have rows of data, some cells are empty and some contain a number. I need to identify how many contiguous empty cells exist at the end of each row.
I've tried using a string of nested IF ...

**1**

vote

**1**answer

410 views

### How can I open a subset of a large (35MB) .xlsx file?

I have Ubuntu 10.04 running on a Dell Optiplex with 4GB of memory and two 3.16GHz processors.
I received a 35MB spreadsheet. It opened in Gnumeric after 5 minutes with errors, and it hasn't opened ...

**6**

votes

**2**answers

7k views

### How do I export the charts in a spreadsheet as PNGs?

I made a spreadsheet and generated some graphs in Calc. I would like to grab each chart as a PNG (JPG will be fine too) and save them as an individual file so I can post the charts on my blog.
I ...

**7**

votes

**1**answer

1k views

### OpenOffice.org calc: how to dynamically update a data range for a graph?

I have an OpenOffice.org spreadsheet that contains a number of graphs. As I append more data to this spreadsheet, I want to update all the data ranges in those graphs, basically changing A1:A100 to ...

**0**

votes

**1**answer

59 views

### How to list people below the average in Excel/OpenOffice?

I have a spreadsheeet that shows a list of people and how many appointments have been booked for each of them in the past week.
It looks a bit like this:
I want to make a list underneath that ...

**3**

votes

**4**answers

3k views

### is text from a cell in a column?

I have some values in a column A. I want to have a formula next to each value in a column B that would tell me if text from column A is in any of the cells from columns C.
I tried match, search but ...

**1**

vote

**2**answers

144 views

### How to go to generated url with keyboard?

I create links in Open Office Calc, and i can use them with
mouse.
Can i open those links with Keyboard?

**13**

votes

**5**answers

42k views

### How to create a formula for every row in a column in Google SpreadSheet?

I use three columns. A, B and C.
In column C I have a formula every row =A1*(1.6*B1) and then for the next row I have =A2*(1.6*B2) in C2.
How can I do so I don't have to type in the new formula in ...

**0**

votes

**0**answers

550 views

### openoffice-calc, drop-down-list, avoid duplicates

In openoffice-calc, one can create an drop-down list via Data > Validity, and selecting a Cell-range. If my Cell-range contains duplicates, I have also duplicates in my list. Is there a way to avoid ...

**0**

votes

**2**answers

201 views

### How can I stop focus from moving to a new cell when I use autocomplete in OpenOffice?

In OpenOffice Calc, when I type in a cell, the program can sometimes autocomplete the information from earlier rows in the same column. I can hit Enter to accept the completion and move to the next ...

**2**

votes

**1**answer

2k views

### What syntax allows the condition in OpenOffice's SUMIF function to match a regular expression in a different cell?

What syntax allows the condition in OpenOffice's SUMIF function to match a regular expression in a different cell?
For example, suppose the cell A1 contains a regular expression. How must the ...

**4**

votes

**1**answer

2k views

### OpenOfficeOrg Calc: enter data into all selected cells?

I want to enter the same data (e.g. "superuser") into multiple cells in OpenOffice.Org Calc (version 3.3.0). In order to do so, I select all the cells I want the data to be entered in. However, only ...

**3**

votes

**1**answer

981 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 ...