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.

Fri Feb 24, 2017 3:28 pm

I'm evaluating Spire and have thrown a barrage of random tests at it. I came across a bug that probably is a fringe scenario but I figured it would be worth mentioning.

I've attached a file that makes use of random values in several columns, the random values appears to reference a value that is overwritten or random values are calculated per unique formula and re-used.

Either way you get a very different type of result than opening the excel document in Excel

Almost forgot to mention, this effect was obtained in VB using:

sheet.ExportDataTable(sheet(range), True, True)
Attachments
RandomValues.zip
Random Values
(197.96 KiB) Downloaded 282 times

david.thompson@agencybloc.com
 
Posts: 2
Joined: Thu Feb 23, 2017 3:35 pm

Mon Feb 27, 2017 4:03 am

Hi,

Thanks for your inquiry and sorry for late reply as weekend.
I have noticed that the value of the method ExportDataTable has some issues, and posted it to our Dev team.
Once there is any update, we will let you know. Sorry for inconvenience caused.

Sincerely,
Betsy
E-iceblue E-iceblue support
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Fri Mar 03, 2017 9:58 pm

No problem, thank you for the follow up!

david.thompson@agencybloc.com
 
Posts: 2
Joined: Thu Feb 23, 2017 3:35 pm

Mon Apr 24, 2017 6:13 am

Hi,

Thanks for waiting.
Now the issue has been fixed in Spire.XLS Pack Version:7.12, welcome to use it.
Looking forward to your feedback.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS