Has anyone been able to preserve leading zeroes? It seems like everything I've tried simply hasn't been working...
excelSheet.Cell(x, y).Value = value.ToString() - still defaults to a vanilla number if it detects a number, chopping off zeroes
excelSheet.Cell(x, y).DataType = XLCellValues.Text - trying to force it to text makes has no impact, it simply reverts back to a number upon assignment and by then it's too late as the leading zeroes are gone
excelSheet.Cell(x, y).Style.NumberFormat - not all the normal options for handling seem to work, for example NumberFormatId 49 or simply using "@" simply replaces numbers with an @ symbol instead of what it's supposed to do?
Even forcing it to use a fixed length number, e.g. NumberFormat = "00000" doesn't seem to work even though that would pretty useless to me for this particular need as the length is variable anyway. Am I doing something blatantly wrong here?