Issue 114511 - Data loss in a hidden formula cell
Summary: Data loss in a hidden formula cell
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: 3.4.0
Assignee: kla
QA Contact: issues@sc
Keywords: data_loss
Depends on:
Blocks: 84405
  Show dependency tree
Reported: 2010-09-15 09:16 UTC by redflagzhulihua
Modified: 2017-05-20 10:30 UTC (History)
6 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description redflagzhulihua 2010-09-15 09:16:03 UTC
New a spreadsheet document
Input 1 in A1, return
Input =A1 in B1, return
Choose B1 and open "Cell Format" dialogue
Go to "Cell Protection" tab, uncheck "Protected", check "Hide formula"
Main menu: Tools-Protect-Sheet, set a password and click "OK"
Double click B1, press Ctrl+C or Ctrl+A
Click anywhere out of B1

The data in B1 has gone.

This issue also exists in the latest version(OOo3.3).
Comment 1 Joost Andrae 2010-09-15 16:36:46 UTC
I can confirm this. Ctrl+C shouldn't remove the formula within a hidden cell.
Reassigning to Niklas
Comment 2 Oliver Brinzing 2010-09-15 17:34:44 UTC
Comment 3 hans_werner67 2011-02-28 14:11:44 UTC
Comment 4 daniel.rentz 2011-03-01 13:03:34 UTC
patch reviewed.
Comment 5 niklas.nebel 2011-03-01 13:06:31 UTC
Fixed in CWS "calc66".
Comment 6 niklas.nebel 2011-03-15 14:24:02 UTC
Reassigning to QA for verification.
When editing, you still see an empty cell and can overwrite it, but Ctrl-C or Ctrl-A are no longer counted as modification, so in the example case, the formula remains in the cell.
Comment 7 kla 2011-03-18 15:12:22 UTC
Seen ok in cws calc66 -> verified