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.