Re: [users] Re: Link to External Data *.csv file?
At 03:38 19/12/2010 +, Mark Knecht wrote: Brian Barker b.m.barker at btinternet.com writes: At 20:11 18/12/2010 +, Mark Knecht wrote: Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files? [SNIP] Is there a way to do this? Yes. Use Insert | Sheet from File..., browse to the .csv file, and tick the Link box in the Insert Sheet dialogue. You'll want two sheets linked to your two data files and a third sheet (probably in front) in which to perform the comparison. I trust this helps. I think it does. I'll try it when I get back to that machine tomorrow. Let me double check one thing. If I use Insert | Sheet from File as you suggest, then is this spreadsheet updated with new data from the file anytime this spreadsheet is opened? Er, yes. If not, it wouldn't help with your problem! When you open the spreadsheet, you will see a dialogue asking if links to other files should be updated. If you wish to perform the update with the spreadsheet open, you can go to File | Reload (after saving any changes to the spreadsheet, of course) - which will stimulate the same dialogue. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Link to External Data *.csv file?
Unsubscribe me. Thank you. ---Original Message--- From: Brian Barker Date: 12/19/2010 9:47:56 AM To: users@openoffice.org Subject: Re: [users] Re: Link to External Data *.csv file? At 03:38 19/12/2010 +, Mark Knecht wrote: Brian Barker b.m.barker at btinternet.com writes: At 20:11 18/12/2010 +, Mark Knecht wrote: Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files? [SNIP] Is there a way to do this? Yes. Use Insert | Sheet from File..., browse to the .csv file, and tick the Link box in the Insert Sheet dialogue. You'll want two sheets linked to your two data files and a third sheet (probably in front) in which to perform the comparison. I trust this helps. I think it does. I'll try it when I get back to that machine tomorrow. Let me double check one thing. If I use Insert | Sheet from File as you suggest, then is this spreadsheet updated with new data from the file anytime this spreadsheet is opened? Er, yes. If not, it wouldn't help with your problem! When you open the spreadsheet, you will see a dialogue asking if links to other files should be updated. If you wish to perform the update with the spreadsheet open, you can go to File | Reload (after saving any changes to the spreadsheet, of course) - which will stimulate the same dialogue. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Link to External Data *.csv file?
Raul I. Sais wrote: Unsubscribe me. Thank you. /---Original Message---/ /*From:*/ Brian Barker mailto:b.m.bar...@btinternet.com /*Date:*/ 12/19/2010 9:47:56 AM /*To:*/ users@openoffice.org mailto:users@openoffice.org /*Subject:*/ Re: [users] Re: Link to External Data *.csv file? At 03:38 19/12/2010 +, Mark Knecht wrote: Brian Barker b.m.barker at btinternet.com writes: At 20:11 18/12/2010 +, Mark Knecht wrote: Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files? [SNIP] Is there a way to do this? Yes. Use Insert | Sheet from File..., browse to the .csv file, and tick the Link box in the Insert Sheet dialogue. You'll want two sheets linked to your two data files and a third sheet (probably in front) in which to perform the comparison. I trust this helps. I think it does. I'll try it when I get back to that machine tomorrow. Let me double check one thing. If I use Insert | Sheet from File as you suggest, then is this spreadsheet updated with new data from the file anytime this spreadsheet is opened? Er, yes. If not, it wouldn't help with your problem! When you open the spreadsheet, you will see a dialogue asking if links to other files should be updated. If you wish to perform the update with the spreadsheet open, you can go to File | Reload (after saving any changes to the spreadsheet, of course) - which will stimulate the same dialogue. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org mailto:users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org mailto:users-h...@openoffice.org Just above my comment is a link to click to unsubscribe yourself. Send the email created without adding anything. When you receive an email verifying that you wish to unsubscribe, reply to it without adding anything. Dan
[users] Re: Link to External Data *.csv file?
On 2010/12/19 4:26 PM Raul I. Sais wrote: Unsubscribe me. Thank you. You have to unsubscribe yourself. To unsubscribe, e-mail: users-unsubscr...@openoffice.org mailto:users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org mailto:users-h...@openoffice.org -- _ Larry I. Gusaas *Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese * - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Link to External Data *.csv file?
Am 18.12.2010 21:11, Mark Knecht wrote: Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files? I have two programs which generate (hopefully) identical data in CSV format. I need to check for differences on maybe a daily basis. Doing the compare is easy once I've loaded the data into Calc but I'd rather make it a link so that all I have to do is open the Calc spreadsheet, have it read the contents of the existing files and then have it do the compare. I tried inserting a Link to External Data and putting the file name in but at that point it doesn't seem to allow me to do anything. OK never becomes active. Is there a way to do this? Thanks, Mark Linux? $ vimdiff file1 file2 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Link to External Data *.csv file?
Brian Barker b.m.barker at btinternet.com writes: At 20:11 18/12/2010 +, Mark Knecht wrote: Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files? [SNIP] Is there a way to do this? Yes. Use Insert | Sheet from File..., browse to the .csv file, and tick the Link box in the Insert Sheet dialogue. You'll want two sheets linked to your two data files and a third sheet (probably in front) in which to perform the comparison. I trust this helps. Brian Barker I think it does. I'll try it when I get back to that machine tomorrow. Let me double check one thing. If I use Insert | Sheet from File as you suggest, then is this spreadsheet updated with new data from the file anytime this spreadsheet is opened? I don't want to have to do an Insert every time by hand. That's what I'm doing now, albeit using copy/paste. Thanks, Mark - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
