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…
--
Kind regards
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
