Created attachment 142289 [details] pivot table showing the date format problem steps to reproduce: - use demo *.csv/*.odb data file from: "Bug 117813] *.csv database:changing character set needs a disconnect" https://bugs.documentfoundation.org/show_bug.cgi?id=117813 - create a pivot table as shown in attached picture -> the date format is lost, the date is displayed as a serial number
(In reply to Oliver Brinzing from comment #0) > Created attachment 142289 [details] > pivot table showing the date format problem > > steps to reproduce: > > - use demo *.csv/*.odb data file from: > "Bug 117813] *.csv database:changing character set needs a disconnect" > https://bugs.documentfoundation.org/show_bug.cgi?id=117813 How? > - create a pivot table as shown in attached picture > -> the date format is lost, the date is displayed as a serial number How? We need steps.
- download data.odb and data.csv from https://bugs.documentfoundation.org/show_bug.cgi?id=117813 - Tools/Options.../LibreOffice Base/Databases [New...], [Browse...], select "data.odb" [OK] - calc menu Data/Pivot Table/Create... (*) Data Source registered in LibreOffice [OK] - Database [data ] Type [Table] Data Souce [data ] [OK] - add [Datum] to "Column Fields" [OK]
Thanks! I could repro, but not in 3.6.7 -> regression. Arch Linux 64-bit Version: 6.2.0.0.alpha0+ Build ID: dc9ee533dc707cc10b99d537eaccc3ee5aa555fe CPU threads: 8; OS: Linux 4.16; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded Built on June 16th 2018 Arch Linux 64-bit Version 3.6.7.2 (Build ID: e183d5b)
Already in 4.4.7 (Win 10). I tried in 4.3.0, but it crashed when I was trying to create the pivot table!
With Linux 44max repo, oldest and latest commit crash on pivot table "Ok". Tried stepping 500 commits backwards from latest and it crashed as well.
*** This bug has been marked as a duplicate of bug 83720 ***