You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2019/05/02 06:45:28 UTC
[Bug 63395] New: Unable Refresh Power Pivot
https://bz.apache.org/bugzilla/show_bug.cgi?id=63395
Bug ID: 63395
Summary: Unable Refresh Power Pivot
Product: POI
Version: 3.17-FINAL
Hardware: PC
Status: NEW
Severity: blocker
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: pal.ratikanta@gmail.com
Target Milestone: ---
Created attachment 36557
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36557&action=edit
Template
Hi,
In my application I am using Power Pivot .I am reading the excel and putting
data in the table .I am able to do that.But while opening the File pivot gets
refreshed and taking lot of time .
I want to refresh the table before saving.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63395] Unable Refresh Power Pivot
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63395
--- Comment #1 from RatiKanata Pal <pa...@gmail.com> ---
Created attachment 36558
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36558&action=edit
Java File
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63395] Unable Refresh Power Pivot
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63395
Greg Woolsey <gw...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |WONTFIX
OS| |All
Status|NEW |RESOLVED
--- Comment #2 from Greg Woolsey <gw...@apache.org> ---
This isn't really a bug report or feature request. As it is a usage question,
it is better suited for the POI users mailing list.
That said, there is no code in POI to refresh a pivot table. You would need to
do that yourself in your code, making use of the POI formula evaluation
framework to manually recalculate the pivot table and update the appropriate
pivot table data structures.
You are better off letting Excel do that, and perhaps refining the dataset and
formulas to improve performance.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org