**0**

votes

**1**answer

14 views

### How to copy/paste values in OpenOffice

I have inserted the formula =today() which gives me today's date.
I want it to be retained tomorrow as today's date.
In Excel I would use Copy / Paste Values to overwrite the formula with the ...

**0**

votes

**0**answers

20 views

### Rearrange columns from fiscal year to calendar year in OpenOffice spreadsheet

I have twelve monthly columns plus a total column in a spreadsheet that was originally created for an April through March fiscal year. Now I need to rearrange the columns for a calendar year, without ...

**1**

vote

**3**answers

89 views

### Get DayName from Date in OpenOffice Calc?

I am having difficulty getting the day name from OpenOffice Calc. I am able to get the day Number representation from a date with the following
WEEKDAY("2008-06-14"; 1)
which returns
7
As we ...

**1**

vote

**2**answers

28 views

### Calculate the SUM() time from columns with mixed types

Consider the following table:
+------------------+------+--------+
| Total worked | Total| Tasks |
+------------------+------+--------+
| 07:30| 09:20|Day 10 |
...

**-2**

votes

**0**answers

10 views

### write lookup formulas. Never written one before

Can someone please give me a dummy example of how to write lookup formulas. I want a doc to look up another for just numbers.

**0**

votes

**1**answer

9 views

### OpenOffice Calc - 11 Pages in spreadsheet, but print interface only shows 2

I am working on a spreadsheet using OpenOffice and need the pages to be printable.
You can print the first two, but thats it. If in the print interface I select all sheets it only shows 1 and 2 with ...

**0**

votes

**2**answers

46 views

### Using ISBLANK formula to write a variance

I've got a formula or a plan £ in C4, and the actual £ to be entered in D4 cell. E4 contains the formula D4-C4.
I would like E4 to be blank until both C4 and D4 have values.

**0**

votes

**1**answer

60 views

### How to plot IP address frequency distribution chart on Excel or Calc?

I have one column of data:
IP Address
1.2.1.2
1.2.1.2
1.3.4.1
1.3.4.1
1.3.4.1
1.3.4.1
1.3.4.1
1.10.0.5
1.10.0.5
1.10.0.5
2.1.2.1
2.1.2.1
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
12.1.2.3
...

**0**

votes

**0**answers

6 views

### Use formula to copy cell data/formula to another cell

I'm trying to use Libre Calc's formula functions to copy data and formulas from cell A1 to B1 given certain data in A2. I've searched Calc's help/docs but don't see anything.
The closest is the VB ...

**0**

votes

**1**answer

28 views

### link data from another .ods file

I'm using openoffice calc and I have 2 .ods files (complete.ods and summary.ods).
I have 1 cell from summary.ods which depends on complete.ods. I managed to get the value by using this formula:
...

**0**

votes

**1**answer

87 views

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

**-1**

votes

**1**answer

135 views

### How to remove Open Office spreadsheet duplicates in a column while keeping rows together?

I have a spreadsheet with a list of column data of contacts, first name, last name, address, phone number, email...
I want to remove the duplicate email addresses but the entire row may not have ...

**0**

votes

**1**answer

50 views

### LibreOffice Calc Error 518

I'm trying to achieve the following in LibreOffice (did it with Excel already, but importing this excel-created file produces the same error).
I have 3 columns
(A) (B) (C)
ECTS Mark ...

**1**

vote

**0**answers

21 views

### How to pull all rows containing the same date into a new sheet in OpenOffice Calc

I have 15 spreadsheets (one for each client); each has a column for the date and then additional information in the other columns such as 'action' and 'time spent'. This allows me to see all the work ...

**2**

votes

**1**answer

21 views

### Clear cell changed metadata in OOO Calc

I am trying to figure out how to clear the red highlighting around cells in Calc (OpenOffice 4).
Here is an example:
It is not affecting my work but I would like to clear them as they are ...

**0**

votes

**1**answer

36 views

### Open Office Calc, Round up or down

I'm trying to output retail prices rounded to either a 4 or an 8 from various formulas
Is is possible to round one figure to the nearest of each of these?

**0**

votes

**0**answers

27 views

### Open Office: Simple Chart with dates/numbers?

I'm using OpenOffice Calculator.
I have some data like this:
Date | Messages
Jun 2 2011 | 345
Jun 4 2011 | 212
Jun 5 2011 | 221
I'd like a very simple graph with the dates on the x-axis and ...

**1**

vote

**1**answer

26 views

### calc: Extract string from range of cells

I´m trying to figure out a easy to understand way to extract a string (that is in a range of cells) from a range of cells...
That is the range of cells I have to look for a specific string (in a ...

**0**

votes

**1**answer

277 views

### OpenOffice Calc - calculating percentage for every cell in a column

I have a somewhat common task of calculating percentage of column. For example I have a column with 20 numbers on each row. I add 21st row with formula for the sum of all those 20 rows and then I need ...

**0**

votes

**1**answer

74 views

### Libreoffice calc export to pdf. Some characters appear different

I'm having the following problem: when I try to export a .ods file to .pdf on Libreoffice Calc 4.3.2.2, I use some Unicode characters. Most of the time they appear in the pdf just fine, but in some ...

**-1**

votes

**1**answer

117 views

### How to change the date format (DD/MON/YY) in OpenOffice spreadsheets?

I want to change the date format from default format to another format (with months)in OpenOffice spreedsheets.

**0**

votes

**2**answers

150 views

### How to change the default font in LibreOffice 4

How do I change the default font in LibreOffice / OpenOffice. So that when I open a new spreadsheet document it doesn't revert to use the standard default font (Liberation Sans/Serif)
How to set the ...

**0**

votes

**1**answer

28 views

### Min of two dates in OpenOffice Calc

I have two cells in OpenOffice Calc (A1 and B1). In cell A1, I have "2014/01/01" and in cell B1, I have "2014/06/03". I want to find the minimum/smallest of the values in A1 and B1. I actually have ...

**0**

votes

**1**answer

28 views

### How to display OpenOffice error details

So after few years I had to use open office once again. It's just as fun as it always used to be.
I tried very simple expression LEFT(C1, 1) which is supposed to pick first character from cell C1. ...

**0**

votes

**1**answer

42 views

### OO Calc: Detecting Blank Cells and Replacing with Cell above?

So annoyed I can't find a simple answer to this simple question!
I'm using OpenOffice Calc. I want a formula which will detect if the cell is blank, and if it is to replace it with the contents in ...

**4**

votes

**1**answer

30 views

### Removing functions from a column, but keeping data (convert to normal text)?

I have a column that contains the results of a few different formulas. I want to convert all of these cells to normal text, getting rid of the formulas.
I know I'm missing something obvious here.

**1**

vote

**0**answers

30 views

### OpenOffice doesn't copy charts properly

I'm using OpenOffice 4.0.0 and I have charts in them. Whenever I try to copy and paste them into another program it just copies and pastes a white rectangle (of the same size as the chart). I've tried ...

**0**

votes

**0**answers

32 views

### Ignore certain characters while sorting data in libre/office calc

I have a list of transliterated chinese terms in a table showing Wade-Giles (W.-G), chinese characters and Pinyin transcription.
Example, (sorted W.-G column only):
P'u Te Ssu
P’u t’uo-shan
Pai ...

**1**

vote

**1**answer

38 views

### spreadsheet: sorting by the first n characters of the entries of a column then by another column

Is there any way to sort an OpenOffice Calc spreadsheet by the first n characters of a given column then by another criterion?
For example suppose that we have the following 4*2 spreadsheet (Note ...

**1**

vote

**1**answer

86 views

### How to accept LibreOffice Calc autocomplete suggestion without leaving the cell edit mode?

Whenever I start typing a sentence in a LibreOfice Calc cell it suggests autocomplete options based on other cells contents. I usually would like to accept it and make a slight modification but when I ...

**1**

vote

**2**answers

487 views

### Filter OpenOffice Calc rows by matching if a cell in one column exists in another column with a certain value

Have a question I cant seem to figure out using the filter.
Column A has 1400 rows with 800 additional rows that are duplicates (so 2200 total rows).
Column B has inventory amount for only the last ...

**2**

votes

**1**answer

91 views

### Convert bidimensional table to a single one

I have some data with product prices relative to tariff code :
+==============+========+========+========+========+
| product code | code10 | code20 | code30 | code40 |
...

**0**

votes

**1**answer

115 views

### How to select a random item in list not flagged in second column?

So, I watch movies, and I have 177 of them, I put all the titles into the A column, and Figured out how to do the Randomization to bring up the titles, but I want to have a column, also for it being ...

**1**

vote

**1**answer

90 views

### How to set different orientation for different sheets in OpenOffice.org Calc?

I have document with two sheets sheet1 and sheet2 and i want set orientation of sheet1 to portrait and orientation of sheet2 to landscape.
This can be done in Excel, but in OpenOffice when i set ...

**1**

vote

**2**answers

2k views

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

**0**

votes

**0**answers

46 views

### How do I change the EOL character when importing a CSV file into Open Office Calc?

I've got a CSV file that has enclosed newline (\n and \r, mixed) characters in its data. Because the consumer of that file is not able to handle that correctly (out of my control) we decided to use ...

**6**

votes

**2**answers

589 views

### OpenOffice Calc: reduce file size when saving as Excel

I'm working on a spreadsheet together with another person, sending new versions forth and back by email. It contains nothing fancy. While he uses Windows I'm on Ubuntu 12.04.4 LTS. The first version ...

**5**

votes

**2**answers

1k views

### Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?

We have lots of spreadsheets that have lists of numbered sound files for an educational app. We use spreadsheet features such as "fill down" for the numbering, and we often use formulas to check ...

**1**

vote

**1**answer

23 views

### Numbering every third row in OpenOffice Calc

I am building a list of proofreading corrections in which the first row identifies the page, paragraph and line number for correction
The second row identifies the OLD (existing sentence)
The third ...

**1**

vote

**1**answer

26 views

### Date Arithmetic in Spreadsheets

I have a bunch of data in a spreadsheet where the left-most column represents a date in the format DD-MM. Here's an example for column A:
15-09
23-09
25-09
30-09
02-10
I ...

**3**

votes

**2**answers

69 views

### Match cell content based on line break

I take data from a helpline call in site and transfer it to Linux Libreoffice Calc (LC).
Column C cells have 2 sets of data - two telephone numbers - 1 being the caller and 1 being the forwarded ...

**0**

votes

**0**answers

101 views

### How to format pennies as dollars in LIbreOffice currency formatting?

I have data in a LibreOffice Calc spreadsheet with penny values, such as 001234 to represent $12.34 (twelve dollars and thirty-four cents). How can I define a format that will display these values as ...

**1**

vote

**1**answer

163 views

### How to combine data from multiple sheets into 1 main sheet in calc [duplicate]

I have an excel file which gets generated from various database servers on fly by executing sql. Separate sheet gets generated for each server. Now I simply want to combine data of all sheets. Each ...

**1**

vote

**1**answer

980 views

### Changing the units on the x-axis in a LibreOffice Calc chart

I've used the LibreOffice chart wizard to make a chart, and I would like the x-values to be different to the default of 1,2,3... (in this case, 500,1000,...). How can I do this?

**2**

votes

**1**answer

411 views

### LibreOffice calc: How to apply multiple tables to a single chart

I'll say it right off the bat - I am a complete Excel/Calc amateur.
What I want to do is apply 3 tables, each with 2 columns of data into a chart with 1 XY-line for each.
My current data looks ...

**0**

votes

**0**answers

66 views

### OpenOffice Calc convert with command line

I am trying to convert xls to dbf with OpenOffice Calc via command line (Windows), but I'm getting an error with this line (path is set):
scalc --invisible -convert-to dbf c:\MATIKGL.xls
Error : ...

**1**

vote

**2**answers

864 views

### Interpolate values between two cells

I've got a spreadsheet that looks like this in Libre Office Calc:
+-----------+
| | A |
| 1 | 444 |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| ...

**1**

vote

**2**answers

65 views

### What's the best way to cut out all text before or after a matching string with excel or open office?

I have a column of naughty data, that needs to be standardized. Its a single column, so I'll just include a snippet of it it here:
pop_density_2010
7002854600000000000854.6/sq mi (329.97/km2)
...

**0**

votes

**1**answer

50 views

### Is there a way to use multi-character delimiters in Open Office Calc CSV file format?

Is there a way to save a CSV file with multi-character delimiters? When I enter more than one character, it just uses the first character.

**-1**

votes

**1**answer

41 views

### How to add the current page number in a cell of a calc sheet

I would like to add the current page number in a cell of that page and to refer back this cell for this page number in a cell somewhere in the same sheet / in another sheet. Is there a way to do so?