<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Data/Form provides access to cells that are protected" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131560#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Data/Form provides access to cells that are protected" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131560">bug 131560</a> from <a class="email" href="mailto:p_d_hodgson@btinternet.com" title="Paul Hodgson <p_d_hodgson@btinternet.com>"> Paul Hodgson</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=159117" name="attach_159117" title="Example spreadsheet">attachment 159117</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=159117&action=edit" title="Example spreadsheet">[details]</a> Example spreadsheet Assumptions concerning desired function: 1. When creating a database which contains 'derived vales' (e.g. a column with a value computed from other columns in the row) the user should only have to need the formula in the rows that are currently present, and the system should replicate the formulae to new rows when added. The user should not need to copy the formula down to future rows to some indeterminate row number. 2. Similarly for data validation, cell format, protection etc. The spreadsheet (Data Form example.ods) contains a sheet designed to be used as a table to record values and provide a total of values in some of the cells. It also provides lookup for data validation on 2 of the entries (Class numbers based on a selection in the second sheet). It has formulae for lookup of the teacher names (VLOOKUP from the second sheet). It has a formulae for calculating the Total performance. The total performance cells are protected, The sheet is protected, but allows the insertion of new rows. When opening Data/Form (see screenshot "Data form example 1.jpg"): 1. The protected cell is open for entry, meaning you can change a protected value (that you could not do in the sheet) 2. The cells with formulae are open for entry (see screenshot "Data form example 2.jpg"). And the value can be changed irrespective of the formula. And the formula is not applied so no calculation is done and the value entered may violate the formula relationship (Note: formulae are handled as disabled fields and show the calculated value in Excel) 3. No validation is applied to the cells that have it in the main sheet, so any value may be entered despite the validation applied in the main sheet (see screenshot "Data form example 3.jpg"). Ancillary noted items (unrelated) found whilst preparing the example: 1. If I click the "Clone Formatting.." button in the ribbon bar the cursor turns to a 'Paint Pot', if I right click on a cell and select "Clone Formatting" it does not.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>