https://bugs.documentfoundation.org/show_bug.cgi?id=131560
--- Comment #2 from Paul Hodgson <p_d_hodg...@btinternet.com> ---
Created attachment 159117
--> https://bugs.documentfoundation.org/attachment.cgi?id=159117&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
