When cells get user-defined format, System.NullReferenceException occurs.

[Daiki Goto]

Hello.

Please tell me why When cells get user-defined format, System.NullReferenceException occurs.

I think maybe because the double-byte characters are used in user-defined, how to read what's not in this case?



XlsIO_test_7715fb07.zip

[Manimala P]

Hi Daiki,

Thank you for your interest in Syncfusion products.

You can use the following code snippet to resolve the mentioned issue.

DateTime result = DateTime.Parse(sheet.Range["A1"].Value);
textBox1.Text = result.ToShortDateString();

Please let me know if you have any questions.

Regards,
Manimala.

[Daiki Goto]

sheet.Range["A1"] <== 'System.NullReferenceException'

[Daiki Goto]

I'm using Microsoft Office Japanese version.
This is a user-defined type [m"月"d"日"] occurs if you have specified.

[Manimala P]

Hi Daiki,

This issue is confirmed as a defect.Please follow up with incident #63206 for more details.

Please let me know if you have any questions.

Regards,
Manimala.

[Daiki Goto]

Thanks for the update.
Certainly exception no longer occurs. However, the user-defined format [m "Mon" d "Sun"] If it is, DisplayText is [m Mon d,] and I should be displayed, [m "Mon" d "Sun"] and will appear. (A waste "would be displayed.)

[Daiki Goto]

Sorry.Previous post is incorrect.

Thanks for the update.
Certainly exception no longer occurs.
However, the user-defined format [m"月"d"日"] If it is, DisplayText is [m月d日] and I should be displayed, [m"月"d"日"] and will appear. (A waste ["] would be displayed.)

[Manimala P]

Hi Daiki,

Thanks for the update.Could you please provide me the clear requirements about the date format which you want to display.

Please let us know if you have any other queries.

Regards,
Manimala.