Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
2005
Show pound signs if cell is too small to show a number
posted

Hi,

What is the best way (if there is any) to show pound signs instead of a number if a cell is not wide enough to display the whole formatted number? This is one of features in MS Excel. In order to do this, we need to be able to do at least the following tasks:

1) get the formatted number

2) get the font

3) get Graphics instance to call MeasureString on the formatted number with the font

4) get the width of the cell and it margins

Thanks,

Shaolin