You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/08/08 11:55:29 UTC
[Bug 120495] New: 'file:///xxx'
https://issues.apache.org/ooo/show_bug.cgi?id=120495
Priority: P3
Bug ID: 120495
Assignee: ooo-issues@incubator.apache.org
Summary: 'file:///xxx'
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: Windows XP
Reporter: argasoft@argasoft.it
Hardware: All
Status: UNCONFIRMED
Version: AOO 3.4.0
Component: editing
Product: spreadsheet
In DDE() function you can build the link with other functions and cell
contents.
Shouldn't it be possible also for 'file:///xxx'? (unless it is already possible
and I did not find out how).
Thanks.
Arnaldo
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120495] 'file:///xxx'
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120495
Shan Zhu <sh...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120495] 'file:///xxx'
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120495
--- Comment #2 from Shan Zhu <sh...@gmail.com> ---
(In reply to comment #0)
> In DDE() function you can build the link with other functions and cell
> contents.
> Shouldn't it be possible also for 'file:///xxx'? (unless it is already
> possible and I did not find out how).
>
> Thanks.
>
> Arnaldo
Hi, Arnaldo
If your means use DDE() to get content from another file, you can tried like
this:
Get cell content
=DDE("soffice";"E:\New Spreadsheet.ods";"sheet1.B2")
Get content from named range
=DDE("soffice";"E:\New Spreadsheet.ods";"RangeNameString")
Get content from section in a .odt file
=DDE("soffice";"e:\New Document.odt";"SectionNameString")
...
Thanks
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120495] 'file:///xxx'
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120495
--- Comment #3 from argasoft <ar...@argasoft.it> ---
Hi Shan Zu (hope it's your name).
What I mean is that, for example, in data validation you can tell to make you
choose from drop-down list obtained with: 'file:///C:/dir/file.ods#sheet.A1:A10
(hope digits are correct), i.e., you have to type the whole thing (or have it
done by selecting an area in the specific file/sheet).
I wonder if it is or could be possible (as enhancement) to build up the
'file:///...' statement using also function like you can with DDE().
Here what I mean:
A1 = C:/Docs/Works/2012 --> standard directories
A2-A10 = specific file name with or w/out other specific directories to
complete the address
B2-B10 = could contain the specific sheet name
C2 value OK if picked from a list defined with something like
=CONCATENATE("'file:///";A1;A2;".ods'#";B2;".D1-D100").
On some summary sheets I use
=DDE("soffice";CONCATENATE(A1;A10;".ods");"sheet2.A1").
Hope I've been able to explain it.
Thanks for you msg.
Arnaldo
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120495] 'file:///xxx'
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120495
Rob Weir <ro...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |INVALID
--- Comment #4 from Rob Weir <ro...@apache.org> ---
Our Bugzilla issue tracking system is for reporting reproducible defects in
Apache OpenOffice. For "how to" questions, configuration questions or general
technical support issues I recommend that you use our Community Support Forum
to ask your question. You can find the Forum at http://forum.openoffice.org
Then close issue as RESOLVED/INVALID
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120495] 'file:///xxx'
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120495
Shan Zhu <sh...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |shanzhu33@gmail.com
--- Comment #1 from Shan Zhu <sh...@gmail.com> ---
(In reply to comment #0)
> In DDE() function you can build the link with other functions and cell
> contents.
> Shouldn't it be possible also for 'file:///xxx'? (unless it is already
> possible and I did not find out how).
>
> Thanks.
>
> Arnaldo
Hi, Arnaldo
If your means use DDE() to get content from another file, you can tried like
this:
Get cell content
=DDE("soffice";"E:\New Spreadsheet.ods";"sheet1.B2")
Get content from named range
=DDE("soffice";"E:\New Spreadsheet.ods";"RangeNameString")
Get content from section in a .odt file
=DDE("soffice";"e:\New Document.odt";"SectionNameString")
...
Thanks
--
You are receiving this mail because:
You are the assignee for the bug.