We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

moon's profile - activity

2020-10-29 20:39:58 +0200 marked best answer Cells not being calculated

Hi there,

I'm facing a strange problem as after upgrading to version 6 (even if I can't tell if it's the reason), the cells that use to be calculated are now just static. The display is correct as soon as I dont edit it. If I make any change then no result, only the formula is displayed. Knowing of course that all is set to "AutoCalculate F9" and the option is NOT at "Display Formulas" in the options. Struggling !

All help appreciated. Best

2020-10-29 20:39:08 +0200 received badge  Famous Question (source)
2020-10-29 20:33:30 +0200 marked best answer Characters encoding

Hi there, I'm trying to make the editor within calc to not convert these caracters "-->" into a right arrow (→). Tried to read many post here and there and apparently either the question is not asked yet or (probably) too simple. Whatever the case I'm struggling. Any help ?

Many thanks in advance.

moon

ps: same for the quotes (") as they display in a funny rounded way (“) but useless for coding. Guess that the answer for the first issue will also solve that.

2020-10-29 20:29:44 +0200 marked best answer collect the content of non empty cells

Hi there,

I'm trying to collect alll the non empty cells from a range of cells and build a string out of it.

Assume a range C3:C23 with only some cells with data. example C4, C10, C15. I have no control on the number of non-empty cells. it could be 0 up to the total cells. I have also no control on the size of the range.

I need to build this kind of instruction : Concatenate("(",C4,",","C10,",","C15,")")

Is that possible at all ?

Thanks in advance.

2020-10-29 20:28:59 +0200 received badge  Famous Question (source)
2020-10-29 20:28:59 +0200 received badge  Notable Question (source)
2020-10-29 20:28:59 +0200 received badge  Popular Question (source)
2020-09-03 10:20:03 +0200 received badge  Famous Question (source)
2019-11-22 19:08:56 +0200 received badge  Famous Question (source)
2019-11-22 19:08:56 +0200 received badge  Notable Question (source)
2018-09-03 17:48:51 +0200 received badge  Notable Question (source)
2018-07-04 10:53:13 +0200 received badge  Popular Question (source)
2018-05-03 19:52:32 +0200 received badge  Popular Question (source)
2018-05-03 15:13:27 +0200 commented answer preserve macro while renaming a calc file

Thanks peterwt for the quick reply. I added in my question a screenshot to better show where my macros stands. In pract

2018-05-03 13:35:10 +0200 commented answer preserve macro while renaming a calc file

Thanks peterwt for the quick reply. I added in my question a screenshot to better show where my macros stands. In pract

2018-05-03 13:34:41 +0200 commented answer preserve macro while renaming a calc file

Thanks peterwt for the quick reply. I added in my question a screenshot to better show where my macros stands

2018-05-03 13:33:49 +0200 edited question preserve macro while renaming a calc file

preserve macro while renaming a calc file Hi I think that I understood that macros have to be withing the file structur

2018-05-03 13:29:11 +0200 edited answer preserve macro while renaming a calc file

Thanks peterwt for the quick reply. Actually I think this is what I'm doing. I dropped here a screenshot if it can help

2018-05-03 13:27:05 +0200 answered a question preserve macro while renaming a calc file

Thanks peterwt for the quick reply. Actually I think this is what I'm going. I dropped here a screenshot if it can help

2018-05-03 13:16:27 +0200 edited question preserve macro while renaming a calc file

preserve macro while renaming a calc file Hi I think that I understood that macros have to be withing the file structur

2018-05-03 13:15:51 +0200 edited question preserve macro while renaming a calc file

preserve macro while renaming a sheet file Hi I think that I understood that macros have to be withing the file structu

2018-05-03 13:12:24 +0200 asked a question preserve macro while renaming a calc file

preserve macro while renaming a sheet file Hi I think that I understood that macros have to be withing the file structu

2018-02-13 00:03:38 +0200 received badge  Notable Question (source)
2018-02-09 08:48:19 +0200 received badge  Popular Question (source)
2018-02-09 00:59:33 +0200 answered a question Cells not being calculated

Thanks erAck. Appreciated. I thought basically that the "equal" sign to enter a function will overload the field. Looks

2018-02-08 23:18:59 +0200 commented question Cells not being calculated

Just a little input. When copy/pasting in another cell it works fine ! Is that because of any specifics that cells gets

2018-02-08 23:08:54 +0200 edited question Cells not being calculated

Cells not being calculated Hi there, I'm facing a strange problem as after upgrading to version 6 (even if I can't tell

2018-02-08 23:08:23 +0200 edited question Cells not being calculated

Cells not being calculated Hi there, I'm facing a strange problem as after upgrading to version 6 (even if I can't tell

2018-02-08 23:07:35 +0200 asked a question Cells not being calculated

Cells not being calculated Hi there I'm facing a strange problem as after upgrading to version 6 (even if I can't tell i

2018-02-08 23:00:05 +0200 commented answer Characters encoding

After having considerred your input. I need to say thank you, therefore closing the question as solved. Best

2018-02-08 18:08:33 +0200 commented answer Characters encoding

as reg the AutoCorrect Option, I've deleted the conversions however even after restarting it still displays that bloody

2018-02-08 18:08:11 +0200 commented answer Characters encoding

as reg the AutoCorrect Option, I've deleted the conversions however even after restarting it still displays that bloody

2018-02-08 14:01:17 +0200 edited question Characters encoding

Characters encoding Hi there, I'm trying to make the editor within calc to not convert these caracters "-->" into a r

2018-02-08 14:00:58 +0200 edited question Characters encoding

Characters encoding Hi there, I'm trying to make the editor within calc to not convert these caracters "-->" into a r

2018-02-08 14:00:58 +0200 received badge  Editor (source)
2018-02-08 13:50:58 +0200 asked a question Characters encoding

Characters encoding Hi there, I'm trying to make the editor within calc to not convert these caracters "-->" into a r

2018-02-08 12:42:33 +0200 commented question collect the content of non empty cells

Thanks for the advise.

2018-02-08 12:41:25 +0200 answered a question collect the content of non empty cells

It does the work Lupp. Thanks a lot ! I'll find a way to close the question.

2018-02-08 12:29:42 +0200 commented answer collect the content of non empty cells

Thanks Lupp have to Upgrade then (still running 5.0.3.2)

2018-02-08 11:11:18 +0200 edited question collect the content of non empty cells

collect the content of non empty cells Hi there, I'm trying to collect alll the non empty cells from a range of cells a

2018-02-08 10:52:41 +0200 asked a question collect the content of non empty cells

collect the content of non empty cells Hi there, I'm trying to collect alll the non empty cells from a range of cells a

2014-01-27 01:50:22 +0200 received badge  Famous Question (source)
2014-01-27 01:50:22 +0200 received badge  Notable Question (source)
2013-11-03 23:15:23 +0200 received badge  Popular Question (source)
2013-11-03 21:33:46 +0200 answered a question Several data series with different categories/labels in one chart

Hi Mariosv,

Thanks for the help. May I expand a bit. The idea with the categories is of course to display using different colors for each category. Since in your solution we're dealing with a unique series, the only way is to do it "by hand" for both categories. In my real life it's about several categories while the number of data for each category varies. In case you have an idea, this will save my life :-) I tried also with scattered data, without success. All my best and thanks again for the support

Moon

2013-11-03 19:18:20 +0200 commented answer Several data series with different categories/labels in one chart

Hi Mariosv,

Thanks for the help. May I expand a bit. The idea with the categories is of course to display using different colors for each category. Since in your solution we're dealing with a unique series, the only way is to do it "by hand" for both categories. In my real life it's about several categories while the number of data for each category varies. In case you have an idea, this will save my life :-) I tried also with scattered data, without success. All my best and thanks again for the support

Moon

2013-11-03 07:32:34 +0200 commented answer Several data series with different categories/labels in one chart

Thanks for answering, but as you say there is an issue there. u sure about the link?

2013-11-02 22:50:14 +0200 asked a question Several data series with different categories/labels in one chart

Hi there.

After having checked that no similar issue were reported, I dare putting mine.

I'm struggling putting in a unique scattered diagram/graph data with adequate labels.

This is kind of reccurent problem for risk analysis.

Consider that we have n categories, for each category we have 4 sets of data:

column 1: label

column 2: x

column 3:y

column 4:z

and consider that you need a bubble plot where (x,y) are the coordinates and z the size of the bullet.

What I need to do is to put the label appearing. It works very fine if you have a unique category. It's another story if you need to deal with several categories.

Example assuming category 1=T, category 2 is F

T1 0.1 0.5 0.05

T2 0.2 0.1 0.02

T3 0.15 0.1 0.015

T4 0.25 0.2 0.05

F1 0.2 0.6 0.12

F2 0.1 0.3 0.03

F3 0.9 0.2 0.18

F4 0.2 0.5 0.1

and you need the bubbles to show T1... T4 and F1... F4 as labels where appropriate.

any kind of help will be appreciated.

Best

Moon