[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 Heiko Tietze changed: What|Removed |Added Resolution|--- |WORKSFORME Status|NEEDINFO|RESOLVED -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 --- Comment #5 from Robert Großkopf --- (In reply to Cor Nouws from comment #4) > from comment 3, this looks as a WFM? The only possibility, which isn't implemented, is to create an autoincrement primary key at this moment. But this is bug 130345 or bug 121210. … but as this moment (LO 7.2 / LO 7.3) the import wizard is mostly unusable (bug 147174). This bug has been reported for LO 7.0.0.3. So I would say: WFM. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 Cor Nouws changed: What|Removed |Added CC||c...@nouenoff.nl --- Comment #4 from Cor Nouws --- from comment 3, this looks as a WFM? -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||7174 -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 --- Comment #3 from Robert Großkopf --- (In reply to michael from comment #0) > > - select an existing column to serve as the primary key (or multiple ones > for a compound primary key) This is already implemented: in Step 3 of the wizard you will see on the left the columns. Now mark one (ore more by holding SHIFT) fields, right mouseclick and set "Primary Key". > - add a new column with an auto-incremented value to serve as the primary > key (à la Access) See the other bug descriptions for this. Importing from Calc doesn't allow to create a new column at all at this moment. Importing with autovalue has never worked, so it has been impossible to create a table with primary key and autovalue for Firebird, because you couldn't change such a field in Firebird to autovalue. > - proceed without a primary key This is already implemented. A popup appears when trying to save without primary key, and asks, if a PK should be created. Pressing "No" will save the table without PK. But Base will only read this tables in the GUI. There couldn't be changed data through the GUI, only per direct SQL or macro. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||1210 -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||0345 -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 Heiko Tietze changed: What|Removed |Added Status|NEW |NEEDINFO -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 Heiko Tietze changed: What|Removed |Added CC||rob...@familiegrosskopf.de --- Comment #2 from Heiko Tietze --- We have two workflows: "Use Wizard to Create Table..." providing various options to set-up the primary key and "Create Table in Design View" with a confirmation box allowing to create another "ID" field (one of the options with the wizard). I don't get the point with "importing data into a new table". (In reply to michael from comment #0) > Suggested improvement: when a user tries to add a new table without a > primary key, give them the following options... Users have all options when using the wizard but only a limited yes/no choice for the other workflow. But it's always possible to edit a table and to set another primary key is just a click away (right click at the row header). See also https://help.libreoffice.org/7.3/en-US/text/shared/guide/data_tabledefine.html Don't see much room for improvement. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||79045_79...@mail.ru Status|UNCONFIRMED |NEW Ever confirmed|0 |1 Blocks||120255 --- Comment #1 from Roman Kuznetsov <79045_79...@mail.ru> --- Agree Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=120255 [Bug 120255] [META] Base feature enhancements -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 140267] Improve primary key creation when creating/importing a table
https://bugs.documentfoundation.org/show_bug.cgi?id=140267 Buovjaga changed: What|Removed |Added Whiteboard| QA:needsComment| Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org -- You are receiving this mail because: You are on the CC list for the bug.
