Context : Office 2007 in french
Problem 1
========
Value.IsDateTime always return false.
sample code (in linked sample project) :
using (var workbook = new Workbook())
{
workbook.LoadDocument(@"…\CrossRefFormulaSample2.xlsx");
var sh = workbook.Worksheets["sheet1"];
MessageBox.Show("sh[D5] is a datetime ? " + sh["D5"].Value.IsDateTime);
}
Problem 2
=======
With worksheet.Import, import a DataTable with a datetime will randomly put this date in US format or in correct culture language (french here) specified in workbook and in thread…
Hello Alexandre,
I just want to inform you that I need a bit more time to finish working on replicating the issue on our side to provide you with a precise answer.
I appreciate your patience.
Usually, we avoid discussing multiple questions within the same thread because this makes it difficult to track the entire conversation. Therefore, I have moved your next question to a separate thread: Date is randomly imported in the US or French date format.