**0**

votes

**1**answer

143 views

### Why is Openoffice Calc automatically rounding the sum of two sums?

I have two columns which have been summed. When I sum the two cells with those results, openoffice rounds the sum every time. If I only enter two numbers and then sum them, it operates normally. ...

**2**

votes

**1**answer

1k views

### Autocomplete only on demand in OpenOffice Calc

In Open-/Libreoffice Calc, it is possible to enable the auto-completion of cells. That means the cell is filled e.g. with a string that starts with the characters already typed. This may give unwanted ...

**0**

votes

**1**answer

912 views

### How can I use extremely large numbers in my spreadsheet programs?

If I try to calculate large exponents in LibreOffice Calc or OpenOffice.org Calc, the results come out to be erroneous. See these two examples where I calculate 13^18,
Using LibreOffice Calc
Using ...

**0**

votes

**1**answer

254 views

### Pasting data in openoffice Calc

I want to paste data in Openoffice Calc but it doesn't seem to work.
The example with the first row (of 124 rows), this is the data in a .dat-file:
0.592 0.349 1.333 0.617
When I want ...

**1**

vote

**1**answer

771 views

### OpenOffice Calc - How to substitute multiple characters?

I need to substitute non-English characters in French words to the closest English charachers. For example:
"Combien ça coûte" Becomes "Combien ca coute"
I also need to remove some punctuation. Is ...

**18**

votes

**2**answers

28k views

### How to color rows based on cell value in Open/Libre Office

How do you automatically set the background color of an entire row based on the value of a specific column in that row in Open/Libre Office? There are similar questions for Excel, but this doesn't ...

**0**

votes

**2**answers

507 views

### Open/LibreOffice Calc data “extend selection” stops at blank rows

I have a spreadsheet and have right clicked on a column header then selected Sort from menu. The dialog box provides an option to extend the selection, which I accept. The problem is that the ...

**2**

votes

**1**answer

619 views

### Find the Nth instance of a text string within a range?

I have a list of names next to a list of shifts. I want to collate a list of people on each shift by day, which will automatically and dynamically update. I can't work out the best way to do it.
In ...

**1**

vote

**1**answer

161 views

### Database workflow advice? [closed]

I've got a product database that I need to update a couple of times a week and am looking for some advice on what workflow I should setup. I can export my database from my online store as a CSV, I ...

**2**

votes

**1**answer

794 views

### LibreOffice Calc - apply style to neighbouring cells

I have a column with data and I applied a style to it with the help of Conditional Formatting. I now wish to apply the outcome of that style to the neighbouring column that holds other data.
Here is ...

**1**

vote

**0**answers

180 views

### How to disable command+scroll zooming in openoffice calc

Is there anyway to have command+scroll in OSX do nothing instead of scrolling? I press the keyboard shortcut all the time and it throws my focus off. I have looked extensively in forums, but often the ...

**1**

vote

**1**answer

545 views

### Getting date of last change as a cell value in Open Office Calc

I have a few Open Office spreadsheet files (let us call them source files), each containing the financial info of a particular office of ours. I also have a summary spreadsheet, that reads some key ...

**2**

votes

**2**answers

197 views

### OpenOffice Calc regex returns wrong value - what's wrong with my regex?

I have a column of text with values concatenated by my bank, as in a typical monthly statement.
Here is an example (column A240):
OCT 26 BALANCEPROTECTOR PREMIUM $10.05
I'm trying to set the ...

**0**

votes

**3**answers

4k views

### How to change the hh:mm:ss format in spreadsheets

Currently, I have a data set which is "mm:ss" and needs to stay / be calculated that way.
The problem is, Microsoft Excel, Google Spreadsheets and OpenCalc all interpret "mm:ss" as "hh:mm" and to add ...

**1**

vote

**0**answers

507 views

### OpenOffice Calc: Cell Background/Border Color

I am trying to create a spreadsheet with colored cell backgrounds. But I encountered this strange bug, where the background of a cell is bigger than the shown border, so coloring a cell will actually ...

**0**

votes

**1**answer

152 views

### How to format a date in Calc?

When I enter 09/02/2013 00:00:00 in a cell in Windows 7, the cell displays 02.09.2013 00:00.
I have specified the proper Format code in Format Cells:
In Windows XP, the outcome is as expected. The ...

**0**

votes

**1**answer

36 views

### Looking for suggestions on how to arrange 7900+ lines of text in Calc

I have a dataset with the complete text of the Greek Novum Testamentum (New Testament); see an image here.
Each line is one verse. I will find the book and chapter boundaries with the help of these ...

**1**

vote

**1**answer

102 views

### How is the LOOKUP function named in German? [closed]

The english version of OpenOffice Calc does have the function LOOKUP.
How is this function named in German (Deutsch)?

**2**

votes

**1**answer

5k views

### Libreoffice calc relative and absolute cell reference on copy-paste

I'd like to create a simple Calc sheet, where column A contains the days, B contains how many hours of work i had done and C the price for that day. The price is simply a multiplication of hours (B ...

**1**

vote

**1**answer

891 views

### Binary spreadsheets with bitwise operators [closed]

I am looking for a way to easily construct binary spreadsheets using bitwise operators such as SHIFT, AND, OR and XOR.
I've looked at Gnumeric but can't find any function that'd allow you to set the ...

**0**

votes

**2**answers

103 views

### OpenOffice.org Lowercases second capital letter

How can I turn of the feature in OpenOffice.org Calc which converts CCleaner to Ccleaner?

**0**

votes

**1**answer

209 views

### Split sheet by rule (filter) in Open Office

I want to split a large sheet. I have different products and for each of them I would like a new file. Is it possible to split the sheet by some rule?
P.S. I am new in here, so if my question is ...

**0**

votes

**1**answer

81 views

### Get frequency distribution of several columns partitioned by one other column

I'm doing some basic survey analysis. I want to break down responses to various questions based on Male or Female. Each row is a response, each column is a question. Column A has the Male/Female ...

**1**

vote

**0**answers

166 views

### In Open Calc, how do I copy a paste cells that contain references to other workbooks?

I have an OpenOffice Calc sheet with cells containing formulas that refer to another file, e.g: 'file:///C:/path/to/other.xls'#$Sheet1.A1:B2.
When I copy the cells from one sheet to another in the ...

**2**

votes

**1**answer

2k views

### Spreadsheet VLOOKUP: Search in second column and return first

In Excel or OpenOffice calc I have
| Foo | Bar |
+-----+-----+
| A | 1 |
| B | 2 |
Is it possible to use VLOOKUP to search a value in the Bar column and return the value in the Foo column?

**0**

votes

**1**answer

473 views

### Where is openoffice.org add-on located after installed (Ubuntu)?

I installed a tool which now appears in Openoffice Calc under Tools->Add-ons.
I thought that this tool would appear in ~/.openoffice.org/3/user directory, but I cannot find it.
I am especially ...

**1**

vote

**2**answers

3k views

### Open Office crashes, recovers, crashes again

After completely reinstalling my laptop due to apparent registry corruption, I've encountered a problem with Open Office:
I open a simple Calc spreadsheet, it comes up normally, but then after ...

**1**

vote

**1**answer

108 views

### OpenOffice Calc - getting ### as the result to a formula

So I've got a spreadsheet with around 5 different rows, each one with a specific value (specifically a range of cells E2 - E8) and a "Total: " cell at the bottom, whose formula is this:
=Sum(E2:E8)
...

**0**

votes

**1**answer

1k views

### How to make LibreOffice Calc to connect points in a holed series chart with lines?

I've got a time series data table with one function (row) value available for every month and the second for every 3rd month (every quarter), having holes (empty cell values) for every 2nd and 1st ...

**3**

votes

**4**answers

5k views

### Finding min/max values in column where cell matches something

I have a spreadsheet laid out kind of like this:
Date Project#
2012-01-01 130
2012-01-02 153
2012-01-03 153
2012-01-04 130
2012-01-05 130
2012-01-06 130
And I want to get ...

**2**

votes

**0**answers

639 views

### OpenOffice Calc weighted average

I need to find the result of
((C1 * 5) + (C2 * 4) + (C3 * 3) + (C4 * 2) + (C5 * 1))/(5*6/2).
I need to do it for 200 columns, not only 5. I currently use two sheets with sheet 2 containing a ...

**3**

votes

**2**answers

617 views

### Modify value of a cell using the old value as part of the new one?

I have a table in which row 2 has tons of columns. Each of those columns in row 2 has a varying value in the range of 1-1000000 represented by X in the example below.
How can I add modify the cells ...

**3**

votes

**2**answers

3k views

### Excel/Calc/Whatever: Flip my axes - ie reflect my table across the diagonal

Lets say I have a table and I want it flipped across the diagonal. So instead of X by Y its Y by X...
Before:
A B C
RED 1 2 3
BLUE 4 5 6
...

**2**

votes

**2**answers

2k views

### OpenOffice Calc - Highlighting the higest value in a column

So I've got this spreadsheet open using OpenOffice Calc (ver 3.3.0) and its set up a little like this:
A B C D
1.name quantity price total
2.foo 10 ...

**1**

vote

**1**answer

260 views

### Delete cell content in Libre (Open) Office based on the cell value

I have a huge csv file (tens of thousands of rows) that I need to filter based on different criteria. After trying to find a proper CSV editor, I decided to use LibreOffice Calc. CSVed is great, but ...

**0**

votes

**1**answer

1k views

### How to parse numeric prefix on string in Open Office Calc?

In Open Office Spreadsheet I have cells with strings like "123kg" "3,45m" "0,5g" "345apples" etc.
Which is the function that can parse the numeric prefix on these numbers? So I get "123" "3,45" "0,5" ...

**1**

vote

**1**answer

417 views

### Drop down List Not working in Open Office

i have created a file using MS Excel and saved the file as ODS but it will open on read only mode works perfectly but once i saved the file drop down list not working

**4**

votes

**1**answer

6k views

### Open Office Calc: Convert a date to timestamp

I have a column with dates in M/D/Y like this:
8/8/2007
8/9/2007
8/10/2007
8/13/2007
8/14/2007
8/15/2007
8/16/2007
I would like to convert them to a unix timestamp (in a new column). Would anyone ...

**1**

vote

**2**answers

4k views

### 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)
...

**1**

vote

**0**answers

42 views

### How do I insert a rowbreak with OOo Calc macro Basic

With OOo, how can I insert a rowbreak in Calc using a Basic macro?

**4**

votes

**1**answer

8k views

### How to reference variable sheet in OpenOffice Calc?

I want to reference a cell in another sheet, and the formula I get when pressing = followed by changing sheet, clicking on the cell and pressing Enter, gives me
'Sheet2'.A2
Which is fine, except ...

**1**

vote

**2**answers

29k views

### Pull row of data from one place in spreadsheet to another

I have a list of names and their assorted properties.
I am trying to find a way to quickly move an entire row's worth of data into a different sheet so I can manipulate it.
Currently I can ...

**1**

vote

**2**answers

2k views

### Open Office Calc time to decimal

My task is very simple but I cannot figure out how to do it.
I am setting up a time sheet in OpenOffice Calc with 3 columns. The first two columns are Time formatted columns that represent my start ...

**0**

votes

**1**answer

1k views

### How can I convert LDAP Timestamps in Libra Office to a date time format

If I query the directory, I get the following results.
ldapsearch2.4 -x -b "dc=localhost,dc=com" "cn=auser" "+" | grep stamp
createTimestamp: 20100407122221Z
modifyTimestamp: 20100407122221Z
...

**2**

votes

**2**answers

2k views

### unable to use datediff function in apache openoffice calc

I am unable to get a result by using this command =DATEDIFF('dd', '2007-08-01', '2007-09-01') in apache openoffice calc.
Even using two columns of dates and using the formula ...

**6**

votes

**3**answers

6k views

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

**2**

votes

**1**answer

3k views

### Retrieve content of different cells based on input

I have a cell X where the user can enter a number. I then need to take that number N and get the value of another cell Y based on that.
The scenario is this:
The user can enter a product number and ...

**17**

votes

**10**answers

39k views

### Export Excel graphs as vector graphics files (e.g. SVGs)?

How can I export a graph generated in Excel as an editable vector graphics file, e.g. a SVG?
When I right click on a graph in Excel the 'Save as Picture...' option only gives non-vector formats (like ...

**0**

votes

**2**answers

740 views

### Spreadsheets: How do I perform functions on a set/array described by a row of (count, value) pairs?

I have excel 2000, google docs, and the latest open office calc available to me. I'm after a solution in any of those, ideally.
I have a multiset of data described by rows of (count, value) pairs. ...

**0**

votes

**1**answer

391 views

### How do I get numbers before and after a colon within a cell in Calc?

I have some cells which contain times entered in by users, which are written in the following format: mm:ss. There are never any hours. The seconds always have leading zeroes. The minutes may or may ...