Last Updated: 31 Oct 2018 08:06 by ADMIN
Nikolay Demirev
Created on: 15 Apr 2016 09:53
Category: Spreadsheet
Type: Bug Report
Spreadsheet: Exception is thrown when importing document containing custom number formats with date or time part and with more than one section
LocalizableException with text "Format string is not in the correct format.", with inner ArgumentException "Format string is not in the correct format." is thrown. 

Currently the validation doesn't allow number format string starting with date or time formatting to have more that one section (for negative and zero numbers). Excel allows this type of number formats and if you set format like dd/mm/yyyy;[RED](#.##0); the positive numbers are visualized as dates, but negative numbers are visualized as numbers and their fore color is red.

Examples (including the final semicolons):

- ss;

- dd;

- dd/mm/yyyy;;

- mmm-yy;mmm-yy;_-* "-"??_-;_-@_-
1 comment
Posted on: 04 Jul 2016 12:37
(for popularity measurement's sake) requested in ticket #1046809

Dimo, Kendo UI team