QQ登錄
微博登錄
微信登錄
高頓網校友情提示，*7潮州會計繼續(xù)教育網上總結信息Excel2007新知-關于圖標集的更多信息等內容公布如下： A bit more on Icon Sets – answers to Biff’s and Harlan’s questions
關于圖標集的更多信息——回答B(yǎng)iff和Harlan的問題
Since a few of the comments that were made on the last post were more easily answered with pictures, I thought I would just go ahead and make a new post out of it. (I have answered the other comments in the comments section of the previous post.)
因為上次發(fā)表的帖子的一些建議用圖片來回答更容易一些，所以，我想我得另外發(fā)一篇新帖子來回答這些問題（我已經在上篇帖子的留言部分回答了其它建議）。
1. Biff commented “That 2nd screencap with all those icons applied looks like a real mess. I would not want to see that in any of my spreadsheets.”
1. Biff留言說“第二幅截屏中，應用的那些圖標看上去實在有些亂。我不想在我的任何電子表格里面看到這個樣子。”
Actually, Biff, my example wasn’t the greatest – that is not how I suspect that most people will use Icon Sets in the wild, it was something I created rapidly for illustrative purposes. You may have noticed that there was an option on the Icon Set Formatting Rule dialog to “Show The Icon Only”. I suspect we will see a lot of that – in the internal reports and documents we have seen from dogfood use around MSFT and our beta participants, I would say that 75% of what we see is just the icon. Here are a few examples.
Biff，實際上，我的示例不是*4的——我想大多數人不會是那樣使用圖標集的，它是我為了示范目的而快速創(chuàng)建的東東。你也許注意到圖標集格式規(guī)則對話框里有個選項，可以選擇“僅顯示圖標”。我想我們將看到很多這樣的例子——我們已經看到在MSFT和我們beta版的試用中的內部報告和文檔中，我要說，我們看到的75％是只有圖標。這里有一些示例。
2) Harlan commented “I think the bigger problem is that the icons appear left-aligned in the cells. I'd be surprised if most users wouldn't associate the icons closest to the numbers with the numbers. A quick glance makes it appear that the value 35 for Measurement 6 in column One has an associated exclamation point rather than a checkmark.
2) Harlan留言說“我想較大的問題是圖標左對齊顯示在單元格里。如果大多數的用戶不會將圖標和挨得最近的數字聯系起來的話，那我才會真的感到意外呢。一眼看上去，好像在列’One’和行’Measurement 6’中的數值35與感嘆號聯系在一起，而不是對勾號。
I don't see how icons would be useful without aligning themselves with their corresponding values more closely than with the contents of adjacent cells. Given that it's also useful to have the icons align with each other in each column, the ideal would seem to be for icons to align to the left or right of left or right aligned cells and automatically indent the cell contents to make space. Treat centered and the other horizontal alignments the same as general: align icons on the right for numbers and on the left for the other types (and for general, change cells' horizontal alignment to right or left as appropriate for the cells' type and indent).
如果不將圖標與它們相應的數值挨得比臨近的單元格內容更近一些的話，那么我看圖標不會有什么用處。假設圖標在每列中彼此對齊也有用處的話，理想狀況是圖標應該可以自動在左對齊或者右對齊的單元格中進行左對齊或者右對齊，并且，單元格內容自動縮進以確?？臻g。將居中和其它橫向對齊處理為常規(guī)：數字類型的將圖標對齊在右邊，其它類型的對齊在左邊（對于常規(guī)，基于單元格類型和縮進更改單元格’橫向對齊為右或者左’）。
This raises the question how these icons would align vertically if they were in cells that wrapped to multiple lines OR were in rows with greater than needed row height. They should either match cells' vertical alignment or always be centered.”
這提出了另外一個問題，如果多行單元格合并了或者行高大于所需行高的話，圖標將如何豎直對齊呢？它們應該要么和單元格的豎直匹配要么總是居中對齊。”
Good feedback – the folks on the feature will think about it. Again, I suspect that either the numbers wont be shown, or they will be a column of numbers that are easily identified with the icon (as in the above examples). In the final implementation, the icon will line up with the text in a cell, and the icon will follow the cell’s vertical alignment. Since Icon Sets can only be applied to numerical values, so text wrapping will not be an issue.
很好的反饋——本功能組的成員將考慮它。再次強調，我想要么不顯示數字，要么它們會是一列容易與圖標鑒別的數字（參見上面的示例）。在最后的實施中，圖標會和單元格中的文本整齊排列，圖標會遵循單元格的豎直對齊。因為圖標集只能應用到數值，因此文本換行不會是個問題。
掃一掃微信，學習實務技巧
