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
