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
+1 for the message.
Came up in the live stream and yes, seems like the right thing to do.
Hossein committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/07203b8ed8cc7a392c196b695c9a5c60955b732b tdf#158426 Limit field columns for data form to 32 It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.