https://bugs.documentfoundation.org/show_bug.cgi?id=132518
Andreas Heinisch <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from Andreas Heinisch <[email protected]> --- Unfortunately, there are some flaws in the pivot table especially with date and time. Some testing code: bool ScSheetDPData::IsDateDimension(sal_Int32 nDim) { CreateCacheTable(); const ScDPCache::ScDPItemDataVec& rItems = aCacheTable.getCache().GetDimMemberValues(nDim); for (const ScDPItemData& rItem : rItems) { if (rItem.GetType() == ScDPItemData::Type::Date) { return false; } } return true; } However, in initFromCell in dpcache.cxx there is no check for a date/time cell, therefore the above code will not work. In addition, it conflicts with isDataDimension (Data vs Date) and causes a crash. There is even some dead code in dptabsrc.cxx [1] because isDateDimension checks only if the dimension is the first one [2]. [1] https://opengrok.libreoffice.org/xref/core/sc/source/core/data/dptabsrc.cxx?r=f528fff9#1990 [2] https://opengrok.libreoffice.org/xref/core/sc/source/core/data/dpshttab.cxx?r=f477b54e#103 -- You are receiving this mail because: You are the assignee for the bug.
