Does the lack of replies mean that this isn't really possible or does it only mean most people think that I am just too stupid?
Best regards Johnny Rosenberg Den 12 september 2010 18:47 skrev Johnny Rosenberg <[email protected]>: > I have some space online from my Internet provider. I put an OpenOffice.org > Calc document there and it seems like I can not open it from there. I guess > I need some guiding here. This is what I tried so far: > > My operating system is Ubuntu 10.04 but I use the ”vanilla” version of > OpenOffice.org, the most current Swedish version, OOO320m12 (Build: 9483). > > First I have tried to open other files from the same place. Those were > ordinary text files and they opened properly with Gedit (a plain text > editor) by double clicking the file directly in my file manager (Nautilus). > When I do the same with my Calc document, OpenOffice.org opens but I get an > input/output error each time I try. > Double clicking a file on that place means that it will be opened via ftp. > > Next I tried to open it via http instead. That worked well, but if I open a > new document, type ”=” in a cell and then click a cell in the http opened > document, the formula refers to a temporary file in my web browser's temp > folder rather than to the file itself. > > Well, this is what I want to achieve: > > I want one cell in a local spreadsheet display the sum of a document that I > saved online, that's it. > > I made an example document for this, located at: > http://hem.bredband.net/b619539/Test.ods > > If I click ”Properties” for the file in Nautilus (my file manager) it says > that it is located at: > ftp://[email protected]/ > > I guess that a password is required to reach it by ftp, so that's maybe why > I get an error when double clicking it. > > Anyway, now I want to calculate the sum of all numbers in my test document, > but if I open a new spreadsheet and click the SUM icon and then click the > cells of my online document, the cell contains this: > > =SUM('file:///home/guraknugen/.opera/temporary_downloads/Test.ods'#$Tabell1.A2:A9) > > And of course that's not what I want. I would guess that something like this > would work: > =SUM('http://hem.bredband.net/b619539/Test.ods'#$Tabell1.A2:A9) > > However, it doesn't. The result is: ”#NAME?” > > Is this even possible, and if it is, what does the syntax look like? > > My test document will remain online for a while (it's just a simple > spreadsheet with a few numbers in some cells) so feel free to try to make > this work, if you want. > > -- > Kind regards > > Johnny Rosenberg > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
