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
