# Questions tagged [openoffice-calc]

OpenOffice's spreadsheet application. Tag questions about macro programming or formulas with macros or worksheet-function respectively

OpenOffice's spreadsheet application. Tag questions about macro programming or formulas with macros or worksheet-function respectively

341
questions

0
votes

1
answer

61
views

I have a list of items with set of properties. Some of the properties are unique, some are the same. I want to sort the properties through all items to see which items have equal properties.
Maybe it'...

0
votes

0
answers

13
views

I try to create a graph from this table:
I need to select each row where Age group is 10-59.
Is this possible, or do I have to delete all the other data?
Attempts:
I tried to apply a filter and then ...

0
votes

0
answers

10
views

I am updating a form that was created in Open Office Calc that is intended for printing and PDF output. The form is 6 columns wide, with the right-most column (col F) for non-client facing comments. ...

0
votes

2
answers

200
views

The formula that I use is
=INDEX(F:F,MATCH(K2,A:A)*(B:B=L2),0)

0
votes

3
answers

89
views

I'm currently playing around with formulas and made one that works perfectly for me.
Some row will get the value #VALUE! due to them being empty when imported and I am trying to make the whole rows ...

0
votes

1
answer

66
views

I have a file that converts inputs for me into an SKU-number (Stock Keeping Unit).
The names and attributes I have are in one line and one cell like so:
Temperature Displaying Smart Ring / Rose Gold – ...

0
votes

0
answers

14
views

What I'm trying to do is calculate the number of hours worked according to the color and the person, all of this to be determined in the nombre d'heures column in front of each person.
Knowing that ...

0
votes

1
answer

58
views

This is a question about the feasibility of solving a problem with LibreOffice/Calc.
I have a table of data of many years with basically the following columns:
date/time ( Y/M/D time )
quantity
Now, ...

0
votes

0
answers

88
views

I would like to use the German locale, but with a dot as a decimal separator.
I was only able to change the seperator, by changing the locale:
There exist similar questions:
how to set the decimal ...

0
votes

0
answers

21
views

The GNU grep command allows to search inside the incoming stream of data, for example inside the files. It have two similar and very useful CLI parameters: -A & -B:
-Annn shows nnn lines following ...

0
votes

1
answer

59
views

I have a libre calc file with many sheets and I want the first sheet to contain a list with the other sheets names and next to each one the contents of a specific shell of every one of those sheets.
e....

0
votes

1
answer

220
views

Assumed we have this table style in sheet 1:
A B C D E F G H
1 0.1 0.2 0.5 0.7 0.4 0.5 0.9 1.0
2
3
In sheet 2 there have to be averages made of cells ...

0
votes

1
answer

226
views

The premise is to retrieve current currency rates into a Libre/OpenOffice Calc spreadsheet. Previously I did it using a JSON service, with manual tweaking of substrings, which isn't all that user-...

1
vote

1
answer

34
views

Hello i have to solve this problem in Libreoffice Writer or excel.
I have a table like this:
ID V1 V2 V3 ...
1 10 20 30 ...
1 30 40 50 ...
1 5 7 8 ...
.. .. .. ....

1
vote

1
answer

78
views

I am trying to achieve the following:
For each columns RN, RO and RP, color the background of the cell in red if it is less than the number in the RR column on the same row, and in green if it is ...

0
votes

1
answer

80
views

I'm going to simplify a bit to hopefully get at the crux of my question.
I have a spreadsheet in which a cell has a massive formula. (Again, I'm simplifying to avoid a question that is so long no one ...

0
votes

0
answers

224
views

In LibreOffice Calc, I have been able to almost configure a usable dark theme/mode.
To accomplish this, go to Tools > Options... > LibreOffice > Personalization and set the dark theme, and ...

1
vote

0
answers

53
views

This is kind of a two-part question.
Is it possible to create conditional formatting to highlight an entire row with a certain color based on whether the checkmark object in the row is selected? For ...

1
vote

1
answer

56
views

I have a column of names; Each name has exactly 1 duplicate, Is there a function I can use to find the row number of the 2nd copy of the name.
So the values should be 2,1,4,3,6,5,7,6 and so on.
In ...

0
votes

0
answers

25
views

I've set up a spreadsheet in OpenOffice for project estimation at a contractor. The first column is a description of the item or service that I'm adding into the price. Since there are many commonly ...

1
vote

1
answer

809
views

I thought there were two ways to do this: either enclose the field containing the comma in quotes, or place a backslash before the comma. However neither of these is working; when I load up the CSV ...

0
votes

1
answer

277
views

Is there a way to do condition formatting based on a letter and having that format apply to more than one cell?
The desired result is shown below, where typing either A, B, or C in column "B"...

0
votes

1
answer

26
views

I am using OpenOffice Calc to view and change a particular csv. This csv has some numbers that start with 0 and some dates. I need to have both the numbers and the dates in a Text cell format. When I ...

3
votes

1
answer

1k
views

I have read How to set decimal separator in Libre Office Calc? but I haven't found an option for this:
Is it possible to set both . and , as decimal separator in LibreOffice Calc?
In France it's , ...

0
votes

1
answer

192
views

I have a table where the values are very large, in order of millions. Basically I want to iterate through all the cells(In a particular column) and divide each of them by some number (like 10,00,000).
...

-3
votes

2
answers

64
views

I have two snapshots of data in big tables on two different sheets. Basically the sheets have identical content but the numbers are from different moments of time. I need to compute the delta between ...

1
vote

1
answer

109
views

Is it possible to combine two IF/AND functions into one? (OpenOffice Calc)
I have two IF/AND functions that work perfectly well, however I need them to both work on the same line. Is there anyway to ...

1
vote

1
answer

190
views

I have the following function in cell 'B2' a libreoffice calc document:
=CONCAT(A1,CHAR(10),A2,CHAR(10),"end")
Which, with in cell A1="function plotName = getPlotName(plotData)" and A2=" plotName ...

0
votes

1
answer

248
views

I am using Apache Open Office Calc to view CSV data. I just noticed that Calc rounds the data on saving, reducing its precision, or at least I think that's what's going on.
I show below the same data ...

0
votes

1
answer

42
views

I'm looking to get some assistance in untangling the mess that is a data entry and summary spreadsheet I've had for the last few years in LibreOffice Calc. The general layout of the spreadsheet's ...

0
votes

1
answer

345
views

I am attempting to simulate a large quantity of dice rolls using Excel or LibreOffice Calc. I managed to find here a formula to generate multiple random numbers based on values specifying how many ...

1
vote

1
answer

305
views

I'm trying to import a CSV file to OpenOffice Calc, but the program is reading special characters incorrectly.
For example, one of the fields in the CSV is "Puma La Cerámica", but Calc imports it ...

1
vote

1
answer

91
views

I have the following cell structure in OpenCalc:
|--A--|--B--|--C--|--D--|--E--|
|--1--| A1 | B1 | C1 | D1 | E1 |
|--2--| A1 | B1 | C1 | D1 | E1 |
|--3--| A1 | C1 | D1 | E1 | F1 |...

1
vote

2
answers

664
views

I want to update the value of a the cell based on the current value of that cell and value of another cell like A1=A1+A2what is the correct formula

2
votes

1
answer

126
views

I have a simple spreadsheet with every row containing times (24h) something was switched on and off again. So it looks something like this:
10:20:15 10:25:36
11:09:02 11:15:54
13:00:38 13:01:...

0
votes

1
answer

107
views

I have a file that contains 25,000 rows, each row containing a number, looking like this:
4000
3000
1500
700
...
2
1
1
1
From this I want to make a pie chart.
The first few pie parts will be ...

1
vote

1
answer

25
views

I have some CSV files that I have to format, which is the easy part, but then I have to create an average for values in each column based on the hour. The hour is in its own column and the values are ...

0
votes

2
answers

271
views

I have a Libreoffice Calc spreadsheet that holds around fifty sheets (each one with no more than a dozen valued rows); this is good for data organization — each sheet holds a sequence of events ...

0
votes

1
answer

102
views

Assume i have a LibreOffice Calc sheet spanning multiple pages in printout. Is there a way to calculate a subtotal for each page and print it at the bottom of the respective page as well as at the top ...

0
votes

0
answers

148
views

I have a spreadsheet with a column full of Euro amounts. This spreadsheet is created from a CSV and the amounts are interpreted as strings (text) rather than as numbers.
I've been trying to get the ...

1
vote

1
answer

158
views

Modeled off a solution I found for Excel, I tried the following in Open Office Calc and got an error:
=FIND({1,2}, A1)
The goal is to find the coordinates in the string at A1 where either the number ...

4
votes

0
answers

193
views

In LibreOffice Calc, how can I change the cell selection black ring to something lighter so it can be easier to see for dark backgrounds? I will attach an image to show what I mean. It would be nice ...

1
vote

1
answer

3k
views

I have some data like this (it's stock market data)
29/07/2015 35972.82 32056.2 17751.39
30/07/2015 35961.86 32046.43 17745.98
31/07/2015 35848.13 31945.08 17689.86
03/08/2015 ...

-1
votes

1
answer

111
views

I work on a warehouse using WM apps that resulting exported data for daily transaction. We use open office calc for spreadsheet data processing. The data contain cells for location, with format like:
...

1
vote

1
answer

1k
views

I am using Libreoffice Calc 5.2.0.4.
I am building an appointment book. This book has many sheets/ pages.
I am not experienced, so I was experimenting on different sheets. And now I have three ...

1
vote

1
answer

2k
views

Looking for help
A B C D E F
1 Food Petrol Rent Wages
2 **Food** 12
3 **Petrol** 35
4 **Rent** 120
5 ...

2
votes

0
answers

540
views

I have an Excel workbook which works as a time sheet. Users select the project they worked on and how many hours they spent on it that week. The project can be selected from a dropdown list showing ...

7
votes

2
answers

5k
views

I've a datasource where the dot is used as decimal separator, i.e. : 1.49 means "one and almost-half". Cannot change it.
This number must be copy-pasted to a numeric cell in Excel or Calc. The file ...

2
votes

2
answers

3k
views

I have a spreadsheet with about seventeen hundred rows and I need to add 3% every cell in a column.
Example:
Column
------
1800
1500
5435
3583
3544
etc
I need to figure out what 3% of 1800 is then ...

-1
votes

1
answer

59
views

I used "=IF(MATCH(A1;E$1:E$4;0);A1)" in Openoffice (FROM THIS AWESOME SITE) to search a range to match a cell. Is there a way to report the corresponding cell value of the matched range cell? E.g.
...