cross-posted from: https://lemmy.world/post/33569521

Does anyone know why the “render” of the data would be wrong? I changed it from the US format to the ISO 8601.

Edit: Adding some spaces in the equation helped.

  • InternetCitizen2@lemmy.worldOP
    1·
    11 months ago

    The reference date (the date that 0 represents) is not set as you expect.

    It is not clear to me what this means. But my data was typed in rather than imported from somewhere else if that matters.

    • jbrains@sh.itjust.worksEnglish
      6·
      11 months ago

      I don’t remember what LibreOffice calls it, but there is an option to choose which dates are the starting points for counting, so that 0 corresponds to different dates for reasons of compatibility with other spreadsheet systems. Yours is not set to what you’re expecting.

      One of the options is 4 years 1 day later than the LibreOffice standard, which explains why those dates are off by that much.

      There is a setting per workbook and possibly a global setting that would affect all new workbooks until you change it.

      Search the web for something like “1904 date option LibreOffice Calc” and you’ll find out the details. Good luck.