LIbreoffice Calc, referencing files without path?
Hey everyone!
I need some help, I have 3 files in a folder, which have referenced cells to each other (or more precisely, one gets data from the other two).
However, I have to use the full path to make it work, which will be a problem since I need to put these files in a USB drive and use them both in a Windows computer and a Linux computer.
What I need is a way to get the referencing between files to happen in the same directory (reason being some people will only update one file and not the others, my own file will do the compilation).
I am already lucky that everyone agreed to do it with LibreOffice, instead of Microsoft Office, so I really want to make it work!
Thanks for any help.
In the link below it says: "The reference is always shown absolute. It will nonetheless be saved relative to the document if the respective option is chosen. Of course, both the files must be located under a common node of a file system tree."
https://ask.libreoffice.org/t/referencing-a-cell-in-other-document-using-relative-path/24288
Not sure what you mean exactly by "I have to use the full path to make it work", though. I thought it might be similar to the situation referred to on that page.
That seems to be the same issue I was having, yes!
I was using the mouse to point and click when referencing, and the full path was being shown. I was unaware that there was an option to save the relative path even when showing the full one.
I will have to try it tomorrow (don't have the Windows machine with me right now) but I am hoping it will work.
One question though, what does it mean (in that same link you provided) the "named range" thing? Is it when you give a different name to a sheet inside a file?
I am using those actually... but could give those up if absolutely necessary :(
A named range is just a human-readable name for a range of cells in Calc. For example, if I name the range A1:A100 "data", I can use MAX to get the maximum value with a simple formula: =MAX(data)
Good example.
Yes, that would make sense!
And seeing as I didn't do that (I honestly didn't know it was possible, lol), I should have no problem... Great!
If all goes well, I should be able to save the documents in my USB drive and use them in any machine we need. Even lend it to another colleague if necessary, and it will work for them too.
Thank you so much for the help, I will get back to you after testing! :D
It should be. I stole it from someone else. I only steal good stuff.
Ahahahahah!
(I'll bet you also stole that joke, that was a good one!)
Thanks.
I would believe that the "named range" refers to the possibility to give a name to a subset ("range") of cells within a sheet. Simply changing the name of the sheet does not modify the structure of the document, only the name of an existing element (that sheet).
Of course, the only way to be sure is to try.