Description: I am trying to use the LIST function to produce a list of all rows in a column of a table called artist. So I made the following query: SELECT LIST (“artist_name”) FROM “artist” It returns the concatenated rows but also a lot of strange squares. I've posted a help request in the community with a screenshot and some more details. Link to the thread: https://ask.libreoffice.org/t/trouble-with-the-list-aggregate-function-firebird/67430) Steps to Reproduce: 1.Created a table called "artist" with a INT primary key and a VARCHAR column called "artist_name". 2.Tried to query using the command SELECT LIST (“artist_name”) FROM “artist” Actual Results: I got the result "Stan Lee□□□□□□□□,□□□□□□□□□□□□□□□Jack Kirby□□□□□□,□□□□□□□□□□□□□□□Dick Ayers□□□□□□" Expected Results: I should have received the result "Stan Lee, Jack Kirby, Dick Ayers" Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.2.0.4 (x64) / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-US (pt_BR); UI: pt-BR Calc: CL
Created attachment 174591 [details] Databased used when the bug was found. The small database I was using. Try using LIST with the table artist.
Created attachment 174592 [details] A print screen of the bugged result. The bugged result I've received.
Have tested this with OpenSUSE 15.2 64bit rpm Linux. Couldn't reproduce the bug with the attached database. As written in ask.libreoffice it seems to be a special Windows bug. So Windows tester needed. Note: The result has to be "Stan Lee,Jack Kirby,Dick Ayers" without spaces, because there isn't defined a separator in the query SELECT LIST (“artist_name”) FROM “artist”. The result you got in Windows, also when starting in Safe Mode, adds many squares to the expected result.
On Win10 with master sources updated some days ago, I don't reproduce this. Could you give a try at https://wiki.documentfoundation.org/QA/FirstSteps ?
Created attachment 174653 [details] I got this new result after LibreOffice reinstall The new result after LibreOffice reinstall
So I've tried to follow most of the steps in https://wiki.documentfoundation.org/QA/FirstSteps. 1. First I removed and reinstalled LibreOffice. I've posted a print of the new result - now the squares disapeared but I still get lots of empty spaces. I consider it somewhat an improvement lol 2. I wiped my user profile and the only thing I did afterwards was to enable experimental features (so I could use Firebird with LO Base and work on the database). No changes. 3. The string I get in Help-About libreOffice is Skia/Vulkan; VCL: win. Have no idea what it means. 4. Removed all fonts downloaded in the last couple of days (only 2 actually). No changes. The other steps seems to be related to Calc and/or Linux, so I didn't followed.
Whoa I wiped clean my Windows Installation and now the issue seems to be resolved.