Connecting to another data file through spreadsheet

Discuss the spreadsheet application

Connecting to another data file through spreadsheet

Postby Jasper1106 » Fri May 16, 2008 5:06 pm

Hi guys,

Firstly I would like to point out I am a complete noob when it comes to spreadsheets I know very basic forumula and how to fill in cells and change the colours .... that's as far as it goes.

A friend made this spreadsheet for me, however I have alot of duplicates that I would like to read off just one part of the file.

From row 22 - 160 I would like this data to be called from a seperate file. When I change the values from this second file the rest of the spreadsheet should change according to the exisiting forumlas.
Is this possible? I work with web design a lot so in this case it would be called through an "iframe, or ajax" but I'm not sure of the terminology for spreadsheets or whether it's even possible.

I have spied the menu item: ---> Insert ---> Link to External Data - however when I try to link the secondary file and highlight the table names I get the error "Unable to insert Row".

Can anyone point me in the right direction, I'm very lost? Many Thanks in advanced for any help!
Jasper1106
 
Posts: 3
Joined: Fri May 16, 2008 4:56 pm

Re: Connecting to another data file through spreadsheet

Postby Villeroy » Fri May 16, 2008 5:43 pm

Sorry, it is absolutely unclear what you have (data and office version) and what you want to achieve.
It seems to be another case of a spreadsheet misused as database. Paste some example rows (or relevant parts of), tell us what makes a duplicate (same name, same part number, ID or entirely identical rows) and why you need to use more than one file (this makes things more complicated).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Connecting to another data file through spreadsheet

Postby Jasper1106 » Fri May 16, 2008 6:00 pm

Villeroy thank you for your very quick response!

Sorry! It's hard to explain when you know what you want to do but not sure how to explain.

I thought I attached this last time.

I'm using office version: 2.1

Please download the attachment and see rows 22 - 160

I would like this range of rows to be a seperate file and for the spreadsheet to call and update accordingly.
I have maybe 60 spreadsheets like the one attached, if I wanted to change the "Material Infomation" say the cost/unit for "Isogen" the spreadsheet then alters all the figures accordingly.
My problem is I do have 60 sheets like this for different items and don't particular want to update the material information 60 times.

I would like to try and run the material information seperately which is then called into each spreadsheet so the changes I make to the seperate file then applies automatically across all 60 files.....

Does this make a little more sense or have I confused things further? :oops:
cruiser_caracal.zip
Spreadsheet Example
(94.77 KiB) Downloaded 84 times
Jasper1106
 
Posts: 3
Joined: Fri May 16, 2008 4:56 pm

Re: Connecting to another data file through spreadsheet

Postby Villeroy » Fri May 16, 2008 10:28 pm

A horde of 60 online gamers? In a real world economy nobody would use 60 spreadsheets. An online database (like this forum) would allow for editing one set of tables simultanuously by 60 users with fine grained access privileges for users and groups. Forget about spreadsheets.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Connecting to another data file through spreadsheet

Postby Jasper1106 » Sat May 17, 2008 12:45 am

Hi Villeroy,

Thanks for your input. Is there anyway I can link part of a spreadsheet into another spreadsheet or have I misinterpeted the "link to external data" option?
Undoubtedly there are easier ways of doing this but I would like to try and get this working within a spreadsheet, are you saying this functionality doesn't exist?

Many Thanks.
Jasper1106
 
Posts: 3
Joined: Fri May 16, 2008 4:56 pm

Re: Connecting to another data file through spreadsheet

Postby kingfisher » Sat May 17, 2008 2:36 am

Villeroy's tutorial may help: [Tutorial] External Links In Calc
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests