Thursday, August 16, 2007

MS Office Consistency..!!

When you select different words in MS Word of different fonts what would you see in the font details drop down box?

- You would see the font details drop down box is blank as the fonts are different which is expected behavior.







Try doing the same in MS Excel and you would find that it show the font of the first cell you started selecting from. Being consistent with MS word the font details should be shown as blank.







I found that this is the not just the problem with word 2003 but even the Microsoft's latest release word 2007. That’s the consistency in MS Word and MS Excel…!!

5 comments:

Surnish Nirula said...

For Excel in particular, isn't it the highlighted cell that they show the font selection for? For instance, in your example, if you started your selection at B29 and then moved up to B28, you'll see a different result.

Sunil Shinde said...

Yup, this is definitely incosistent. Though,UPma, I don;t think the problem is in Word. Word is behaving the way it should.

Sowmya said...

Nice catch, Upma. :)

Upma_Sharma said...

Surnish: u r right that is shows the font of the selected cell, but when I am selecting more than one cell it should not show the font details of the first one but of all the selected cells.

Sunil:Yeh word is behaving the way it should be, thats why I said wrote "is expected behavior".

Sowmya:Thanks.

Kiran K. Karthikeyan said...

Hmm..nice catch...but did some analysis...might have been done for a reason. In word if you select two lines of text and then type something, both lines are replaced by what you type. This doesn't happen in excel, it puts what you type in the first cell (note that when you select multiple cells, the starting cell is colored differently which is not the case in word). Also if you select two cells and then click the formula bar and start typing there, only the first cell is affected. Formatting however does change for all selected cells. This I think is a call MS took, if edits happen only for the first cell, but formatting changes to the entire selected set, should the formatting displayed be for the entire set, or just the first cell. Logic says former, but could there be another reason? For example, when you edit, you would want to know in what format you will be typing in, and so, MS is right in what it did. But then, Word does the same thing. If you select the two lines and then start typing, the formatting is that of the first line. I think MS thought the user would expect this behavior in word, but may not in excel, so lets show him the formatting he would type in :). Comments?