https://bugs.documentfoundation.org/show_bug.cgi?id=96707
Bug ID: 96707 Summary: EDITING: Calc "Data => Form" is useless and dangerous! Product: LibreOffice Version: unspecified Hardware: x86 (IA32) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: burnu...@gmail.com In Calc the form in "Data => Form" looks like in Excel, but does not work like Excel! https://support.office.com/en-us/article/Simplify-data-entry-with-a-data-form-00bfc75e-f675-46ad-8703-291fc03e4d77 In Excel there is (at least until Excel 2003) no check for Data => Validity while entering new values. (Makes the whole form not very useful.) But it has a search function ("Criteria") And it is safe: 1.) Cells with a formula inside cannot be changed in the form. Formula is copied. 2.) Data => Validity is checked before writing the new values in the table In LibreOffice there is also no check for Data => Validity while entering new values. And ther is NO search function. (Which in combination makes it totally useless.) AND it is dangerous: 1.) Cells with a formula inside are changed to entered values, formula is killed! 2.) Data => Validity is NOT checked before writing the new values in the table (So you can overrule the Validity check with the dataform!) The quick solution: Delete the function "Data => Form" ... or make it at least safe to use ... and useful too! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs