I'm using XlsIO lib to populate an excel en read results in other cells. One of the formula in the excel file is formatting a date using the french format: TEXTE(G7;"jj/mm/aaaa"). It seems that the formula calculation on XlsIO is english. So the result of this formula is jj/00/aaaa.
Can we configure the excel calculation engine to use french format ? (I've tried using Windows.Globalization.ApplicationLanguages.PrimaryLanguageOverride = "fr" to override language in the application but it's not enough.
Thank you in advance for your answer.