Bug 94786 - I am unable to refresh or auto refresh Pivot table in Libre office 5.0.2, could you please help me on this.
Summary: I am unable to refresh or auto refresh Pivot table in Libre office 5.0.2, cou...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.2.2 release
Hardware: All All
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-05 13:29 UTC by Raghava
Modified: 2015-11-24 20:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample document on Pivot table (10.00 KB, application/vnd.ms-excel)
2015-11-24 12:15 UTC, Raghava 		Details
printscreen (117.25 KB, image/png)
2015-11-24 20:06 UTC, raal 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Raghava 2015-10-05 13:29:32 UTC 
I have basically 2 Major issues with Libre office 5.0.2 that is 

1. I am unable to refresh Pivot table in Libre office 5.0.2, could you please help me on this.
2. I tried creating a Pivot table with filters, saved and closed the document then again if I open the file all the filters will be resets to normal position.


Is there any SOLUTIONS to get free from these issues.

----
Thanks and Regards,
Raghava
Comment 1 raal 2015-10-05 20:52:47 UTC 
Hello,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you

I can not reproduce with LO 5.0.2.2, win7
Comment 2 Raghava 2015-11-09 08:53:44 UTC 
Hi Raal,


Sorry for the late reply I don't have any screenshot as I have tried to get that for you but unfortunately i am helpless so could you please look into this issue and get me the solution ASAP.


---------
Thank and Regards,
Raghava
Comment 3 raal 2015-11-09 09:00:07 UTC 
Hello,
please attach testing spreadsheets with pivot table. I can not reproduce with my test files. Describe steps how to reproduce problem.
Comment 4 Raghava 2015-11-24 12:15:14 UTC 
Created attachment 120761 [details]
Sample document on Pivot table

Hi Raal,

As per your request, I have attached a sample document for you. As you can see from that file that I have entered 7 entries for the first time and created pivot table for every cell(I mean to say all the cells of sheet).

In this case when I add 8th entry and navigated to the pivot table tab and tried refreshing the pivot table. 

Result:- The entry(8th) which I have added at the last is not reflected.

I hope I have given enough clarification to you. Please let me know if you any other queries.


----------
Thanks and Regards,
Raghava
Comment 5 raal 2015-11-24 20:06:53 UTC 
Created attachment 120769 [details]
printscreen

Hello,this is not a bug. Change the source to: $Sheet1.$A$1:$C$9