This is one of three related issues in Data to Text feature, all caused by commit 5b808448dc79e996efa7cb5082145d4e5803daa6, similar to bug 168252 - but all use different code paths, so I split them, to allow test each separately. 1. Register a database using a spreadsheet (ODS) with a date column. 2. Create a text document. 3. View -> Data Sources; expand the ODS datasource, and select its table with the data column. 4. Select a row in the right-hand table in the datasources panel 5. Click [Data to Text] button on the panel's toolbar. 6. Select "Table" at the top; select the date column name in the Database columns list, and press [ > ] button, then press [OK]. => the inserted text in the table shows +2 days.
https://gerrit.libreoffice.org/c/core/+/190758
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/24b2d4d00c8ed5cfc1d16000dd8a0048271e9c22 tdf#168349: fix "standard" date in SwInsertDBColAutoPilot::DataToDoc (3) It will be available in 26.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-25-8": https://git.libreoffice.org/core/commit/9b34799cb351ad1d6e8567ce4a8f6e99006e7fb3 tdf#168349: fix "standard" date in SwInsertDBColAutoPilot::DataToDoc (3) It will be available in 25.8.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.