Wrong data type when Clear All -> input data -> Format Cell

Wrong data type when Clear All -> input data -> Format Cell

Posted by: linh.nguyen.hoang on 16 January 2024, 3:13 pm EST

• 

  linh.nguyen.hoang

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 January 2024, 3:13 pm EST - Updated 16 January 2024, 3:18 pm EST

  When I perform Clear All for a cell and enter 1/1/1988 into that cell, it is converted to a Date. However, when I click on Format Cell, I still see the format as General → Number. Is this considered a bug?

  

  1100×804 31.5 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 16 January 2024, 8:10 pm EST

  Hi,

  This is a known difference with Microsoft Excel. When SpreadJS inputs a value into a cell, the auto-formatter policy will try to parse the inputting string to a value, and then save the auto-formatter to the cell, and the cell’s formatter is still undefined.

  However, in Microsoft Excel, when doing the same behavior, a date formatter will be applied to the cell directly.

  As a component, we should not pollute the user’s data (the cell style is kind of user data). And if you would like to do the same as Microsoft Excel, you could monitor the CellChanged Event and then set the autoFormatter to the Cell Formatter. Kindly refer to the following code snippet and sample:

  // Handle the Cell Changed Event
  spread.bind(GC.Spread.Sheets.Events.CellChanged, function (evt, args) {
      if (args.propertyName === '[styleinfo]' && args.newValue && args.newValue._autoFormatter) {
          var { sheet, row, col } = args;
          var style = sheet.getStyle(row, col);
          style.formatter = style._autoFormatter;
          sheet.setStyle(row, col, style);
      }
  });

  Sample: https://jscodemine.grapecity.com/share/9fJGzew4lEqqpvvr03oDFw/?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"}

  Regards,

  Ankit

• 

  linh.nguyen.hoang

  • Post Options:
  • Link
    Copy

  Posted 16 January 2024, 8:13 pm EST

  Thank you ! Work like a charm