Den 2010-09-19 21:13:05 skrev Twayne <[email protected]>:
In news:[email protected],
Johnny Rosenberg <[email protected]> typed:
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
b%1Dvanillab%1D 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 b%1D=b%1D 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 b%1DPropertiesb%1D 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: b%1D#NAME?b%1D
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,
The lack of replies from this particular newsgroup and based on my
experience, having been here for quite some time, would be that no
one knows
a good answer to your query. In my own opinion, and if I had noticed
your
post, I would have considered it nearly devoid of useful information
to be
able to provide a good response. Quoted error messages, events after
and
before any errors or the failure to work would have been useful too.
Well, the problem is that the error message is in Swedish, so I can't
quote it exactly, but I'll give it a try:
”General input-/output error when accessing /home/guraknugen/.gvfs/ftp
as b619539 at ftp.bredband.net/Test.ods”
Something like that. This happens when I double click the document in
my ftp program, which also is my default file manager, called
Nautilus. Nautilus is the default Gnome file manager, and my operating
system is Ubuntu 10.04.
Many
are probably also wondering why you would try to edit a file still on
the
server; unless you're in very special circumstances, that would be a
definite no-no because once you saved it back to the server, the
original
would be lost to future visitors.
Well, it's just a place to have the file that both me and my wife can
access. We have no local network (yet – I will fix that in a couple of
years or so…) so this is a temporary solution. I am going to do add
stuff to the file now and then, and she only need to sum some cells
from it, therefore she will never need to open the file at all, only I
will do that.
So basically, what I want to know is:
What would a formula look like in a cell in a local spreadsheet on her
computer, that displays the sum of, let's say A2:A65536 in that
external file?
The normal process would be to download the file to your hard
drive, edit
and save it there, and then do whatever you had planned to do with the
changed file. So, assuming you are serious about what you want to do,
and
you are in a situation that would purposely allow that, I know I
would have
no idea what to tell you, so responding would be a waste of time for
both
you and I.
This is a pretty good newsgroup and assuming you're accessing it
with a
legitimate newsgroup reader, makes the question a little confusing,
at least
to me.
If anyone is calling you stupid, don't worry about it; just ignore
them.
Same with any other response. Lack of responses though are usually an
indication that you either asked a question n such a way that no one
understood it enough to even ask you for more details, or there
simply was
no one at that particular time period who could help you.
Yes, I always have quite a hard time to express myself in a foreign
language like English. Sorry for my ignorance.
And there is nothing wrong with asking the group why you ddn't get any
responses; but a tad more gently than you did here. Even if you get a
crtique you don't like, still read it anyway; they might be pointing
out
something you weren't aware of.
Well, I was just wondering and it wasn't meant to be rude or
something. I thought that since there are quite a few messages every
day maybe someone who actually knows the answer might just have missed
my question, so therefore I gave it a new try by writing again.
Also, the URL you provided was a good idea, but many people on the
first
contact won't go to an unknown URL on the chance it may contain
malware.
But, if I recall correctly, I didn't ask people to open the file, only
to create a formula that sums a few cells in it. I included
information about which cells to sum, the name of the file and the web
address. No need to open it, but maybe I should never have mentioned
that I couldn't open the file via ftp, that might have been confusing,
I guess. I described two problems in the same post, maybe that was a
huge mistake in this case. I am sorry for that, forget about the
problems opening the file, I am now, in this thread, only interested
in summing some cells from that Test.ods file I have mentioned a
couple of times.
In a local file, I want to enter something in a cell that is always
the sum of some cells in that Test.ods file.
It's also a good idea to specifically point out what it is you wish
folks to
look at, at that URL rather than just the link to it.
Some like to say "the devil is in the detail" and I think this is one
of the
times that's applicable<g>.
Yes, probably. I always want to say everything at the same time, and
it's quite impossible, as everyone else know…
