GeneralCellType FormatString value when imported

Posted by: aspnetdev on 8 September 2017, 2:54 pm EST

  • Posted 8 September 2017, 2:54 pm EST


    In my excel sheet, I have few cells whose format is set to Date - "*m/d/yyyy". Asterisk here represents that Date format responds to the changes in regional date and time settings that are specified for the operating system. For my OS,  ShortDateFormat is set as M/d/yyyy (default value for en-US culture).

    When I import this excel into Farpoint Spread, these Date cells are imported as GeneralCellType with FormatString = "MM/d/yyyy" and IsDateFormat = True. Shouldn't the FormatString be set to "M/d/yyyy"  per my OS culture settings ?

    Now in Excel, when I change the format of these Date cells to "m/d/yyyy" (without asterisk) and import again, GeneralCellType's FormatString is correctly set to "M/d/yyyy".

    Can you please explain why GeneralCellType's formatString is not properly set when I import excel with "*m/d/yyyy" format ?



  • Replied 8 September 2017, 2:54 pm EST


    I was able to replicate the issue at my end and it seems to be a bug. I have reported the bug to the development team and the bug number for the same is #99924394. It would be fixed in the next maintenance release.


    Manpreet Kaur

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels