Right now Pivot Tables cannot show the details of the selected cell inside of it. The enhancement suggestion to add this possibility has been registered earlier, I’ve added your request to it.
Unfortunately, I cannot provide ETA on this functionality yet.
As informed earlier please find the bug/issue I came across in pivot table in OO 7.5
In the attached spreadsheet "OO 7.5 Pivot Table Bug-Issue.xlsx” there are 2 columns: Date & Item
I created a pivot table using above, having fields like:
Date in Rows
Items in Values
Date format can be seen or proper format in Rows in pivot table
When details of the selected cell inside in pivot table is selected and opens up in another sheet, in case of OO 7.5 date is shown as “45216” as well header is taken from the sheet name (like: From OO 7.5) which is wrong.
To convert 45216 I need to right click on these and → Number format → Have to select Short or Long date format → then the correct/right date is shown => this is the bug I am referring to….
But when same spreadsheet is opened in MS excel date is shown properly & have added this result as well in same spreadsheet for your reference.
Hope this will be addressed soon….thank you.
Should you have any queries or need more details then please let me know.
Even though this issue is related to the newly implemented functionality, it seems to be a bit different from the original topic of this thread. I’d ask you to create a new thread with all details about the problem.
