SSW Microsoft Office Suggestions

Indicates important rule

Microsoft Office

1. Highlight button

   Users of the Google Toolbar may be familiar with the Highlight option, which highlights all occurrences of the current search keywords in the current document. This is a very handy feature and it would be good to see it in all Microsoft Office applications as well.

   

   Figure: Google highlight option in use.

2. Smart(er) Tags

   Microsoft Office applications allow you to control when Smart Tags are triggered by using 'recognizers'. The list of recognizers can be altered, in most cases through the AutoCorrect options dialog. (See screenshot of Word's AutoCorrect dialog below.)

   It would be good if the list box could allow the user to drill down each recognizer item and view sample data (e.g. for 'Dates' the sample data would be a date, such as '1/1/2003').

   There are two ways in which this could be implemented, namely:

   1. Show it just underneath each item when the item is expanded.
   2. Display a 'More...' button underneath each item, which will open a dialog that displays the sample data.

   

   Figure: Smart tag settings in Microsoft Word.

3. Getting More Smart Tags

   Office could be improved in how it handles extending of its smart tag functionality.

   Currently adding a custom smart tag requires editing registry; this should not be necessary. It would be better to implement an 'Add Smart Tag' button to the Smart Tags tab of the AutoCorrect dialog. (See screenshot.)

   Also, the More Smart Tags button in this dialog should be implemented as a hyperlink, as it links directly to a page on the Microsoft website.

   

   Figure: Smart tag settings in Microsoft Word.

4. Readable Settings Files

   It would be nice if Office stored all of its settings files in a readable format. For example, if the settings files were stored as XML, then the user could clearly see the settings that were applied, and also be able to import/export parts of the settings files themselves (this is different to the current system where you have an all-or-nothing approach to the import/export of settings).

   

   Figure: Settings files are stored in binary format, they should be XML

   But what about invalid xml?

   Just give the user a message something like: "Someone has changed with the xml and now it is invalid. Reverting to default settings."

   Note: Have renamed the file to zzWord11.xml so that they can attempt to fix it if they want to.

5. Automatic File Version Increment

   It would be really useful if Office documents (e.g. Word, Excel) would have an option to increment the file version every time a document is saved and closed.

   For example, if you opened
   Session1_ExtremeProgramming_Access97to2003_AdamCogan_v3.ppt,
   made a changed, saved and closed the document, the filename would update to
   Session1_ExtremeProgramming_Access97to2003_AdamCogan_v4.ppt.
   
   This would help ensure that the latest version is being used and that you can determine at a glance which version of a document is the newest.

6. Load MRU (Most Recently Used) lists as a background process during Save or Delete

   During the process of saving a file to a machine, Microsoft Office applications will try to load recently used files.
   This can cause an unnecessary delay when the machine is not connected to the network that a previous project was saved on; after a certain period it times out and goes on to save the file.
   The temporary fix to this is regularly clearing the MRU lists.

   As stated by Microsoft Support, following these steps to clear MRU lists of Microsoft Access, Excel, PhotoDraw, PowerPoint, and Word:

   1. On the Tools menu, click Options, and then click the General tab.
   2. Clear the Recently used files check box, and then click OK.

   

   Figure: Example of clearing MRU lists in Microsoft Word

   3. On the Tools menu, click Options, and then click the General tab.
   4. Select the Recently used files check box, and then click OK.

   

   Figure: Example of checking MRU lists in Microsoft Word

   This is a common issue in a lot of applications; freezes are usually caused by trying to access a network resource that is not available. MRU processes should be executed as background threads so that they dont lock up the main UI and leave the developer waiting.

7. Run Office 2003 and Office 2007 side by side on the same PC

   Why does the Office team not design you to run Office 2003 and Office 2007 side by side on the same PC?
   Seems a strange thing to not keep on shipping...

Microsoft Word

1. Move to Folder Function



Figure: Please add a Move To Folder" function?like in Outlook



2. Make a Save As option for pictures

   Please add another menu item to this right click menu "Save As" just like Internet Explorer

   

3. Option to print the computer name when printing documents

   We should have a 'ComputerName' to show the computer name.

   

   Figure: Word's Header and Footer fields

   Read the same request for Internet Explorer on our Microsoft Internet Explorer Suggestions.

4. Option to choose a footer style When print document with multiple pages

   When print document with multiple pages - Please pop a message box with a question:
   "Would you like to choose a footer style so you have page numbers when you print?"

5. Help me use Office's Quick Access Toolbar - Make our software learn

   I don't see users (aka knowledge workers) use the Quick Access Toolbar... I don't even see advanced users like developers use it.

   I think it would be great to have it automatically learn how we use the application and put shortcut commands there.

   Then encourage me to use the shortcut commands, by having it give a visual indication (eg. flash) when I use the normal slow menu.

   

   Figure: It would be great to see the Quick Access Toolbar grow from this...

   

   Figure: To this... automatically

   PS: I would also like to see it in VS.NET

6. Office 2010 Hate the new UI - Print button should be bottom right

   My Feedback for Office 2010 team is...

   The Print button should be at the bottom right ?as the eye navigates down we have to look back up to hit Print

   I could be wrong, so I would love to know the logic behind this change.

   

7. Spelling - Microsoft Word should pick up all spelling/grammar issues

   It is very important that Microsoft Word picks up all spelling/grammar issues. It may be one little bug, but more likely this bug could affect a lot of possible sentences.
   More and more people with English as their second language rely on this to make their emails professional.

   When you type a sentence using the verb in the singular form with the subject is in the plural form, "Spelling and Grammar Check" tool does not pick it up as an error unless you keep typing more words after that.
   E.g. "For documents that belongs on the inside..." should be "For documents that belong on the inside..."
   

   

   Figure: BUG ?Microsoft Word's Spelling and Grammar Check tool does not highlight the error if you have "..." at the end of the sentence.

   

   Figure: BUG ?Microsoft Word's Spelling and Grammar Check tool can't pick up some correct words.

   Note: We also rely on this with our Do you use Microsoft Word's spelling and grammar checker to make your web content professional? rule.

8. Spelling - Add 'sms' to spell check

   

   Figure: these 2 words need to be added to the spell check library, or include specific suggestions to fix

9. Grammar - Add to grammar checker

   

   Figure: Another incorrect suggestion

   

   Figure: Another incorrect suggestion

Microsoft Excel

1. Confusing Save Dialog ( Has been fixed already.)

   Before closing, Excel prompts the user to save any unsaved documents. Sometimes the wrong sheet is shown behind the save dialog; this can be very confusing.

   

   Figure: Confusing Save prompt in Excel.

2. Excel to support Import Data from Web Services

   In Excel 2007 and 2010, it supports importing data from various data sources, e.g. SQL Server, Analysis Services, etc. But it does not support importing data from "Web Services". Importing data from Web Services functionality is great to have, so it will save user time to write VSTO code or VBA code to call web services.

   

   Figure: Adding Import from Web Services functionality

   Related link

Microsoft Access

1. Access to support Import Data from Web Services

   Sometime, users may want to get data from Web Services provided by other party. It is a bit cumbersome to do at the moment, since Access 2007 and 2010 does not support importing data from Web Services. Users may need to write VSTO code and VBA code to call the web services. It will be very helpful if Access supports importing data from Web Services.

   

   Figure: Adding Import from Web Services functionality

   Related link

Microsoft FrontPage

1. Why can't I add custom tag's to the FrontPage validator?

   In Tools - Page Options, users should be able to add custom tags. (eg missing span). Currently I need to switch to Dreamweaver to use this functionality.

   

   Figure: Not in Front Page 2002...

   

   Figure: ...nor in Front Page 2003 Beta 2

2. FrontPage should support ASPX and ASCX files. (Thank you. Fixed in FrontPage 2003 Beta 2)

   In the Normal view there should be a GUI component to show a reference to an aspx include file - currently it is too easy to delete code like this (because you dont see it in the designer).
   

   

3. Where is the strikethrough option? (it is in Word)

   Right click the menu - Customize. No Strikethough option to drag onto the toolbar.

   

   Figure: Strikethrough command does not appear in the list

4. Move a picture from here please

   Need a button under "Browse...", named "Move" picture and when I click it, it defaults to CurrentFolderOfPage/Images/..

   

   Figure: No 'Move...' button here.

5. Captions For Images

   Microsoft Word currently supports attaching captions to embedded images, as seen in the following screenshot. This cannot be done with embedded images in Microsoft FrontPage, however. It would be useful if users could add captions to FrontPage images as well.

   

   Figure: Microsoft Word's image pop-up menu includes Caption command.

6. CSS comments

   This is clearly a comment and Show Color Coding is checked on, yet the comments are not in green like all other Microsoft development environments.

   

   Figure: Comment text not green, even while 'Show Color Coding' is checked.

7. MailTo: Links

   The mailto: link supports a body parameter. This should be editable in the hyperlink dialog.

   

   Figure: Body parameter not allowed.

8. Last Saved By

   I love editing web pages using FrontPage directly from Internet Explorer. However doing it this way can cause concurrent editing problems, as it doesn't recognise which user is making the changes. You can see that the the "saved to the server by ..." field is blank. You don't get this problem if you open the file in FrontPage from Windows Explorer directly. Unfortunately there is no work-around to this bug.

   

   Figure: Editing in FrontPage from Internet Explorer potential causes concurrent editing problems

Microsoft PowerPoint

1. Captions for images

   Microsoft Word currently supports attaching captions to embedded images, as seen in the following screenshot. This cannot be done with embedded images in Microsoft PowerPoint, however. It would be useful if users could add captions to PowerPoint images as well.

   

   Figure: Microsoft Word's image pop-up menu includes Caption command.

2. Help me understand PowerPoint 2010 disabled options

   The disabled options have me confused?

   1. Change the source file (from the original .avi you selected)
   2. Change the starting point (say start at 30 seconds)

   I can see that those toolbar options are disabled (below) but I cannot see the reason.

   

   Figure: Why can't I 'Trim Video' but others can http://www.dkszone.net/how-to-embed-format-and-edit-videos-in

   

   Figure: Why are these options in the toolbar disabled?

   Other related resources that did not help:
   1. http://techie-buzz.com/office-2010/embed-videosaudio-in-powerpoint-2010-presentations.html
   2. http://office2010.microsoft.com/en-au/powerpoint-help/what-s-new-in-powerpoint-2010-HA010336563.aspx

3. Check for template updates

   If you have a PowerPoint using an older version of a template and want to:

   1. See what version you are using
   2. Migrate to the latest version

   Can I not have an option to 'Check for Updates' for the template, instead of starting a fresh new PowerPoint and importing the slides over?

   

   Figure: Why can't we check for layout updates?

4. Add default ticks and crosses

   We have a Rule on using ticks and crosses for bullet points but currently we have to map to an image as a bullet point and it is a long, frustrating process.

   Why not have default ticks and crosses available?

   

   Figure: There is a default tick available but we need a cross as well

Microsoft Outlook

1. OutLook Time Zone

   Outlook currenly uses 12 AM to 12 PM for All Day Events. This creates problem when it is for different time zone.

   It would be useful to use additional time zone feature in outlook to display local time zone without changing time of operating system. Either you can change all day event to local time zone setting.

   One best option to handle with this problem is storing all time zone using UTC(Universal Cordinated Time) so that there is no need for any other time settings and appointment can be rendered using local time zone.

2. Change "All Day Appointment" to be an all day appointment

   Currently Outlook uses 12AM to 12PM to signify a full-day event - this causes problems when you change time zones.

   A full-day event is a full-day event, no matter what time zone your are in.

   Ken Getz says more on this:
   Time Zone Disaster--All Outlook Appointments Bite the Dust

3. Image size

   When I put pictures into an Outlook HTML email, they are much less quality and significantly larger, even though Outlook reports that they are 100%.

   More information at: More Outlook HTML Email Problems