a | 1
b | 2
c | 3
d | 4
| 10 <=== ( forumula here is =SUM(B1:B4) )
When converted to html, I see "=SUM(B1:B4)" in the output instead of 10.
- Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromFile(filePath);
workbook.CalculateAllValue();
String outputString = "";
foreach (var sheet in workbook.Worksheets)
{
using (MemoryStream mstream = new MemoryStream())
{
sheet.SaveToHtml(mstream);
outputString += System.Text.Encoding.UTF8.GetString(mstream.ToArray());
}
}
}
I have tried both the free edition, nuget edition and tried to apply the hotfix as well which appears to have converted it to a evaluation version. Nothing seems to calculate. What am I missing?
