本帖最后由 liuzhaoyzz 于 2017-11-30 15:58 编辑
精简版本的office2007双击多个xls文件会打开多个excel进程,从而导致不同进程之间复制粘贴公式异常,从进程A复制,粘贴到进程B之后,只有最终结果,没有了原来的公式。
各个精简版本的office2007似乎都有这个问题。
有没有大佬能够解决?
原因应该是DDE,微软似乎为每个版本的office2007定制了dde消息,对注册表的dde参数进行了加密。
HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command\command为reg_multi_sz,是加密的。
- Windows Registry Editor Version 5.00
- [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\open]
- @="打开(&O)"
- [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\open\command]
- @=""C:\\Program Files (x86)\\Microsoft Office\\Office12\\EXCEL.EXE" /DDE"
- "command"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,\
- 21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\
- 00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,\
- 24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,61,\
- 00,54,00,4f,00,35,00,20,00,2f,00,44,00,44,00,45,00,00,00,00,00
- [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\open\ddeexec]
- @="[open("%1")]"
- [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\open\ddeexec\application]
- @="Excel"
- [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\open\ddeexec\topic]
- @="system"
复制代码
- Windows Registry Editor Version 5.00
- [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\open]
- @="打开(&O)"
- [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\open\command]
- @=""C:\\Program Files (x86)\\Microsoft Office\\Office12\\EXCEL.EXE" /DDE"
- "command"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,\
- 21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\
- 00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,\
- 24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,61,\
- 00,54,00,4f,00,35,00,20,00,2f,00,44,00,44,00,45,00,00,00,00,00
- [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\open\ddeexec]
- @="[open("%1")]"
- [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\open\ddeexec\application]
- @="Excel"
- [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\open\ddeexec\topic]
- @="system"
复制代码 |