Can't save changes to table after setting default value for INTEGER column
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
libreoffice (Ubuntu) |
Invalid
|
Undecided
|
Rolf Leggewie |
Bug Description
After setting a default value for a column of type INTEGER using the LIbreOffice Base Table Design window, it is not possible to save the changes. When pressing the save button in the toolbar, or choosing Save from the File menu, nothing happens. When trying to close the Table Design windows, upon choosing Yes on the "The table has changed. Do you want to save the changes?" dialog, nothing happens (the window is not closed). There appears to be no way to set the default value on an INTEGER column!
Changing the default on a BOOLEAN column does work.
I will attach a database which demonstrates the problem. Edit the Invoices table and try to set the default value for the ordinal or clientId columns.
ProblemType: Bug
DistroRelease: Ubuntu 11.04
Package: libreoffice-core 1:3.3.3-1ubuntu2
ProcVersionSign
Uname: Linux 2.6.38-11-generic x86_64
NonfreeKernelMo
Architecture: amd64
Date: Tue Sep 13 18:37:58 2011
ExecutablePath: /usr/lib/
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
SourcePackage: libreoffice
UpgradeStatus: Upgraded to natty on 2011-04-30 (136 days ago)
Status changed to 'Confirmed' because the bug affects multiple users.