| View previous topic :: View next topic |
| Author |
Message |
Gregte
Red Pill
Joined: Aug 30, 2007
Posts: 6
|
 Posted: Wed Feb 27, 2008 1:38 pm Post subject: protect document/sheet does not work |
|
I have created a NeoOffice spreadsheet and I can use the Protect Document feature under the Tools menu. It asks me to enter a password and confirm it. I do so. Now my document is protected just as I would expect, i.e. I cannot change any cells.
Here is the problem: I go back to the Tools/Protect Document/Sheet menu item and Sheet IS checked. I select it so I can uncheck it and indeed it unchecks the word 'Sheet' but it does NOT ask me to enter a password. It simply UNprotects the sheet. No password required.
I have Saved the document under a different name and get the same results. I have saved it as a.ods file and a .xls file and still the same result.
One interesting note: It did not always do this. It did not do this yesterday but it is doing it today. I have not made any changes to anything other than the spreadsheet I am working on. I have even created another very small and simple spreadsheet and the problem persists.
Anyone else experiencing this? |
|
| Back to top |
|
 |
Gregte
Red Pill
Joined: Aug 30, 2007
Posts: 6
|
| Posted: Wed Feb 27, 2008 1:46 pm Post subject: |
|
I forgot to mention:
I am using NeoOffice 2.2.2 Patch 0
Mac OS X 10.4.10 on a MacBook |
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Wed Feb 27, 2008 2:14 pm Post subject: |
|
First of all, you should install the latest patch, i.e. Patch 11.
You get it from this page
Each patch contains all the bug fixes of the previous patches, so it's not necessary to install patches 1 to 10 before installing patch11.
Afterwards you might have a look at
this page in NeoWiki and see if your problem is solved.
Jacqueline |
|
| Back to top |
|
|
Gregte
Red Pill
Joined: Aug 30, 2007
Posts: 6
|
| Posted: Wed Feb 27, 2008 7:07 pm Post subject: |
|
Thanks, I will attempt to download the patch 11. I am on dialup so it can be problematic sometimes to download a file so large.
The NeoWiki page basically confirms what the Help file in NeoOffice says, that Sheet Protection is supposed to work differently than it is working for me which I already knew. It is supposed to require me to enter a password to UNprotect a Sheet but again, it does not do that. It does not even ask for a password, rather it just unprotects the sheet. |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
| Posted: Thu Feb 28, 2008 12:45 am Post subject: |
|
I hope you manage to install patch #11. I'm running 2.2.2 with that patch, I've just tested it and the password thing works for me the way Help says it should.
- padmavyuha |
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Thu Feb 28, 2008 3:44 am Post subject: |
|
| Gregte wrote: | Thanks, I will attempt to download the patch 11. I am on dialup so it can be problematic sometimes to download a file so large.
|
I know that's can be very unpleasant. I has been on dialup for a long time, now I appreciate my ADSL connection, even if it's not the fastest possible 
If you have problems for downloading, try "curl" following the steps described in NeoWiki. That can help a lot.
Jacqueline |
|
| Back to top |
|
|
Samwise
Captain Naiobi
Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France
|
| Posted: Thu Feb 28, 2008 5:56 am Post subject: |
|
| jgd wrote: |
I know that's can be very unpleasant. I has been on dialup for a long time, now I appreciate my ADSL connection, even if it's not the fastest possible |
Non dégroupée ? |
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Thu Feb 28, 2008 6:37 am Post subject: |
|
Non dégroupée et 620 ko/sec.
Je vis dans un minuscule village, bien heureuse d'avoir tout de même l'ADSL 
Jacqueline |
|
| Back to top |
|
|
Samwise
Captain Naiobi
Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France
|
| Posted: Thu Feb 28, 2008 6:51 am Post subject: |
|
620 Ko/s c'est out de même 5 Mbps 
Moi je suis en ville et je n'ai que 3.5 Mbps 
Par contre je vais parfois dans un chalet en France ou je n'ai que 1 ou 2 Mbps (sais plus).
L'avantage, en Suisse, c'est au moins de na pas avoir à se soucier de savoir si on est dégroupé par tel ou tel fournisseur. Les vitesses sont les mêmes pour tout le monde (3.5, 5 et 20 Mbps, par ordre croissant de prix)… |
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Thu Feb 28, 2008 7:18 am Post subject: |
|
| Samwise wrote: | | 620 Ko/s c'est out de même 5 Mbps |
Mais non, c'est 1/2 Mo. Et en plus je me suis trompée, c'est 608 pas 620. Ça ne change pas grand-chose
| Quote: |
Moi je suis en ville et je n'ai que 3.5 Mbps |
Ça c'est quand même mieux.
| Quote: |
L'avantage, en Suisse, c'est au moins de na pas avoir à se soucier de savoir si on est dégroupé par tel ou tel fournisseur. Les vitesses sont les mêmes pour tout le monde (3.5, 5 et 20 Mbps, par ordre croissant de prix)… |
Les possibilités de dégroupage ne sont pas généralisées ici. Et il y a eu pas mal de pb avec des lignes dégroupées. C'est France-Télécom qui assure l'entretien des lignes et en cas de dégroupage, je ne sais pas trop comment ça marche.
De toute façon la question ne se pose pas pour nous, ce n'est pas possible actuellement.
Mais le passage à l'ADSL nous a changé la vie
Jacqueline |
|
| Back to top |
|
|
Samwise
Captain Naiobi
Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France
|
| Posted: Thu Feb 28, 2008 8:54 am Post subject: |
|
| jgd wrote: | | Samwise wrote: | | 620 Ko/s c'est out de même 5 Mbps |
Mais non, c'est 1/2 Mo. Et en plus je me suis trompée, c'est 608 pas 620. Ça ne change pas grand-chose |
Il y a confusion. Un octet représente 8 bits. Les débits de connexion internet sont calculés en Kilobits et Mégabits par seconde (Kbps et Mbps), et non pas en Ko et Mo par seconde.
600 Ko/s équivalent à 4800 Kbps (Kilobits par seconde), soit environ 5 «Mégas». En revanche, 600 Kbps ne font que 75 Ko/s. |
|
| Back to top |
|
|
Gregte
Red Pill
Joined: Aug 30, 2007
Posts: 6
|
| Posted: Thu Feb 28, 2008 9:34 am Post subject: |
|
Well I was finally able to get a complete, error free download of patch 11 but alas it did not solve the problem. I don't know for sure what to do next but I have always managed to solve things eventually by just sticking to it.
Thanks for the help though as you have at least told me that it does work. Must be something particular to my setup. Although, like I mentioned earlier, it did work correctly for me at first. |
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Thu Feb 28, 2008 9:56 am Post subject: |
|
| Samwise wrote: |
Il y a confusion. Un octet représente 8 bits. Les débits de connexion internet sont calculés en Kilobits et Mégabits par seconde (Kbps et Mbps), et non pas en Ko et Mo par seconde.
600 Ko/s équivalent à 4800 Kbps (Kilobits par seconde), soit environ 5 «Mégas». En revanche, 600 Kbps ne font que 75 Ko/s. |
Eh oui, c'est juste que j'ai mal lu et confondu Mb et MB  .
Hélas, c'est 608 Kb, donc c'est tout petit. On fait avec
Jacqueline |
|
| Back to top |
|
|
Gregte
Red Pill
Joined: Aug 30, 2007
Posts: 6
|
| Posted: Sat Mar 01, 2008 7:35 am Post subject: |
|
I have finally figured out what the problem was.
I had been saving the file as a "Microsoft Excell 97/2000/XP .xls" file. If I save it as a .ods file then Protection works.
This also is true of certain other things that can be altered in a spreadsheet such as shadows on cell borders. |
|
| Back to top |
|
|
Lorinda
Captain Mifune
Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA
|
| Posted: Sat Mar 01, 2008 4:14 pm Post subject: |
|
Thanks for letting us know!
Lorinda |
|
| Back to top |
|
|
|
