Works now also on linux. My problem was that I did not use matices...
Rainer Am Montag, 27. Juni 2011, 19:37:42 schrieb Rainer Dorsch: > Pier, > > thanks for your quick reply. > > Wikipedia says that DDE is a windows only technology > > http://en.wikipedia.org/wiki/Dynamic_Data_Exchange > > > I do not get it working on my linux system. I am curious if somebody has a > small example running on Windows, which I could try to understand if that > is an option.... > > Thanks, > Rainer > > Am Montag, 27. Juni 2011, 18:26:49 schrieb yahoo-pier_andreit: > > Il 27/06/2011 17:05, Rainer Dorsch ha scritto: > > > Hello, > > > > > > I create *.csv files as results of a simulation program. > > > > > > I have some oocalc formulas and charts for analysing the results. > > > Reentering the formulas and charts for every new *.csv file is tedious. > > > > > > I am wondering what is the most elegant solution to achieve an > > > automation. > > > > > > I was thinking of a separate file with an analysis sheet containing > > > references to the data in the *.csv file. The downside there is that > > > there are in many cells references to the data in the *.csv file. > > > > > > I am wondering, if there is a way that I specify the filename of the > > > *.csv file in one cell of the analysis sheet and use that cell in the > > > the cells containing references to the *.csv file. > > > > > > If yes, how? > > > > > > Are there better solutions for this kind of problem? > > > > > > Many thanks, > > > Rainer > > > > something like this should solve: > > =DDE("soffice";"/path/to/your/source.csv";"sheetname.A1") > > this formula in your destination file will show the content of cell A1 > > in sheet sheetname of the file /path/to/your/source.csv > > > > or if you put in A$ /path/to/your/source.csv > > you can use: > > =DDE("soffice";A4;"Foglio1.A1") > > > > I tried something similar but in my case if the data was a lot I found > > convenient to copy the csv file in a sheet of the destination file > > > > ================================================== > > > > MESSAGGIO ISTITUZIONALE > > > > ================================================== > > Investi nel futuro. Investi nelle nostre ricerche. > > Destina il 5 x 1000 all'ENEA > > Cerchiamo: > > - nuove fonti e nuovi modi per produrre energia pulita e sicura. > > - modi migliori per utilizzare e risparmiare energia. > > - metodologie e tecnologie per innovare e rendere piu' competitivo il > > sistema produttivo nazionale. - metodologie e tecnologie per la > > salvaguardia e il recupero dell'ambiente e per la tutela della nostra > > salute e del patrimonio artistico del Paese. Il nostro codice fiscale e': > > 01320740580 -- Rainer Dorsch Lärchenstr. 6 D-72135 Dettenhausen 07157-734133 jabber: [email protected] GPG Fingerprint: 5966 C54C 2B3C 42CC 1F4F 8F59 E3A8 C538 7519 141E Full GPG key: http://pgp.mit.edu/ -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
