Public bug reported: I imported an ODS spreadsheet into Libreoffice Base, which created a table named "Sheet1". Right-clicking on Sheet1 shows an "Edit" feature, but this just listed the table's schema and doesn't allow me to actually edit anything. There's no clear way to rename tables.
I tried going to Tools->SQL and running: ALTER TABLE "Sheet1" RENAME "MyTable"; but this returns the error: 1: syntax error, unexpected ALTER, expecting BETWEEN or SQL_TOKEN_IN or SQL_TOKEN_LIKE After converting an ODS spreadsheet to a ODB database, I would expect full ability to edit table schema. ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: libreoffice-base 1:3.5.4-0ubuntu1.1 ProcVersionSignature: Ubuntu 3.2.0-32.51-generic 3.2.30 Uname: Linux 3.2.0-32-generic x86_64 NonfreeKernelModules: wl nvidia ApportVersion: 2.0.1-0ubuntu14 Architecture: amd64 Date: Sat Nov 3 11:25:52 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64+mac (20111012) SourcePackage: libreoffice UpgradeStatus: Upgraded to precise on 2012-05-10 (176 days ago) ** Affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug precise -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1074679 Title: Unable to rename tables or alter schema in Libreoffice-Base To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1074679/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs