[sc-issues] [Issue 101866] protect sheet prevents in serting of new mathematic formulas in unprotec ted cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101866 User rainerbielefeld changed the following: What|Old value |New value CC|''|'rainerbielefeld' Ever confirmed| |1 Status|UNCONFIRMED |NEW Issue type|ENHANCEMENT |DEFECT Keywords| |oooqa OS/Version|Linux |All --- Additional comments from rainerbielef...@openoffice.org Fri Jan 1 12:32:15 + 2010 --- Reproducible with "Ooo-Dev 3.2.0 multilingual version German UI WIN XP: [DEV300m68 (Build 9474)]"! Pls. see my comments in Issue 27840, this one might be a DUP of that one. I see this as a DEFECT, because it's no problem to copy/paste objects. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101866] protect sheet prevents in serting of new mathematic formulas in unprotec ted cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101866 --- Additional comments from gar...@openoffice.org Wed May 13 08:17:12 + 2009 --- Created an attachment (id=62227) OpenOffice3 version information for issue report - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101866] protect sheet prevents in serting of new mathematic formulas in unprotec ted cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101866 Issue #|101866 Summary|protect sheet prevents inserting of new mathematic for |mulas in unprotected cells Component|Spreadsheet Version|OOo 3.0 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|garyuu --- Additional comments from gar...@openoffice.org Wed May 13 08:14:21 + 2009 --- Sheet protection being active prevents any new mathematical formulas from being added anywhere in the sheet - even in cells that have been set to 'unprotected' Scenario: I have a set of values in a spreadsheet and a couple of them took a long time for me to work out or might be difficult to follow when I return to the spreadsheet later - So I protect those couple of cells. How: I select the whole spreadsheet and do Format/Cells/Unprotect so that no cells are protected. Then I pick the couple of cells I want to protect and highlight them and set them to 'protected' through Format/Cells. Now setting the sheet to protected allows me to overwrite all cells except them two important cells. So far so good. I can type and write over most cells in the spreadsheet still, however what I cannot do is add a new formula through 'Insert/Object/Formula' (that menu option appears greyed out) Suggestion1: Protecting a 'sheet' should prevent amendments to existing formulas but allow new formulas to be added. Suggestion2: Protecting a 'sheet' should only prevent amendments to existing formulas that are anchored to a cell which itself is 'protected'. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org