• Arigion@feddit.de
      link
      fedilink
      English
      arrow-up
      16
      ·
      edit-2
      1 year ago

      Which actually is better than Excel. Currently I have to work with Excel. Gosh, how bad it got. Especially CSV import and cell formating. They really worked on being incompatible to even basic data formats just to keep you in their eco system. Try to import a UTF-8 CSV where the delimiter and the number format differs from the system settings. It completely fucks up your data and you have to import it as text and then you have to format each colum separately. Because changing the format from text to number does NOT change the view. You have to update each column manually. FU MS. There are comedy videos about number formatting in Excel: https://youtu.be/yb2zkxHDfUE?si=CtYMI-5FsU2bPZUF

      • zerosignal@lemmy.world
        link
        fedilink
        English
        arrow-up
        2
        ·
        1 year ago

        Power Query might solve your problem. You can do a text to columns with as many custom delimiters as you want.

        • Arigion@feddit.de
          link
          fedilink
          English
          arrow-up
          3
          ·
          1 year ago

          Thanks for trying to help. But that’s the point. They make something which was easy deliberately overly complicated. The next step will be that they force you to discuss the csv import with ChatGPT for 5 minutes. And every time you’ll hear: well ok, this step now is more complicated, but we gave you a mighty tool which can do SO much more.