Forum

July 12th, 2025
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Currency and Pound Symbol prefix
22/10/2010
11:18
Avatar
michaelg
Member
Members
Forum Posts: 51
Member Since:
10/04/2010
sp_UserOfflineSmall Offline

Hi Everyone,

I'm hoping someone has a solution to this problem (i've searched the forrum and can't find a solution there).

In my grid, i have some currency columns defined as ...

{ name: 'Rate', index: '4', editable: true, edittype: 'text', search: false,
                        editrules: { edithidden: true, number: true }, formatter: 'currency', align: 'right',
                        formatoptions: { decimalSeparator: ".", thousandsSeparator: " ", decimalPlaces: 2, defaultValue: "", prefix: "£" },
                        hidden: false, hidedlg: true, width: widthItemAddToJobRate
                    },

... to prefix the currency with a british pound symbol, rather than the $ symbol.

The grid displays fine (the british pound is displayed).  However, in inline edit when I try to save a value such as £150.00 i get an error message as follows ...

£150.00 Rate: Please, enter valid number

... is there any solution to this problem, or do I need to forget about using the 'currency' formatter with the british pound?

Thanks,

Michael

27/10/2010
01:44
Avatar
michaelg
Member
Members
Forum Posts: 51
Member Since:
10/04/2010
sp_UserOfflineSmall Offline

Does anyone have any clues about this one? It's got me stumped, and my site goes live in a few days Surprised

Any suggestions or help would be greatly appreciated

Cheers,

Michael

15/02/2011
09:29
Avatar
michaelg
Member
Members
Forum Posts: 51
Member Since:
10/04/2010
sp_UserOfflineSmall Offline

Hey guys,

Just wondering if anyone has come across a solution for this - would greatly appreciate any input

Cheers,

Michael

15/02/2011
09:56
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Hello,

I will try to explain the problem:

When the number is created we create it with  £. Actually this is a html representation for the Pound. 

http://www.ascii.cl/htmlcodes.htm

3. Make your own custom checking function - something like currency (this type of checking is mussed in our package)

http://www.trirand.com/jqgridw.....mmon_rules

(See custom checking example)

Kind Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

16/02/2011
03:04
Avatar
michaelg
Member
Members
Forum Posts: 51
Member Since:
10/04/2010
sp_UserOfflineSmall Offline

Thanks very much for your post Tony.  I will try these out

Cheers,

Michael

Forum Timezone: Europe/Sofia

Most Users Ever Online: 994

Currently Online:
12 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information