Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Sun Oct 01, 2017 8:54 pm

Hi, there is some problem with Pivot Table. Attachet file - is a result of code:

Code: Select all
 CellRange source = ws.Range[first_table_row, 1, last_row_used-1, ws.LastColumn];

PivotCache cache = workbook.PivotCaches.Add(source);

var wsPT = workbook.Worksheets.Create("Сводная1");

PivotTable pt = wsPT.PivotTables.Add("Сводная1", ws.Range["A2"], cache);


Im marked column 20 in the file. If i delete it - it will be OK, file after making Pivot opens without any errors. Difference of this column - there are floating point numbers. GetCellType of thet column gives "Number". May be comma (RU culture format numbers) causes that problem. How can i FIX it?

P.S. try to change system standard of floating point from "," to "."...nothing changed
Attachments
rep_task_coef_salary_1(2).rar
(23.21 KiB) Downloaded 215 times
Last edited by rvkstudent on Mon Oct 02, 2017 3:49 am, edited 1 time in total.

rvkstudent
 
Posts: 4
Joined: Fri Sep 29, 2017 9:25 pm

Mon Oct 02, 2017 2:46 am

Hi,

Thanks for your inquiry.
I have reproduced the issue on my side, and posted it to our dev team for a fix. Once there is any updates for you, we will let you know. Sorry for the inconvenience caused.

Sincerely,
Nina
E-iceblue suppoprt team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.XLS