OpenOffice

Auto-increment field data can be changed

Bug #318341 reported by kentmcmartin on 2009-01-18

	Status	Importance	Assigned to
OpenOffice	Confirmed	Unknown	openoffice-bugs #98202
libreoffice (Ubuntu)	Invalid	Undecided	Unassigned
openoffice.org (Ubuntu)	Won't Fix	Low	Unassigned

Bug Description

Binary package hint: openoffice.org-base

ubuntu 8.04
1:2.4.1-ubuntu2.1
openoffice 2.4.1
oobase
opened a table and designated ID as a primary integer autoincremented field
Did not expect to be able to edit the value
Went in to edit the table and the ID field while listed as an integer indicates an integer length of 0 instead of the original 10.

rebooted etc., no change
deleted table and tried again, same issue.

ProblemType: Bug
Architecture: i386
Date: Sat Jan 17 18:21:35 2009
DistroRelease: Ubuntu 8.04
Package: openoffice.org-core 1:2.4.1-1ubuntu2.1
PackageArchitecture: i386
ProcEnviron:
PATH=/usr/lib/openoffice/program:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.24-19-generic i686

Tags:

Revision history for this message

kentmcmartin (kent-mtaonline) wrote on 2009-01-18:

Dependencies.txt Edit (2.9 KiB, text/plain; charset="utf-8")

Chris Cheney (ccheney) on 2009-01-18

Changed in openoffice.org:
importance:	Undecided → Medium
status:	New → Triaged

Bug Watch Updater (bug-watch-updater) on 2009-01-18

Changed in openoffice:
status:	Unknown → Confirmed

Chris Cheney (ccheney) on 2010-05-13

tags:

added: hardy

Revision history for this message

penalvch (penalvch) wrote on 2011-06-04:

kentmcmartin, could you please attach a Base file that demonstrates this problem? Does LibreOffice Base work for you?

lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

apt-cache policy libreoffice-base
libreoffice-base:
  Installed: 1:3.3.2-1ubuntu5
  Candidate: 1:3.3.2-1ubuntu5
  Version table:
*** 1:3.3.2-1ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

Changed in libreoffice (Ubuntu):
status:	New → Incomplete

penalvch (penalvch) on 2011-06-04

summary:

- autoincrement field data can be changed
+ [Upstream] auto-increment field data can be changed

Revision history for this message

kentmcmartin (kent-mtaonline) wrote on 2011-06-04: Re: [Bug 318341] Re: autoincrement field data can be changed

I switched to Access database so don't know if the problem still occurs.

On Sat, 2011-06-04 at 14:08 +0000, Christopher M. Penalver wrote:
> kentmcmartin, could you please attach a Base file that demonstrates this
> problem? Does LibreOffice Base work for you?
>
> lsb_release -rd
> Description: Ubuntu 11.04
> Release: 11.04
>
> apt-cache policy libreoffice-base
> libreoffice-base:
> Installed: 1:3.3.2-1ubuntu5
> Candidate: 1:3.3.2-1ubuntu5
> Version table:
> *** 1:3.3.2-1ubuntu5 0
> 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
> 100 /var/lib/dpkg/status
> 1:3.3.2-1ubuntu4 0
> 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
>
> ** Also affects: libreoffice (Ubuntu)
> Importance: Undecided
> Status: New
>
> ** Changed in: libreoffice (Ubuntu)
> Status: New => Incomplete
>

penalvch (penalvch) on 2011-06-05

Changed in libreoffice (Ubuntu):
status:	Incomplete → New

penalvch (penalvch) on 2011-08-13

Changed in libreoffice (Ubuntu):
status:	New → Incomplete
Changed in openoffice.org (Ubuntu):
importance:	Medium → Low

Björn Michaelsen (bjoern-michaelsen) on 2011-09-15

Changed in openoffice.org (Ubuntu):
status:	Triaged → Won't Fix

Revision history for this message

Björn Michaelsen (bjoern-michaelsen) wrote on 2011-09-15: migrating packaging from OpenOffice.org to Libreoffice

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

penalvch (penalvch) on 2011-09-19

summary:

- [Upstream] auto-increment field data can be changed
+ Auto-increment field data can be changed

Revision history for this message

Bryan Quigley (bryanquigley) wrote on 2015-01-20:

Thank you for reporting this bug to Ubuntu. This Ubuntu release has reached EOL for Desktops.
See this document for currently supported Ubuntu releases: https://wiki.ubuntu.com/Releases

Since this bug hasn't been touched in a while and the Incomplete autoclose didn't work, I'm going to close it.

If you can still reproduce on a new version of Ubuntu, please reopen it.