[Libreoffice-bugs] [Bug 120129] New: EDITING: LIST function in query creates additional characters in Windows10

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Sep 26 11:46:29 UTC 2018


https://bugs.documentfoundation.org/show_bug.cgi?id=120129

            Bug ID: 120129
           Summary: EDITING: LIST function in query creates additional
                    characters in Windows10
           Product: LibreOffice
           Version: 6.1.1.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: really at freemail.hu

Description:
Using the (Firebird) LIST function in LibreOffice Base, the result contains
various number of white square (like ⬜) characters.

Steps to Reproduce:
1. Creating a table (Table)
  ID INTEGER
  Data INTEGER
2. Filling with some data
  ID Data
  1  11
  1  12
  1  13
  2  201
  2  202
  2  203
  3  3001
  3  3002
  3  3003
3. Making a query with the following sql command:
SELECT "ID", LIST( "Data", ' / ' ) FROM "Table" GROUP BY "ID"

Actual Results:
 ID LIST
 1  11⬜ / 12⬜ / 13⬜
 2  201 / 202 / 203
 3  3001 / ⬜3002 / ⬜3003

Expected Results:
 ID LIST
 1  11 / 12 / 13
 2  201 / 202 / 203
 3  3001 / 3002 / 3003


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
LibreOffice Base 6.1.1.2 (x64) / JavaSE 10.0.2 (x64) / Windows 10

Same behavior occur with different
- different data types (of "Data" column),
- java versions,
- language settings.
This "bug" is not exist in Windows7, Ubuntu 18.04, maybe only in Windows10.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180926/aeeb4536/attachment.html>


More information about the Libreoffice-bugs mailing list