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: [email protected]
Reporter: [email protected]
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.
