jQWidgets Forums

Tagged: #jqwidgets-grid, cellsformat currency grid, grid, javascript grid, jquery grid

This topic contains 5 replies, has 3 voices, and was last updated by Hristo 7 years, 5 months ago.

Viewing 6 posts - 1 through 6 (of 6 total)

Author

Formatting of negative values using "c2" is wrong Posts
January 3, 2018 at 2:57 pm Formatting of negative values using "c2" is wrong #98131

philipstratford
Participant

We have a grid with a column displaying currency. Having used the localizestrings method to set the correct currency symbol, I’ve got the values in the column to display as desired by setting the column’s cellsformat property to “c2”, except where the values are negative. If a value is negative, it is displayed as £-123.45 when it should be -£123.45 (i.e. with the negative sign before the currency symbol). I realise that ‘wrong’ is a subjective word, but Excel places the negative symbol before the currency symbol and that makes it a pretty widely-accepted standard. I assume this is not something I can correct myself but would require an update to the source code?

January 4, 2018 at 9:23 am Formatting of negative values using "c2" is wrong #98139

Hristo
Participant

Hello philipstratford,

Thank you for this feedback. We will discuss this.
You could achieve this by cellsrenderer callback and you should miss ‘cellsformat’ option and do it this manually.
There you could manually change set how to looks the currency value.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

January 16, 2018 at 12:29 pm Formatting of negative values using "c2" is wrong #98288

ashvani18
Participant

Hi Hristo,

We are facing the same issue , we tried the cellsrenderer , but title of the columns does not reflect the value with dollar amount if we remove the cellsFormat = c2, if we keep both cellsrenderer & cellsformat then value in grid shows properly -$12 but title show $-12. which is wrong. Please suggest some easy way or fix this in you API or provide some customformating function.

Thanks,
Ashvani

January 17, 2018 at 1:02 pm Formatting of negative values using "c2" is wrong #98301

Hristo
Participant

Hello Ashvani,

You mean the header of the columns.
Could you clarify it, what you mean by “title show $-12”?
Also, it will be better if it is possible to provide us an example.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

January 22, 2018 at 2:34 pm Formatting of negative values using "c2" is wrong #98361

ashvani18
Participant

Hi,

title , I Mean tooltip on columns when you hover on column it still shows $-12.

Thanks,
Ashvani

January 23, 2018 at 2:19 pm Formatting of negative values using "c2" is wrong #98392

Hristo
Participant

Hello Ashvani,

You could override the Tooltip and its content, too.
Please, take a look at this topic:
https://www.jqwidgets.com/community/topic/grid-tooltip/#post-46399

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com
Author

Posts

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.