Issue 23047

Summary: CellProtection.IsFormulaHidden causes problems when sheet is protected
Product: Calc Reporter: Oliver Brinzing <oliver.brinzing>
Component: uiAssignee: spreadsheet <spreadsheet>
Status: CLOSED NOT_AN_OOO_ISSUE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1 RC5   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
CellProtection.IsFormulaHidden causes problems when sheet is protected none

Description Oliver Brinzing 2003-11-30 17:16:09 UTC 
If you copy a cell range with (ctrl)+C from a protecet sheet, and the
cell range has formula cells which have the attribute IsformulaHidden=True
then the cell values (and not the formulas) are copied to the destination.

Use (ctrl)+V to insert the range into another sheet.


This also happens if you copy via api e.g.

   oCpySheet.CopyRange(oCellCpy, oRangeOrg)

I will add an attachment ...

regards

Oliver
Comment 1 Oliver Brinzing 2003-11-30 17:16:36 UTC 
Created attachment 11646 [details]
CellProtection.IsFormulaHidden causes problems when sheet is protected
Comment 2 frank 2003-12-01 09:28:30 UTC 
Hi Oliver,

this is exactly what it should do.

As the sheet is protected and do not show formulas is active, the
formula is not shown and should not because the developer of the sheet
decided to keep the formula as secret. So this is the expected
behaviour and I close it as invalid.

Frank
Comment 3 frank 2003-12-01 09:28:46 UTC 
closed invalid