class Program
{
static void Main(string[] args)
{
FileStream fs;
fs = File.Open(@"Book1.xlsx", FileMode.Open);
Workbook wb = new Workbook(fs);
var sheet = wb.Worksheets["Pivot"];
sheet.PivotTables.FirstOrDefault().RefreshData();
sheet.PivotTables.FirstOrDefault().CalculateData();
fs.Close();
wb.Save(@"Book1.xlsx");
}
}
Steps to reproduce :-
1.) execute the source code attached above.
2.) the excel sheet book1.xlsx which is attached originally does not have any extra line.
3.) after the execution of the code go to the file and open it —> /bin/debug/book1.xlsx
4.) you will see an extra line in the pivot table. when do a refreshAll manually from the sheet the extra line goes away.
@hi.shobhit76,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.
This issue has been logged as
CELLSNET-48475 - Pivot table refresh is not working properly
In the attachment, we didn’t find your test file. But we simulated a test file named “a.xlsx” according to your picture, but we can’t reproduce your issue. Can you provide your test file? a.zip (110.7 KB)
This is to inform you that your issue has been resolved now. We will provide you the fixed version within the next few days after performing QA and incorporating other enhancements and fixes.
The issues you have found earlier (filed as CELLSNET-48475) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao