Apache OpenOffice (AOO) Bugzilla – Issue 87246
Opening of spreadsheet after last inserted line of old and newly write protected contents
Last modified: 2014-01-12 12:41:53 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 spreadsheet. 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.
Definitively not a defect. @robertvivoda: 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.
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 practitioner. 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.
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"?
Thankyou for your response. Questions. 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. Regards Robert
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 -> Protection'). I will try to find a volunteer who will create a BASIC program.
Hi, I am writing to see if any volunteers have been found to write the LOG BOOK mode code Regards Robert.
reassigning features and enhancements to user requirements@openoffice.org which will be the default owner for those tasks (was introduced some time ago)
Useful suggestion.