3 ms·

LibreOffice Calc: "SEPT-2" is a date, "SEPT2" is not.

• mcv 6y ago
  Do they change the data or only the representation? Several people here argued that LibreOffice preserved the original data, which would be a pretty fundamental difference in this context.
  • erAck 6y ago
    SEPT-2 is changed to date (that is how all major spreadsheet software works if an input is accepted as date), SEPT2 is kept as text as entered.
    • erAck 6y ago
      And actually it depends on the locale you work in whether SEPT is a valid month abbreviation or not.
• wesleywt 6y ago
  Some biologist will write a gene as Sept-2. Its best to change the name so that its not a date.