incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 120495] 'file:///xxx'
Date Wed, 29 Aug 2012 21:04:57 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=120495

--- Comment #3 from argasoft <argasoft@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.

Mime
View raw message