Cell Format Changed from Date to Custom Upon Selecting "Format Cells" Option

Cell Format Changed from Date to Custom Upon Selecting "Format Cells" Option

Posted by: trungvi.dungquat on 24 January 2024, 8:20 pm EST

• 

  trungvi.dungquat

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 January 2024, 8:20 pm EST - Updated 24 January 2024, 8:39 pm EST

  Dear Support Team,

  I hope this message finds you well. I am writing to report an issue encountered while using Spread JS. Upon selecting “Format Cells” Option, I have observed that the cell format is being changed from Date to Custom unexpectedly.

  Details of the issue:

  Description: When selecting “Format Cells” Option , cells formatted as Date are being converted to Custom format.
  
  Expected Behavior: The cell format should remain as Date.
  
  Observed Behavior: The cell format is changing to Custom, which is not the expected behavior.
  
  Steps to Reproduce:

  1. Import the attached xlsx.xlsx file into Spread JS, which contains cells formatted as Date.
  2. Select a cell and choose the “Format Cells” option.
  3. Observe the cell formats after applying formatting changes .

  This issue is causing inconvenience to our users and affecting the accuracy of data representation within our application. Therefore, we kindly request your prompt assistance in investigating and resolving this matter.

  Please let me know if you require any further information or assistance from our end to address this issue effectively.

  Thank you for your attention to this matter.

  Sincerely,
  
  Vi Nguyen
  
  Report.zip

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 28 January 2024, 9:45 pm EST

  Hi,

  This is the expected behavior for the SpreadJS Designer Component. For the format culture dialog, the formatter is picked from the predefinedFormats.

  For the cell C9, the format is “M/d/yyyy” which is not present in the predefined formats of the English culture (the default culture of SpreadJS), therefore, SpreadJS treats it as a custom format and show the “Custom” in the “Format Cells” dialog.

  You can simply add the mentioned format in the predefined formats for the Date. Kindly use the following code snippet:

  var culture = GC.Spread.Common.CultureManager.getCultureInfo();
  culture.predefinedFormats['Date'].push("M/d/yyyy");

  Sample: https://jscodemine.grapecity.com/share/3o7cNVLoIUWXqpv7Qp74kQ/?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["%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  You may refer to the following docs on the Customizing the Format Cells Dialog to have a better understanding: https://developer.mescius.com/spreadjs/docs/spreadjs_designer_component/customizations/designer-customize-culture

  References:

  getCultureInfo method: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Common.CultureManager#getcultureinfo

  IPredefinedFormats Interface: https://developer.mescius.com/spreadjs/api/v15/interfaces/GC.Spread.Common.IPredefinedFormats

  Let us know if you still face the issue.

  Regards,

  Ankit