| View previous topic :: View next topic |
| Author |
Message |
antani.78
General User
Joined: 29 Aug 2007
Posts: 5
|
 Posted: Wed Aug 29, 2007 12:42 am Post subject: external date |
 |
|
good morning and sorry for my english...
i have this question:
i need a tool like "external data" of microsoft excel
i mean: i have a shared file on server (file type *.csv)
and i need to use it in a worksheet without blocking the original file
(if this file is open, when another useer try to manage it receive an error message)
so: in microsoft excel there is a command that import this data and reload this original data as i would
i tryed to do the same with oo
FILE ---> HELP PROCEDURE ---> ORIGIN DATA BOOK
select file, but it doesn't work.
so please if someone camn help me i appreciate them very much
thank's a lot |
|
| Back to top |
|
 |
acknak
Moderator
Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W
|
| Posted: Wed Aug 29, 2007 8:28 am Post subject: |
|
|
Try Insert > Sheet from file
This will load the CSV data without "opening" the CSV file as a document. |
|
| Back to top |
|
|
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Wed Aug 29, 2007 12:24 pm Post subject: |
|
|
| acknak wrote: | Try Insert > Sheet from file
This will load the CSV data without "opening" the CSV file as a document. |
Don't forget to check the Link box!
Insert - Sheet from File makes a copy of the data, but if you check Link, you get the option to refresh your copy from the original location every time you open your spreadsheet file.
For automatic (timed) refresh you need to use a different option: Insert - Link to External Data. You'd have to convert your csv file, though, as this only works for named tables from html files and for named ranges in spreadsheet files from OOo or Microsoft Office.
Alas, there is no builtin realtime update... |
|
| Back to top |
|
|
antani.78
General User
Joined: 29 Aug 2007
Posts: 5
|
| Posted: Fri Aug 31, 2007 6:17 am Post subject: RE: |
|
|
thank you veryvery much, i think this is a good solution, i will try if its fit for me,
just another thing, how i can upgrade/refresh the data?
where is the command that i can use?
thank's again.
 |
|
| Back to top |
|
|
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Fri Aug 31, 2007 6:23 am Post subject: |
|
|
| Edit > Links... |
|
| Back to top |
|
|
antani.78
General User
Joined: 29 Aug 2007
Posts: 5
|
| Posted: Fri Aug 31, 2007 8:34 am Post subject: |
|
|
yes i found it...
thank you very very much.
RAFFAELE
|
|
| Back to top |
|
|
|
