Issue 23047 - CellProtection.IsFormulaHidden causes problems when sheet is protected
Summary: CellProtection.IsFormulaHidden causes problems when sheet is protected
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC5
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-11-30 17:16 UTC by Oliver Brinzing
Modified: 2003-12-01 09:28 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
CellProtection.IsFormulaHidden causes problems when sheet is protected (5.46 KB, application/octet-stream)
2003-11-30 17:16 UTC, Oliver Brinzing 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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