I noticed that if an Excel cell contains a formula to generate a random uniform variate, i.e., =rand(), that ClosedXML will only read a 0 or 1 based on rounding off to the nearest integer. Question is, can the actual formula result be read in, or can the use of a formula be detected to tell the user e.g. "Use of formulas in an input Excel files is not recommended."
Aucun commentaire:
Enregistrer un commentaire