To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106598
------- Additional comments from kmorri...@openoffice.org Fri Jan 15 09:15:13 +0000 2010 ------- I have a workaround for this one, BUT in involves hacking into the xml files that define how OpenOffice (and StarOffice) handle keystrokes. Here are the instructions for StarOffice using OSX: 1) Quit StarOffice. 2) Use grep -r to search for the lines that map KEY_QUOTELEFT to "uno:ToggleFormula". I found: % grep -r ToggleFormula /Applications/StarOffice.app/Contents/ Binary file ./basis-link/program/libscmxi.dylib matches /Applications/StarOffice.app/Contents/basis- link/share/config/soffice.cfg/modules/scalc/accelerator/en-US/default.xml: <accel:item accel:code="KEY_QUOTELEFT" accel:mod1="true" xlink:href=".uno:ToggleFormula"/> /Applications/StarOffice.app/Contents/basis- link/share/registry/data/org/openoffice/Office/Accelerators.xcu: <value xml:lang="en- US">.uno:ToggleFormula</value> /Applications/StarOffice.app/Contents/basis- link/share/registry/data/org/openoffice/Office/UI/CalcCommands.xcu: <node oor:name=".uno:ToggleFormula" oor:op="replace"> 3) sudo, and edit any file containing a line like this one: <accel:item accel:code="KEY_QUOTELEFT" accel:mod1="true" xlink:href=".uno:ToggleFormula"/> I edited the file /Applications/StarOffice.app/Contents/basis- link/share/config/soffice.cfg/modules/scalc/accelerator/en-US/default.xml 4) delete the line (save a copy of the file somewhere else if you want to be able to recover without re- installing StarOffice). Save the file. 5) Check to see if it exists anywhere in your own library, using grep -r again: % grep -r ToggleFormula ~/Library/Application\ Support/StarOffice/9/user/ Binary file /Users/km71400/Library/Application Support/StarOffice/9/user/registry/cache/org.openoffice.Office.Accelerators.dat matches Binary file /Users/km71400/Library/Application Support/StarOffice/9/user/registry/cache/org.openoffice.Office.UI.CalcCommands.dat matches /Users/km71400/Library/Application Support/StarOffice/9/user/registry/data/org/openoffice/Office/Accelerators.xcu: <value xml:lang="en-US">.uno:ToggleFormula</value> /Users/km71400/Library/Application Support/StarOffice/9/user/registry/data/org/openoffice/Office/Accelerators.xcu: <value xml:lang="en-US">.uno:ToggleFormula</value> 6) Edit the file ~/Library/Application Support/StarOffice/9/user/registry/data/org/openoffice/Office/Accelerators.xcu. It contains xml that maps the QUOTELEFT_MOD1 to ToggleFormula. Remove the node that does the mapping. I map Shift- F9 to toggle formulas, so the file I use contains: <?xml version="1.0" encoding="UTF-8"?> <oor:component-data xmlns:oor="http://openoffice.org/2001/registry" xmlns:xs="http://www.w3.org/2001/XMLSchema" oor:name="Accelerators" oor:package="org.openoffice.Office"> <node oor:name="PrimaryKeys"> <node oor:name="Modules"> <node oor:name="com.sun.star.sheet.SpreadsheetDocument"> <node oor:name="F9_SHIFT" oor:op="replace"> <prop oor:name="Command"> <value xml:lang="en-US">.uno:ToggleFormula</value> </prop> </node> <node oor:name="QUOTELEFT_MOD1" oor:op="remove"/> </node> </node> </node> </oor:component-data> 7) Save the file, restart StarOffice, and you are done. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org