Apache OpenOffice (AOO) Bugzilla – Issue 98105
Paste cell on two sheets, sheet protection destroyed
Last modified: 2013-01-29 21:39:50 UTC
Can reproduce it with DEV300m37 on WinXP and Fedora How to reproduce it 1 Open a new Calc document and enter characters in any cell, e.g. 'test' in A1 2 Tools - Protect Document - Sheet, input password and hit OK button 3 Select cell A1 and copy it 4 Click sheet2, then 'CTRL+click sheet1', to pitch on sheet1 and sheet2 5 On sheet2, select cell B5 and CTRL+V to paste from clipboard (namely from A1 in sheet1), switch to sheet1 Result Cell B5 on sheet1 has the same character with sheet2 B5, what I want to say is sheet1's protection destroyed. But, if I try to edit sheet1, it still show "Protected cells an not be modified" Expectation At step 5, paste action can't paste character in sheet1. Regards Li Meiying