Created attachment 178057 [details] The example file in Excel 2013 and Calc master This is split off from bug 118227 When attachment 153834 [details] is opened in Calc, the date formatted contents of cells D3:D4 appear as integer numbers instead of dates formatted like: "1999.04-01" Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: bb7873cebd191143e2c0bcf944c8c777be5439dc CPU threads: 13; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: threaded
Confirm with Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 0b397d8ef0a2615e8e6202804ca2f6cb58436fa5 CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo works in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
It worked in version 4, then in version 6 import didn't worked at all - imported sheet was empty. In bibisect repo bibisect-linux-64-6.4 import started to work again, but without date formatting with this commit: 99c6c75d1436183da6a3b025530dc14d330f7a43 is the first bad commit commit 99c6c75d1436183da6a3b025530dc14d330f7a43 Author: Jenkins Build User <tdf@pollux.tdf> Date: Thu Aug 15 06:16:23 2019 +0200 source 56ffe3c0a1261cd98a3d42b8b08d5f8eb013ead4 https://git.libreoffice.org/core/+/56ffe3c0a1261cd98a3d42b8b08d5f8eb013ead4 Switch mdds to 1.5.0 and liborcus to 0.15.0. Adding CC to: Kohei Yoshida
The latest liborcus version 0.19.0 should fix this problem. https://cgit.freedesktop.org/libreoffice/core/commit/?id=a593e018d4e3033ae95353a5ac3063a8c651a158