In news:aanlkti=kizvgjbsm8dn=bkhrjduxa=w7vn74=a=ng...@mail.gmail.com, Johnny Rosenberg <gurus.knu...@gmail.com> 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 > <gurus.knu...@gmail.com>: >> 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 vanillab 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 =b 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 Propertiesb for the file in Nautilus (my >> file manager) it says that it is located at: >> ftp://b619...@ftp.bredband.net/ >> >> 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 #NAME?b >> >> 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. 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. 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. 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. 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. 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>. HTH, Twayne` --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
