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

Ask Your Question

Hermes14's profile - activity

2020-09-13 19:08:07 +0200 received badge  Famous Question (source)
2020-09-12 12:38:13 +0200 answered a question How do you calculate the number of digits after a decimal point

It is to calculate the pip value of a trade in forex or commodities. Most currency pairs have 5 digits after the comma.

2020-09-11 23:51:14 +0200 received badge  Notable Question (source)
2020-09-11 21:10:29 +0200 received badge  Popular Question (source)
2020-09-11 17:46:04 +0200 asked a question How do you calculate the number of digits after a decimal point

How do you calculate the number of digits after a decimal point I'm trying to calculate the number of digits after the d

2019-06-11 12:10:55 +0200 received badge  Supporter (source)
2015-09-10 10:39:09 +0200 received badge  Famous Question (source)
2015-09-07 23:14:45 +0200 received badge  Famous Question (source)
2014-04-22 02:39:26 +0200 received badge  Self-Learner (source)
2014-04-22 02:39:26 +0200 received badge  Teacher (source)
2014-04-22 02:39:01 +0200 received badge  Notable Question (source)
2014-04-21 12:37:12 +0200 answered a question Get external data hangs when inserting web address

In Opensuse13.1 to fix the problem uninstall LO 4.1.5.3 & install LO 4.2.3.3

2014-04-16 15:33:08 +0200 received badge  Popular Question (source)
2014-04-14 19:58:13 +0200 asked a question Get external data hangs when inserting web address

I have upgraded to opensuse13.1 64 bit. I have tried to draw data from numerous websites & have the same problem. eg(http://www.fxstreet.com/rates-charts/currency-rates/) my document hangs. I have tried to do all the necessary update for Libre with Zyper in libre* & still have the same problem. I have read as many posts on google as possible & most people suggest downgrading which I would like to try & avoid. I am not sure if it is a bug, or a package that I have accidentally missed.

Version: 4.1.5.3 Build ID: 410m0(Build:3)

2014-04-13 22:35:54 +0200 received badge  Enthusiast
2014-03-21 11:04:15 +0200 received badge  Notable Question (source)
2014-03-21 10:58:43 +0200 commented answer Stripping a number at the end of a text

The problem seems to be opensuse. I see other people have the same problem as soon as they try to do a web query.

2014-03-21 10:26:33 +0200 answered a question Stripping a number at the end of a text

Thanks mariosv

The formula you have given me worked perfectly this morning but when I tried to open my calc doc just now it is hanging. I should have said my os is opensuse 13.1

2014-03-21 06:09:53 +0200 received badge  Popular Question (source)
2014-03-21 02:42:45 +0200 received badge  Editor (source)
2014-03-20 19:19:39 +0200 asked a question Stripping a number at the end of a text

In column G I have a list of names. Some of the names have a number at the end & some don't. To remove the number at the end of the name I use:

=REPLACE(A2,SEARCH("[0-9]",A2,2),LEN(A2)-SEARCH("[0-9]",A2,2)," ")

This works fine with the names with numbers at the end but as soon as I get a name without a number I get an error

Libre office version 4.1.5.3 Calc