Duplicate format date and time

Duplicate format date and time

Posted by: gagandeep.singh on 25 October 2023, 1:17 pm EST

• 

  gagandeep.singh

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 October 2023, 1:17 pm EST

  Hi there,

  I am using some date-time formats in spread Js but it shows some if them as duplicate in it.

     let newDateFormats = ["M/d/yyyy HH:mm tt", "M/d/yyyy HH:mm:ss tt", "HH:mm tt", "HH:mm:ss tt",
          "dddd, MMMM d, yyyy HH:mm tt", "dddd, MMMM d, yyyy HH:mm:ss tt", "ddd, d MMM yyyy HH:mm tt",
          "MMMM, yyyy", "MMMM", "MMM", "MMMM d", "MMMM d, yyyy", "MMM d", "MMM d, yyyy", "MMM, yyyy",
          "M-d-yy", "M/d/yy HH:mm:ss tt", "M-d-yy HH:mm:ss tt", "M-d-yy HH:mm tt", "MMM ' yy", "MMM d' yy",
          "MMMM", "MMM", "MMMM d", "yyyy",
      ];
  
      // Get the culture info instance
      let culture = new GC.Spread.Common.CultureInfo();
      let en_culture = GC.Spread.Common.CultureManager.getCultureInfo('en-us');
      culture.predefinedFormats = Object.assign({}, en_culture.predefinedFormats);
  
      // Add new Date formats
      culture.predefinedFormats.Date = culture.predefinedFormats.Date.concat(newDateFormats);
  
      // get current culture name
      let cultureName = GC.Spread.Common.CultureManager.culture();
  
      //set infos for this culture
      GC.Spread.Common.CultureManager.addCultureInfo(cultureName, culture);

  How can I fix this

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 26 October 2023, 12:57 am EST

  Hi,

  As I can understand, when you are adding some date formats in the culture then there are some duplicate date formats.

  Please note that with the code line culture.predefinedFormats = Object.assign({}, en_culture.predefinedFormats) you are assigning all the properties of en_US culture info object(en_culture) to newly created culture object(culture). Here, it is important to note that the already set en_US culture info object already has some date formats defined in its en_culture.predefinedFormats.Date property. So, when you use the code line culture.predefinedFormats.Date = culture.predefinedFormats.Date.concat(newDateFormats);, the newly created culture object(culture) will have date formats from the en_US culture as well as from newDateFormats array and there can be some duplicate date formats.

  So, you should only add additional date formats that are not present already in the en_US culture object.

  sample: https://jscodemine.grapecity.com/share/EeoXuHOz6kahYEqFH0j_bw/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Please let us know if you face any issues.

  References:

  CultureInfo class: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Common.CultureInfo
  
  CultureManager class: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Common.CultureManager

  Regards,
  
  Chandan