When using Aspose to generate an excel file, I am handling TRUE/FALSE values which I then want to use inside some formulas. TRUE and FALSE values seem to be converted to strings and hence the formulas do not recognize them. The formulas wont work until I manually get inside each (TRUE/FALSE) cell and press enter (apparently excel detects/converts true/false values when I do this).
var sheet = book.Worksheets;
Console.WriteLine(“G5 :” + sheet.Cells[“G5”].Value + " H5 :" + sheet.Cells[“H5”].Value);
Hello, thanks for your reply.
I ran it with version 220.127.116.11 which is the latest available in the website, and still happening. What we do is we read a csv file and write it into an excel file using Aspose (GeneratedDocument.xlsx) when this is performed is when we lose the Boolean type for the cells. Effectively by double clicking the cell, Excel converts it and then the formula will work as the cells will be recognized as Booleans, but we want to avoid this as some of the Generated files are too large.
Here it is. Thanks