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

Reply via email to