Friday, December 10, 2010

Bugs and Annoyances in Office 2011

Last updated: 18:21, 13 December 2010

This list is in no particular order. I don't use Outlook or Communicator and thus probably won't run across problems with them. Let me know if there are solutions...

All:
  • The installer (and subsequent updates) require quitting Safari to finish.
  • The preferences windows, although similar to System Preferences in layout, contain a "Cancel" and "OK" button instead of a red x at the left top. When in one of the sections, clicking OK closes the entire preference window instead of the current section.

Word:
  • Bug: New windows don't open flush to the edge of the screen and menubar
  • The Find shortcut now takes you to a search section on the toolbar like the Google search section in Safari.
  • Bug: Assigned shortcuts sometimes refuse to work without restarting Word.
  • Hidden characters are blue when displayed.
  • Bug: If a document does not have focus, it can't be scrolled (neither two-finger scroll nor Cmd-click scroll).

Excel:
  • Bug: Cmd-A does not select all when editing text in a cell.
  • Bug: Cmd-Left doesn't skip to the beginning of a cell and Cmd-Right to the end when editing text in a cell. Cmd-Up does not move to the beginning of the text, but Cmd-Down moves to the end.

Visual Basic Editor:
  • VBE retains in the menu the application name that opened it. To exit VBA, you have to select the application menu (that says, for instance, "Word") and choose "Close and Return to Microsoft Word".
  • VBE doesn't show up as a separate program on the dock and can't be accessed with Cmd-Tab.
  • Bug: Cmd-` will rotate through the windows until it reaches your document (without changing focus), and then refuses to rotate back to VBE windows.


Thursday, December 2, 2010

How to Fix Broken Bullets in OpenOffice for Mac

This tends to happen when opening a .doc(x) file in Writer, or after saving it as a .doc(x) file from Writer then reopening the file. A temporary fix is to unbullet then rebullet the text, but upon saving and reopening, the broken bullets will return. For some, the character looks like a black clapperboard but for me (and in most other documented cases), the broken character looked like this:
Broken bullet character (size 197) retrieved with Unicode Hex Input keyboard (E000)

This has been filed as a bug since at least 2003, and the current bug thread, started in 2008, can be found here. It has something to do with a dependency on the Windows Symbol font, but I don't know why it hasn't yet been fixed.

I found a simple workaround in the openoffice.org forums here that worked for me. The post I used explained that one could copy the symbol.ttf font from Windows to do this, but the author also generated a version of the font to avoid licensing issues, which I've linked below. Here's how to fix it:
  1. Download symbol.ttf.
  2. Right-click on OpenOffice.org.app and choose "Show Package Contents".
  3. In the new window that comes up, navigate to Contents/basis-link/share/fonts/truetype/ and copy symbol.ttf into this folder.
  4. You should now see bullets correctly.