Ask Your Question

Andyfc's profile - activity

2020-08-09 20:30:12 +0100 received badge  Notable Question (source)
2020-08-09 20:30:12 +0100 received badge  Popular Question (source)
2020-01-26 12:51:05 +0100 received badge  Supporter (source)
2020-01-26 10:40:52 +0100 received badge  Popular Question (source)
2020-01-26 09:29:19 +0100 edited question Calculate averages from several data ranges

Calculate averages from several data ranges Hello, I have the following problem: a table contains names of pupils in th

2020-01-26 09:24:11 +0100 commented question Calculate averages from several data ranges

@keme That is very useful indeed. Now I would like to know how to specify the range in order to get the 'AVERAGEIF()' fu

2020-01-26 09:23:29 +0100 commented question Calculate averages from several data ranges

@keme That is very useful indeed. Now I would like to know how to specify the range in order to get the 'AVERAGEIF()' fu

2020-01-26 09:17:33 +0100 edited question Calculate averages from several data ranges

Calculate averages from several data ranges Hello, I have the following problem: a table contains names of pupils in th

2017-01-02 21:06:20 +0100 received badge  Taxonomist
2016-05-12 10:03:14 +0100 commented answer Subtotals returns TRUE in a subtotals cell

Hi Pierre-Yves,

I didn't try that, but I copied the formula to another column and then back to the original column and it's working now. I don't understand, but as long as it works, it's fine with me.

2016-05-11 11:23:40 +0100 asked a question Subtotals returns TRUE in a subtotals cell

I'm trying to count how many adults there are in a given cell range. This is a column where the information "adult" or "child" (as string) is calculated with an "if" formula based on the birth date entered in another column.

The Data -> Subtotals function gives me TRUE instead of the number of cells where "adult" is.

I tried with several different counts (count, counta, countif, ...) but always the same result. This question has been asked before, but the answer did not help me.

Thank you.

2015-11-12 12:09:05 +0100 received badge  Famous Question (source)
2015-11-10 11:28:22 +0100 received badge  Notable Question (source)
2015-11-10 06:02:06 +0100 received badge  Student (source)
2015-11-09 21:58:37 +0100 received badge  Famous Question (source)
2015-11-09 16:56:27 +0100 received badge  Popular Question (source)
2015-11-09 08:13:01 +0100 received badge  Scholar (source)
2015-11-09 08:07:15 +0100 asked a question How to reference a calc cell from base

I have a spreadsheet in calc that pulls data from a "citta" table in base.

I would like to make a query in base looking something like:

SELECT "Latitude" FROM "citta"  WHERE "City"= content of the cell A10 of spreadsheet so-and-so.

because I then need to feed this "Latitude" back in calc.

I have searched a lot, but whenever I try to google for this, I always get the other way around (entering in a calc cell data from base).

Or is something like that possible directly within calc, without invoking base?

2015-11-09 07:55:31 +0100 commented answer How to make auto-complete list in a cell in calc?

@doug Thanks, I got the Combo Box to work. Now I need to go further, but I asked a new question for that: https://ask.libreoffice.org/en/questi...

2015-11-08 13:42:23 +0100 received badge  Notable Question (source)
2015-11-07 15:59:29 +0100 received badge  Popular Question (source)
2015-11-07 10:35:08 +0100 received badge  Editor (source)
2015-11-07 10:33:10 +0100 asked a question How to make auto-complete list in a cell in calc?

I have a two step question.

I have a table that contains "ID" (a primary key), "Country name", "Region name", "City name", "Latitude" and "Longitude". A city name appears more than once, since there are cities with the same name in different regions and countries. However the set "City name", "Region name" and "Country name" is unique.

I would like to do the following:

  1. when someone starts typing a city name in a cell, he gets a list of the cities that start with what he has typed so far, the region and the country of the city (in order to see that he selects the one in the right country and region).

  2. when he is happy with the list being small enough, then he selects the appropriate city from the list.

  3. two other cells should be filled: one with the latitude and one with the longitude of the selected city, looking up the right one by the set of city, region and country names.

I'm not afraid of moving the table to base and using sql queries, if that makes it easier.

Is something like this even possible with LibreOffice?

Thank you.

2015-08-18 18:53:10 +0100 commented answer Copying part of a string after instance of a character

Thank you oweng, I've always been afraid of regular expressions, as I find them very complicated at times, but your explanation made it very easy indeed. This was more useful for me finding the last blank space, because I don't always have the same number of spaces in the string.