[Libreoffice-bugs] [Bug 121210] IMPORT: No possibility to set Auto Value to a Integer Primary Key when importing Calc range

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121210

Drew Jensen <drewjensen.inbox at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|TABLEWIZARD: No possibility |IMPORT: No possibility to
                   |to set Auto Value to a      |set Auto Value to a Integer
                   |Integer Primary Key         |Primary Key when importing
                   |                            |Calc range

--- Comment #1 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Setting the field to Integer(Autovalue) which becomes an IDENTITY would also
automatically create that PK. 

In the case of importing from a Calc this could lead rows with duplicate values
in the Calc column not importing.

Is this a better solution than importing all the rows?

With all the rows in the database then if the user adds a PK for that column of
data the step of doing so will give an error should a duplicate arise, offering
the user the chance to fixup the value as needed.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181106/75ea2404/attachment.html>