Bug 96707 - EDITING: Data - Form does not respect Data - Validity
Summary: EDITING: Data - Form does not respect Data - Validity
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Validity Calc-DataForm
  Show dependency treegraph
 
Reported: 2015-12-24 10:57 UTC by burnuser
Modified: 2019-03-19 07:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description burnuser 2015-12-24 10:57:08 UTC
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!
Comment 1 Buovjaga 2015-12-27 16:42:40 UTC Comment hidden (obsolete)
Comment 2 Buovjaga 2015-12-27 16:45:43 UTC
Ah actually 1) is already covered in bug 59417.

So let's have this report be about 2).
Comment 3 QA Administrators 2017-01-03 19:54:58 UTC Comment hidden (obsolete)
Comment 4 burnuser 2017-01-08 10:00:38 UTC
Bug is still present. No changes in bug behavior.
Testsystem:
LO 5.2.3.3 on Windows Vista
Comment 5 QA Administrators 2019-03-18 03:45:58 UTC Comment hidden (obsolete)
Comment 6 burnuser 2019-03-19 07:33:23 UTC
Bug is still present. No changes in bug behavior.
Testsystem:
LO 6.2.1.2 on Windows 10

But there is an Extension in Beta status which maybe could solve the problem:
https://extensions.libreoffice.org/extensions/enhanced-form