• JoBo@feddit.uk
    link
    fedilink
    English
    arrow-up
    41
    ·
    1 year ago

    It’s no good having this as part of the user options. It should be a sheet characteristic and the default should be “keep cells exactly as entered regardless of data type”.

    • kalleboo@lemmy.world
      link
      fedilink
      English
      arrow-up
      13
      arrow-down
      6
      ·
      edit-2
      1 year ago

      Changing the default will break the workflows of tens of thousands in the business industry

      Scientists should be using something like MATLAB, not Excel.

      • RheingoldRiver@kbin.social
        link
        fedilink
        arrow-up
        3
        ·
        1 year ago

        You could make a new filetype, default new versions to it, & not break compatibility. Wouldn’t do anything for existing workbooks, and keep xlsx an option, but “it would break compatibility” is not a be-all end-all argument against this.

      • JoBo@feddit.uk
        link
        fedilink
        English
        arrow-up
        4
        arrow-down
        1
        ·
        1 year ago

        They’re not doing their analysis in Excel. MATLAB solves no problems here?