Can't Open Format Cells => Date or change culture I want

Can't Open Format Cells => Date or change culture I want

Posted by: ngodinhvuluan on 18 October 2023, 1:28 pm EST

• 

  ngodinhvuluan

  • Post Options:
  • Link
    Copy

  Posted 18 October 2023, 1:28 pm EST - Updated 18 October 2023, 1:40 pm EST

  I use SpreadJS Desginer React
  
  I add CultureInfo from sjs-globalization.
  
  i hard code cultureName = ‘vi’ and
  
  set GC.Spread.Common.CultureManager.culture(cultureName);
  
  UI dont show format Date
  
  demo-spreadjs.zip
  
  

  

  1886×892 58.6 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 19 October 2023, 5:31 pm EST

  Hi,

  You need to set the predefined formats using the CultureInfo constructor for the Designer Component for custom culture. Kindly refer to the following docs on Customizing the Format Culture Dialog: https://www.grapecity.com/spreadjs/docs/spreadjs_designer_component/customizations/designer-customize-culture

  Please note that when you set the culture in the SpreadJS, it doesn’t apply to the Designer Component.

  Kindly refer to the attached sample in which I have added the predefined date formats. Similarly, you could add the formats based on your culture.

  Let me know if you face any issues.

  Regards,

  Ankit

  myapp.zip

• 

  ngodinhvuluan

  • Post Options:
  • Link
    Copy

  Posted 19 October 2023, 6:48 pm EST

  You have any solution to get redefined formats automatic for 400+ culture

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 22 October 2023, 6:28 pm EST

  Hi,

  We are sorry, but currently, we don’t have all the predefined formats available for 400+ cultures.
  
  Currently, we don’t have the preDefinedFormats for all the cultures available. By default, the “en-US” culture is applied and the internally, SpreadJS applies the preDefinedFormats for the “en-US” culture.

  For all the other cultures, you need to add the preDefinedFormats by yourself to the cultureInfo as defined in the following docs: https://www.grapecity.com/spreadjs/docs/spreadjs_designer_component/customizations/designer-customize-culture

  Regards,

  Ankit