https://bugs.documentfoundation.org/show_bug.cgi?id=152114
Bug ID: 152114 Summary: Dates imported erroneously from Calc to Writer database fields Product: LibreOffice Version: 7.4.2.3 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: LibreOffice Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: jcs...@libreoffice.org Description: When importing dates from a Calc test table to a Writer database fields, some dates shown in Writer are different from the original dates in Calc Steps to Reproduce: To perform this test, it is used the sample Calc file attached. 1. Open a new Writer document 2. From the menu, select Insert > Field > More Fields (or press Ctrl+F2) 3. In the Fields dialog that appears, select the Database tab 4. In Add Database File, click the Browse button 5. Navigate to select the Calc file with the test data and click on the Open button. 6. In the upper-right list Database selection, a new option will be added with the name Dates 7. Click on the + sign to display the new Dates option and select the name of the sheet containing the data (Sheet1) 8. In the list on the left Data, select, for example, Database Name and click the Insert button. This step is used to register the database, so it does not matter which option you select in Data, whenever a field is inserted. 9. Close the Fields dialog 10. Show data sources with View > Data Sources menu 11. In the tree on the left side of the data sources, display Dates > Tables > Sheet1. On the right side you will see the table with the data coming from the Calc sheet. 12. To see the data better, in the data table on the right, right-click on the header of the DATE column and in the contextual menu select Column Format 13. In the Field Format dialog box, in the Category list, select Date, and in the Format list, select 31/12/1999. Click the OK button. This will display the date in the same format as on the original Calc sheet. 14. Observe the differences with the original data Actual Results: Some dates imported are different from original dates in Calc Expected Results: Same dates after importin Reproducible: Always User Profile Reset: No Additional Info: Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Version: 7.4.2.3 / LibreOffice Community Build ID: 40(Build:3) CPU threads: 1; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: es-ES (es_ES.UTF-8); UI: es-ES 7.4.2-2 Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.