format specifier for small values

Question

0.00/5 (No votes)

See more:

Hi experts,

a DataGridView is used to display some measured values. Among those values are currents. They are stored in Ampères within the application.

Since those values are relatively small, I would like to tell DataGridView to display Milliampères instead.

There is a possibility to display large magnitudes[^]. And there is one for per mille[^] values. But the first is the wrong way round, the latter inserts an additional per-mille-symbol.

What format specifier multiplies a value by 1000 before displaying it?

Edit: The grid is data-bound. So there is no code that sets an individual cell's value. Therefore I'm looking for a format specifier that can be used as DataGridViewCellStyle.Format.

Posted 28-Oct-11 2:41am

lukeer

Updated 28-Oct-11 3:01am

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wayne Gaylard · Answer 1 · 2011-10-28T02:47:00

Solution 1

Why can'y you do this (value*1000).ToString("0.00") ?

Posted 28-Oct-11 2:47am

Wayne Gaylard

Comments

lukeer 28-Oct-11 9:01am

Forgot to mention that in the original post. I'm looking for something to use in DataGridViewCellStyle.Format. I updated the question.

E.F. Nijboer · Answer 2 · 2011-10-28T02:49:00

Solution 2

Just delete the & ChrW(&h2030) part because that is the per-mille-symbol. You could also replace it with a symbol you like. You can use charmap (start -> run... -> type: charmap) to to lookup a wide-char that is suitable or just simply add " amp" to the format string.

Good luck!

Posted 28-Oct-11 2:49am

E.F. Nijboer

Comments

lukeer 28-Oct-11 9:03am

Forgot to mention that in the original post. I'm looking for something to use in DataGridViewCellStyle.Format. I updated the question.

E.F. Nijboer 28-Oct-11 9:54am

Have a look at "To format data in cells" at the bottom of the page:
http://msdn.microsoft.com/en-us/library/95y5fz2x.aspx?appId=Dev10IDEF1&l=EN-US&k=k%28VS.CELLSTYLEDIALOG%29;k%28TargetFrameworkMoniker-%22.NETFRAMEWORK&k=VERSION=V4.0%22%29&rd=true

...and check out custom formatting (you can also download a utility to help you on this page):
http://msdn.microsoft.com/en-us/library/0c899ak8.aspx

Formatting only defines how to format the value, meaning it isn't for calculations and such. So, you might need to use a DataGridViewCellFormattingEventHandler after all:
http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/thread/95e7e7ef-2e71-412f-abe5-ffbee2c12c18/

BobJanova · Answer 3 · 2011-10-28T02:56:00

I do this by having a view-model class that sits between the application data and the grid. The grid is bound to a list of these binding helpers, instead of to the list of business objects directly. The binding helper can then perform whatever two way translation is needed to get the data into the form that the users want to see it (i.e. unit conversions, not just X->mX but m->ft and other similar things).