Renaming spreadsheet in OpenOffice

The %20 is how web sites deal with spaces in a URL. If you title your document with spaces it may download it that way. You can always right click it after the download and choose rename to clean it up. To avoid the problem you could try using file names in Google Docs that don't have spaces or use an underscore. In my experience spaces are replaced by underscores but maybe different browsers handle it differently.

As for folders I'm not sure what you mean. Are you talking about in Google Docs? If so, you may need to check their help files. If you mean in Ubuntu you can make a new folder by right clicking on the desktop or in the file browser or sometimes by clicking the "new folder" button (which you sometimes see when saving from a web site).

I just did a quick test downloading a text document and a spreadsheet. I did not observe the issue you are referring to. My text document had spaces replaced with underscores and the spreadsheet had normal spaces. What version of Firefox are you using? I wonder if newer versions handle this better. I have 3.0.3.

I am usinfg opera as firerfox will not export any but read only spreadsheets

What I would like to do is delete all of the misnamed files and start from scratch. Also I would like to set up folders in OOo to group like spreadsheets together

You can certainly set up folders however you want but I don't know if you can do that directly in OO.o. I think you would just set up folders somewhere like your documents folder.

I've not spent much time with Opera but it may download things from Google docs differently and be the reason for the %20 instead of spaces. As for why docs end up read only with firefox I have no idea. I don't see that at all.

Jim,

This makes no sense to me, but I have stumbled onto a work around. I open a Google Spreadsheet, copy to clipboard the cells I want to export, then open a new OOo spreadsheet and paste. This imports all entries and also the functions.

This is strange. When I use Firefox to download Google Docs that have spaces in the file name to Open Document, they have the spaces changed to underscores and the files are *Saved* as Read/Write.

If you use Firefox to download and *Open* the file in OOo, you do get it opened Read Only, but this is because the file is downloaded to /temp before it is opened. So what you need to do is to immediately do Save As and save it to one of your own folders. It will then be Read/Write.

Tony

This is strange. When I use Firefox to download Google Docs that have spaces in the file name to Open Document, they have the spaces changed to underscores and the files are *Saved* as Read/Write.

If you use Firefox to download and *Open* the file in OOo, you do get it opened Read Only, but this is because the file is downloaded to /temp before it is opened. So what you need to do is to immediately do Save As and save it to one of your own folders. It will then be Read/Write.

Tony