Issue 87246 - Opening of spreadsheet after last inserted line of old and newly write protected contents
Summary: Opening of spreadsheet after last inserted line of old and newly write protec...
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-03-19 13:52 UTC by robertvivoda
Modified: 2014-01-12 12:41 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description robertvivoda 2008-03-19 13:52:43 UTC
I would like to have as part of of the base spreadsheet a checkbox in the 
Tools/Options menun that will allow the following;

1. Open a new spreadsheet and enter a number of lines of data (for example: 
cells A1 through G6 block)
2. Save and close the spreadsheet
3. Reopen the spreadsheet with the previously entered data in cells A1 through 
G6 being automatically protected and the next input of data starting only from 
cell A7.
4. I then enter more data in cells A7 thrugh G12 and again save and close the 
5. I again reopen the same spreadsheet and this time the next available 
unprotected cell where data can be enetred is A13.

By being able to do this I can have my people entering and saving data with the 
knowledge that no person can go back and update or delete any cells containing 
data because that data is now automatically protected. I require this to meet 
legal compliance requirements.

I ask that this not be a MACRO but introduced as part of the base CALC 
spreadsheet which can be enabled in the tools/options menu but never disabled 
for that spreadsheet to meet compliance requiurements.
Comment 1 Rainer Bielefeld 2008-03-19 19:10:48 UTC
Definitively not a defect.

May I summarize for your requested ENHANCEMENT:
- When the spreadsheet will be opened
 - all cells containing data will be write protected 
 - all empty cells will be unprotected and remain unprotected until the 
   document will be closed, even if data has been inserted.
 - Caret is in Column 'A' of first line after last cell containing cata
   (= the first unprotected cell)

Pls. contribute a plausible user scenario (frequently required application) for
what this feature might be useful.
Comment 2 robertvivoda 2008-03-24 01:56:22 UTC
Plausible user scenario:

I would like to create a medical recording and compliance system using CALC. 
Practitioners from multiple medical areas can enter patient information into 
the unprotected empty cells. Different practitioners from multiple practices 
can enter data for the same patient. We need to ensure a practitioner does not 
accidentally delete information that was previously entered by another 

This enhancement will provide excellent control over patienbt information and 
prevent us from creating and maintaining a database system. Practitioners can 
View patient history and Append to it without the risk of removing or updating 
previously entered patient information.

Thank you for considereing this.
Comment 3 Rainer Bielefeld 2008-03-24 17:22:14 UTC
Indeed this feature might be useful for driver's logbook and other kinds of
logbooks, where changes in old contents should be impossible.

May be a solution with a Macro might be an first step to explore requirements
for such "logbook mode"?
Comment 4 robertvivoda 2008-03-24 21:29:14 UTC
Thankyou for your response.


1. Does a MACRO in CALC require confirmation to execute each time the 
spreadsheet is opened? I am trying to avoid this.

2. Who can create this MACRO for me. I have no skills in writing Macros.

Comment 5 Rainer Bielefeld 2008-03-25 06:48:16 UTC
I do not believe that always a confirmation is required. If the sheet is
protected, you only have to set the cells with contents to mode "protected"
(what manually can be done with menu 'Format Cells -> Cell Protection ->
I will try to find a volunteer who will create a BASIC program.
Comment 6 robertvivoda 2008-05-07 22:41:42 UTC

I am writing to see if any volunteers have been found to write the LOG BOOK 
mode code 

Comment 7 oc 2008-07-15 10:43:06 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)
Comment 8 Edwin Sharp 2014-01-12 12:41:53 UTC
Useful suggestion.