Description: All versions above 4.2.2. including the beta version 5.3 and above. This issue has happened before many years ago maybe when I was using OO at the time. It took months before it was corrected. I have included a link to files that will show the exact issue. Including a steps recorder so you can watch all steps taken. The bug exist on all installs across our network of users. Uninstalling and reinstalling version 5.2.2 fixes the issue. I consider this a critical bug as we will never update again until resolved. Steps to Reproduce: 1.I have included a link to files that recorded all steps 2.Happens everytime 3. Actual Results: Open writer open data connections, choose row of data, then use insert data to table. Headers work but no data is in table. Expected Results: Table should have returned data. Download examples at. OneDrive https://1drv.ms/f/s!Av5np6Tym4OUg8sO9qIQLsZ3FY1HwA Dropbox https://www.dropbox.com/sh/byc6j2wbp257sau/AACDi3aqaiJHT23xlKBPXMvMa?dl=0 Reproducible: Always User Profile Reset: No I know my profile is fine as this reproduced on five differnt installs including brand new machine. Additional Info: Please visit and download my files I know they will be helpful and clear. If this link does not work let me know and I will fix it ASAP. OneDrive https://1drv.ms/f/s!Av5np6Tym4OUg8sO9qIQLsZ3FY1HwA Dropbox https://www.dropbox.com/sh/byc6j2wbp257sau/AACDi3aqaiJHT23xlKBPXMvMa?dl=0 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36
If you cannot get my files. Please let me know and I will upload them directly as attachments. I did not know this would be an option until I saved the bug report.
After much testing using 5.3 B2 with a clean profile. I have been able to determine that the data will not return from any DB I have that gets it's connection through an ODBC data source. The ODBC data source is connected to Access 2016. When I open the db file all connections are good. I also created a new DB file that connects directly to an Access DB. I created a query then tested data to table and it worked fine. The failure has something to do with the odbc connection. It is curious that the data is there.
Yep, please attach them one by one (max. size 10MB).
Created attachment 129815 [details] Steps recorded to produce bug Per the request I am going to upload my files. Two of them are steps recorders and two of them are results.
Created attachment 129816 [details] Steps recorded to worked fine Per the request I am going to upload my files. Two of them are steps recorders and two of them are results.
Created attachment 129817 [details] This is the result when Libre bug happens Per the request I am going to upload my files. Two of them are steps recorders and two of them are results.
Created attachment 129818 [details] This is what should have happend Per the request I am going to upload my files. Two of them are steps recorders and two of them are results.
No repro with Version: 5.3.0.2 Build ID: 5ad7b2889021c491af62f7930a4b1cb631392f16 CPU Threads: 2; OS Version: Mac OS X 10.12.2; UI Render: default; Layout Engine: new; Locale: fr-FR (fr_FR.UTF-8); Calc: group using an ODBC connection (MyODBC conenctor) to a mysql remote instance on OSX. I can drag and drop either a tuple of data or the whole contents of a table or query into the Writer document and have it displayed as a table. This seems to be Windows only, and linked to Access databases via ODBC. Changing title to reflect that. I don't have such a test setup.
@Ken: I might be able to test this on a Windows 10 machine, but which ODBC driver are you using and which version of Access ?
Hello Alex Good Day to you. I am using Access 2016 with the latest available ODBC driver for 32 bit (I think).The file version is "AccessDataBaseEngine" version 14.0.6119.5000 Part of my team uses the DB as a client install with the latest Access runtime to access data within Access. I must admit I thought this thread may have been forgotten. I do think I have another clue that may help you to determine where the issue is in the code. I figured this out when testing the latest release of LO. I still try every version to see if by chance the problem has been resolved. Here is what I found out that I think will help to resolve this. If I consider that the command button "data to text" is a method to copy and paste with formatting parameters, then we may know what is wrong. Per my earlier mails and step recording it is easily noted that everything copies and paste into the writer document except the data to table. In the latest version of LO I tried highlighting data in the table then used right click to choose "copy", when I pasted to the document everything worked as if I had used the command button in Version: 5.1.6.2. Things were perfect again although not user friendly. Now for the extremely interesting part, when I went back into Version: 5.1.6.2 (working) and tried the same steps (right click etc.) the behavior mirrored what happens in the latest version of LO when using the command button "table inserts but no data". In summary what works in one version works exactly opposite in the other version. Does this help to maybe track down the root of the issue? I hope the way I have presented this makes sense. I can do a step recording if need be but hope I have painted a clear picture of the behavior and a clue to the resolution. I have a test environment and would be willing to test any possible solution.
Thanks for the info update Ken, much appreciated. When you mention the 32Bit ODBC driver, are you also using a 32bit version of LibreOffice ? My guess is that you probably are, but we should have this down in this bug report just to be sure. I will have to check on the Win10 whether I can actually access an Access2016 database to test with - my suspicion is that I won't, so I might have to try with another external database source over ODBC.
I can confirm that I use the 32 bit version of LO in all environments. MS does not do a good job of supporting 64 Bit ODBC even for their office products. 64 bit LO was problamatic in my applications so it makes sense to use 32 bit versions. You will be able to access 2016 if you install the runtime for it. The one problem is that you will need someone else to create the DB for you as the runtime will not support that function. If needed I could probably upload a stripped DB for your testing.
Can not reproduce with : LibreOffice 5412 x64 AccessDatabaseEngine_X64.exe (Dated 2016, but for Access2010) Despite my best attempts at trying to find an official Microsoft download specifically for Access 2016 databases, I couldn't find a download link that actually worked. Windows 10 1) I downloaded the Northwind example database for Access 2016. 2) I installed the AccessDatabaseEngine_X64.exe 3) I then used obdcad64 to configure a suitable DSN pointing to the Northwind database (by the way, this part didn't work if the Access database was stored in a OneDrive folder - go figure) 4) I fired up LibreOffice and chose the DB creation wizard and selected "Connect to existing database via ODBC". I was asked to select a registered DSN and chose Northwind. No password or user was required to connect to the datasource. I tested the connection and it was successful. 5) Then I saved the ODB file, opened it in LibreOffice, and opened up the first table in the list of available tables (Customers). 6) ODBC copy tests : A) I selected the first table and dragged it into a blank Writer document. The merge data wizard was started, I chose "Insert Data as Table", selected all columns of the table and then pressed OK. All of the data from the database table was copied into the Writer document as a table. B) I double-clicked on Customers table to display the data content. Then I selected one row/tuple from the table, and drag/dropped this into a blank Writer document. The merge data wizard displayed and I chose Insert Data to Table, selecting all columns from the Customers table, and pressing OK. All data from the selected tuple was inserted as a table in the Writer document. C) I repeated the steps in B, but selected multiple contiguous tuples. Then I chose to only copy over data from 4 columns of the table. All of the selected data was copied into a table in the Writer document. D) I repeated the steps in C, but selected non-contiguous records. Again, all data was correctly copied into the Writer document as a table. So, I'm afraid that this is no repro for me. From various reports I have read on the MVP forums, Microsoft does not recognize simultaneous installations of both 32bit and 64bit AccessDatabaseEngine, so I will not be trying this with the 32bit versions of ADB and LibreOffice. Note that my Access 2016 db was locally stored and not on a Sharepoint server / web db, as indicated by Ken in his example, so perhaps the difference lies there. As I understand it, Microsoft has suspended Sharepoint Access web database support from June 2017 and is forcing users to migrate to a different system. As I don't use their cloud support, I can't say how this works exactly. Setting to UNCONFIRMED. Ultimately, this is WFM with 64bit LO, 64bit ADB, and an Access 2016 db.
Created attachment 136949 [details] Screenshot to show WFM with 64bitLO, ODBC, ADB engine qnd Northwind2016 accdb