https://issues.apache.org/ooo/show_bug.cgi?id=120495
--- Comment #3 from argasoft <[email protected]> --- 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.
