Base: trying to set limits in queries gives an 'unexpected token' error

Bug #1623254 reported by mattebuntu
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
libreoffice (Ubuntu)
New
Medium
Unassigned

Bug Description

When I'm trying to set a limit in a query about how many records it should display I get an 'unexpected token' error, whether I input the value manually or choose it from the dropdown menu.

ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: libreoffice-core 1:5.1.4-0ubuntu1
ProcVersionSignature: Ubuntu 4.4.0-36.55-generic 4.4.16
Uname: Linux 4.4.0-36-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.1
Architecture: amd64
CurrentDesktop: Unity
Date: Tue Sep 13 17:40:45 2016
ExecutablePath: /usr/lib/libreoffice/program/soffice.bin
InstallationDate: Installed on 2016-06-14 (91 days ago)
InstallationMedia: Ubuntu 16.04 LTS "Xenial Xerus" - Release amd64 (20160420.1)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

Revision history for this message
mattebuntu (mattebuntu-deactivatedaccount-deactivatedaccount) wrote :
Revision history for this message
penalvch (penalvch) wrote :

Matteo Paolini, thank you for reporting this and helping make Ubuntu better.

1) Could you please provide an example Base file?
2) Could you please provide a keyboard click-for-click of how to reproduce?
3) Could you please provide a screenshot of the error?

Changed in libreoffice (Ubuntu):
importance: Undecided → Low
status: New → Incomplete
Revision history for this message
mattebuntu (mattebuntu-deactivatedaccount-deactivatedaccount) wrote : Re: [Bug 1623254] Re: Base: trying to set limits in queries gives an 'unexpected token' error

To reproduce the bug:

1) Create a new query in design mode and add a table

2) add either all or some fields to the query by double clicking on the
list of fields that has appeared

3) set a limit to how many records should be displayed, either by
entering a value manually in the box at the top that says "All" or by
selecting a suggested value from the dropdown menu beside said box

4) run the query by pressing f5

normally it should display the records from the selected table equal to
the value that I set previously, but instead I get an "unexpected token"
error.

On 15/09/16 06:13, Christopher M. Penalver wrote:
> Matteo Paolini, thank you for reporting this and helping make Ubuntu
> better.
>
> 1) Could you please provide an example Base file?
> 2) Could you please provide a keyboard click-for-click of how to reproduce?
> 3) Could you please provide a screenshot of the error?
>
> ** Changed in: libreoffice (Ubuntu)
> Importance: Undecided => Low
>
> ** Changed in: libreoffice (Ubuntu)
> Status: New => Incomplete
>

Revision history for this message
penalvch (penalvch) wrote :

Matteo Paolini:
1) Was this an issue in a prior LibreOffice version?
2) Would testing the latest version of LO provide a WORKAROUND via https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-5-2 ?

Changed in libreoffice (Ubuntu):
importance: Low → Medium
Revision history for this message
mattebuntu (mattebuntu-deactivatedaccount-deactivatedaccount) wrote :

1) I don't know unfortunately, the only Libreoffice version I've used is 5.1

2) even after upgrading the bug still remains.

On 15/09/16 22:41, Christopher M. Penalver wrote:
> Matteo Paolini:
> 1) Was this an issue in a prior LibreOffice version?
> 2) Would testing the latest version of LO provide a WORKAROUND via https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-5-2 ?
>
> ** Changed in: libreoffice (Ubuntu)
> Importance: Low => Medium
>

penalvch (penalvch)
Changed in libreoffice (Ubuntu):
status: Incomplete → New
tags: added: ppa
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.