Completed
Last Updated: 26 Aug 2026 12:27 by ADMIN
Release 2026.3.826 (2026 Q3)
ADMIN
Nikolay Demirev
Created on: 15 Apr 2016 09:53
Category: Spreadsheet
Type: Bug Report
0
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
ADMIN
Dimo
Posted on: 04 Jul 2016 12:37
(for popularity measurement's sake) requested in ticket #1046809

Dimo, Kendo UI team