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]
