On 2010-09-18 08:07, Johnny Rosenberg wrote:
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
Johnny:
This is a totally wild guess, but does going to Options|OOo|Security and
enabling "Passwords for
Web Connection's Persistently save passwords for web connections" make a
difference.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
