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)