在不知道引用格式的情况下,通常用以下方式来处理:
1、打开需要进行连接的两个表格;
2、复制表格中所需的数据(单元格/区域);
3、在"选择性粘贴"中将源数据链接粘贴到另一个表格中;
可以发现,格式形如:
- =DDE("soffice","/home/lynx/Desktop/工作相关/物料需求.ods","物料需求.B34")
在OOo帮助文档中关于DDE function的解释如下:
------------------------------------------------------------
DDE
Returns the result of a DDE-based link. If the contents of the linked range or section changes, the returned value will also change. You must reload the spreadsheet or choose Edit - Links to see the updated links. Cross-platform links, for example from a OpenOffice.org installation running on a Windows machine to a document created on a Linux machine, are not allowed.
Syntax
DDE("Server"; "File"; "Range"; Mode)
Server is the name of a server application. OpenOffice.orgapplications have the server name "Soffice".
File is the complete file name, including path specification.
Range is the area containing the data to be evaluated.
Mode is an optional parameter that controls the method by which the DDE server converts its data into numbers.
Mode | Effect |
0 or missing | Number format from the "Default" cell style |
1 | Data are always interpreted in the standard format for US English |
2 | Data are retrieved as text; no conversion to numbers |
------------------------------------------------------------
其二,在OOo中文指南中有介绍,连接为:
(http://ooo.pingju.org/wiki/Calc:%E5%BC%95%E7%94%A8%E5%85%B6%E4%BB%96%E6%96%87%E6%A1%A3)
格式:
- ='file:///Path & File Name'#$SheetName.CellName
例如:
- ='file:///home/lynx/Desktop/工作相关/物料需求.ods'#$物料需求.B34
当然方法二比较简单,并且若是在同一个目录地下的excel文件,则可以简写为: ='物料需求.ods'#$物料需求.B34
(可是我在lotus symphony下怎么就是试不出来第二种方法呢)
转载于:https://blog.51cto.com/lynxz/754375