GeneralCellType FormatString value when imported

Posted by: aspnetdev on 8 September 2017, 5:54 am EST

  • Posted 8 September 2017, 5:54 am EST


    In my excel sheet, I have few cells whose format is set to Date - "<b>*m/d/yyyy</b>". 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, 5:54 am 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 <span class="dlgtitle">#99924394</span><span class="lockmsg">. It would be fixed in the next maintenance release.</span>


    Manpreet Kaur

Need extra support?

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

Learn More

Forum Channels