Excel Sheet cell format
Rakesh,
Record a macro in Excel of your actions, then convert to C++. NickHK "Rakesh" wrote in message ... Hi All, I need help. I am creating Excel files using VC++ MFC programming and for that I have used MS Office type library. Problem occurs when a large number($124,121.50) written in any cell of excel sheet. If i open the file Excel shows it as #########. Number is stored but not shown in correct form. If I increase the width of the cell Excel shows the number correctly. I want if any one know how I can programmatically set the auto width of the cell according to its number width? Plz reply as soon as possible. Best Regards, |
Excel Sheet cell format
Hi All,
I need help. I am creating Excel files using VC++ MFC programming and for that I have used MS Office type library. Problem occurs when a large number($124,121.50) written in any cell of excel sheet. If i open the file Excel shows it as #########. Number is stored but not shown in correct form. If I increase the width of the cell Excel shows the number correctly. I want if any one know how I can programmatically set the auto width of the cell according to its number width? Plz reply as soon as possible. Best Regards, |
All times are GMT +1. The time now is 06:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com