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

Reply via email to