• Arigion@feddit.de
    link
    fedilink
    English
    arrow-up
    17
    ·
    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
        4
        ·
        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.