This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

MS Excel Auto Fit Logic

Question
0

Sign in to vote

Hi,

I am trying to write the own logic to get the auto fitted row/column size as in MS Excel. I used the below three .Net framework methods to evaluate auto fitted row/column size. Unfortunately I am not able to get the exact auto fitted row/column size as MS Excel. Can you please let me know the logic behind used in the MS Excel to auto fit the row/column.

Methods List:

Graphics.MeasureString

Graphics.MeasureCharacterRanges

TextRenderer.MeasureText

Thanks,

Sathish
SathishBabuR

Friday, December 9, 2011 8:24 AM

Answers

0

Sign in to vote
Sathish,

The purpose of this forum is to support the Open Specifications documentation. You can read about the Microsoft Open Specifications program here,http://www.microsoft.com/openspecifications/en/us/default.aspx
The library of Open Specification documents is located here, http://msdn.microsoft.com/en-us/library/dd208104(PROT.10).aspx
I would suggest making a post in the Excel Develoepr's forum at http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads
Bryan S. Burgin Senior Escalation Engineer Microsoft Protocol Open Specifications Team
- Marked as answer by SathishR Sunday, December 11, 2011 4:18 PM
Saturday, December 10, 2011 8:14 PM