Ask Your Question

LearningLibre's profile - activity

2020-09-08 15:08:24 +0200 received badge  Famous Question (source)
2020-07-31 08:26:26 +0200 marked best answer Can I edit the value of a cell from formula bar if cell is not activated?

Is there a way to edit cell value without activating it first? I would like to set the cell E3 to value 6 and I tried to put the code E3=6 to the formula bar while the cell A1 was activated but it didn't work.

2020-07-30 22:52:53 +0200 asked a question Can I edit the value of a cell from formula bar if cell is not activated?

Can I edit the value of a cell from formula bar if cell is not activated? Is there a way to edit cell value without acti

2020-04-01 17:03:06 +0200 received badge  Famous Question (source)
2020-02-27 00:54:23 +0200 received badge  Notable Question (source)
2020-01-27 21:08:04 +0200 marked best answer How one can use Python to do computations on calc?

Can one use Python scripts in Libreoffice macros? I have Libreoffice calc 6.0.7.3 and Ubuntu 18.04. I installed libreoffice-script-provider-python. But how can I make some basic computation that tests if everything works? For example, if cell A1 contains value 1 and A2 contains value 2, then how can I compute (A1+A2)**4 via Python and put the value to the cell A3?

2020-01-27 21:07:52 +0200 received badge  Notable Question (source)
2020-01-27 17:32:13 +0200 received badge  Popular Question (source)
2019-12-18 15:11:51 +0200 marked best answer How to update cells based on what other cell contains?

I have a data on cells A1 to A8 given as in text format. How can I update the cells I1 to I8 respectively, namely that if A1 is either "1.1.2019", "22.4.2019", "30.5.2019" or "2.11.2019", then I1 should have the value "special day" and otherwise empty? And similarly I2 shows if A2 is a special day and so on.

2019-12-17 23:05:11 +0200 received badge  Popular Question (source)
2019-12-17 17:04:18 +0200 edited question How to update cells based on what other cell contains?

How to update cells based on what other cell contains?? I have a data on cells A1 to A8 given as in text format. How can

2019-12-17 17:04:18 +0200 received badge  Editor (source)
2019-12-17 17:02:22 +0200 edited question How to update cells based on what other cell contains?

How to update cells based on what other cell contains?? I have a data on cells A1 to A8 given as in text format. How can

2017-12-06 10:13:26 +0200 received badge  Famous Question (source)
2017-07-27 11:40:27 +0200 received badge  Notable Question (source)
2017-05-11 07:15:46 +0200 received badge  Popular Question (source)
2017-05-10 08:11:07 +0200 commented answer How to fill empty cells with average?

Hmm. I wrote =aggregate(1,0,Q1:Q153) when Q7 was activated but the result was Error:501.

2017-05-10 08:08:31 +0200 marked best answer How to fill empty cells with average?

I have a set of data where some columns have empty cells. How can I set those empty cells the value that is the mean of the rest of the numbers in the same column?

2017-05-10 08:08:31 +0200 received badge  Scholar (source)
2017-05-10 07:50:55 +0200 asked a question How to fill empty cells with average?

How to fill empty cells with average? I have a set of data where some columns have empty cells. How can I set those empt