https://bugs.documentfoundation.org/show_bug.cgi?id=158426
Bug ID: 158426
Summary: Number of columns should be limited in Calc data entry
form
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
While testing tdf#158211 (a duplicate of tdf#131560), one can face performance
problems by doing select all, and then choosing "Data > Form".
Steps to Reproduce:
1. Open Calc
2. Press ctrl+a to select all cells
3. Choose "Data > Form" from menu bar
Actual Results:
LibreOffice hangs for a few minutes. When the dialog box appears at last, it is
still unresponsive.
Expected Results:
LibreOffice should respond immediately, as no heavy process is active.
Reproducible: Always
User Profile Reset: No
Additional Info:
The problem is likely because of the excessive number of columns, as they
appear in the dialog box as line edit widgets. Limiting the number of possible
columns can help avoid this problem.
In MS Excel, when the number of selected columns is too much, a warning message
is displayed: "Too many fields in the data form". The maximum number of columns
is 32. This is clarified in these links:
https://answers.microsoft.com/en-us/msoffice/forum/all/too-many-fields-in-the-data-form/4ad69e07-524b-40c7-a520-746f4562bc01
https://www.timeatlas.com/excel-data-form
--
You are receiving this mail because:
You are the assignee for the bug.
