1. Create a spreadsheet 2. Put there some data in column A, like data 1 2 3 3. Select the column A, copy to clipboard 4. Create a new embedded database (no matter which engine, say, HSQLDB) 5. In Tables view, right-click in "Tables" area, and select "Paste" The "Copy table" dialog has "Create new field as primary key" checkbox disabled. This is a regression after commit 3f8e50f9b2fb35db190ce0204981f3f02d1d5ae6, worked fine in 7.1.
On pc Debian x86-64 with master sources updated today, I could reproduce this. I gave a try with https://gerrit.libreoffice.org/c/core/+/145151
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/5effc24969e5f326ef094419631d14d4d3030ed6 tdf#152900: "Create new field as primary key" disabled... It will be available in 7.6.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.
Caolán already cherry-picked the patch for: 7.5 branch: https://gerrit.libreoffice.org/c/core/+/145119 7.4 branch: https://gerrit.libreoffice.org/c/core/+/145120 so let's put this one to FIXED then.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/4288b9a2cc5f70cebf6124db0b47277a4581e305 tdf#152900: "Create new field as primary key" disabled... It will be available in 7.5.0.2. 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.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/f2d3658697f22090ee138cebda4d10c3ede21230 tdf#152900: "Create new field as primary key" disabled... It will be available in 7.4.5. 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.
7.4.5 was a hotfix release, updating target in status-whiteboard
*** Bug 147174 has been marked as a duplicate of this bug. ***